Want to create a csv inside a folder if it does not exist using string parameter in python

Question

    dirLocation = "Patients Data/PatientsTimelineLog.csv"

try:
    if os.path.isfile(dirLocation):
        print("Directory exist." + dirLocation)
    else:
        print("Directory does not exists. Creating new one." + dirLocation)
        os.makedirs(os.path.dirname(dirLocation))
except IOError:
    print("Unable to read config file and load properties.")

Automatically creating directories with file output

Want to create a PatientsTimelineLog.csv inside Patients Data folder in one go if it does not exist. The above link is creating the folder but the csv file is not made. makedir is used to make directory but i want inside the file in it like the path given above in dirLocation.

Using PurePath(dirLocation) get the name of csv file in the path. Can you guide how to make that file in new created folder Patients Data? os.makedirs(os.path.dirname(dirLocation)) Above live giving none in return otherwise join can be used to concatenate file and path — Shoaib Naseer, Apr 27 '21 at 08:06
Having awareness of the path is vital. I'm not at my PC now but will give an example when I can. — Cerberton, Apr 27 '21 at 09:18

Javier A · Answer 1 · 2021-04-27T07:42:31.393

2

Inside the else, you can directly use os.makedirs(dirLocation).

When you use os.path.dirname(dirLocation) you are selecting everything except the name of the csv file. That is why you are creating only the folder.

edited Apr 27 '21 at 07:42

answered Apr 26 '21 at 12:57

Javier A

539
2
12

It creates another folder inside Patient Data. But I want csv file made inside the folder. Patient Data folder containing this file PatientsTimelineLog.csv no the filder – Shoaib Naseer Apr 27 '21 at 05:59

score 0 · Answer 2 · answered Apr 27 '21 at 10:37

try:
    folder_path = os.path.split(os.path.abspath(dirLocation))
    sub_path = folder_path[0]
    if os.path.isdir(sub_path):
        print("Directory exist: " + dirLocation)
    else:
        print("Directory does not exists. Creating new one: " + dirLocation)
        file_name = PurePath(dirLocation)
        obj = file_name.name
        filepath = os.path.join(sub_path, obj)
        os.makedirs(sub_path)
        f = open(filepath, "a")
except IOError:
    print("Unable to read config file and load properties.")

This is the answer to my question. pathlib did lot of help in this question

Want to create a csv inside a folder if it does not exist using string parameter in python

2 Answers2