How to get Python Script to send CSV file to specific folder location

Question

I'm currently have an API that calls to a system and produces a CSV file of data from that system. That CSV file is placed to a folder on my computer, however I would like to point it to be placed to a different specific folder on my computer.

I do not have the current folder that it is being placed in specified in the API so I'm not sure why it is being placed there.

I think that I need to change my open statement below. Is there a way for me to write a path into this clause so that it gets placed in a different folder? Or would I need to state that somewhere else?

with open("UserStory.csv", "w", newline="") as outputFile:

    writer = csv.DictWriter(outputFile, ["Number","Estimate", "Project", "CreateDate", "ClosedDate", "CompletedDate", "Sprint", "Sprint Start", "Sprint End","Planned","Team",  "BlockingIssues", "Status"])

    writer.writeheader()

Maybe you want to enter a full path for the file.

Klaus D.
– Klaus D.

2020-04-22 15:29:46 +00:00
Commented Apr 22, 2020 at 15:29 — Klaus D.
– Klaus D., Commented Apr 22, 2020 at 15:29
where would I put that in at? In the open statement?

jfreck6337
– jfreck6337

2020-04-22 15:31:41 +00:00
Commented Apr 22, 2020 at 15:31 — jfreck6337
– jfreck6337, Commented Apr 22, 2020 at 15:31

Chets · Accepted Answer · 2020-04-22 15:44:38Z

2

Specify full path of the file something like this :

file_path = '/home/user/doc/file_name.csv'

with open(file_path, "w", newline="") as outputFile:

if dir does not exist, create one using: os.mkdir(dir_path)

answered Apr 22, 2020 at 15:44

Chets

905 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Code-Apprentice · Accepted Answer · 2020-04-22 15:32:57Z

1

When you specify just a file name with "UserStory.csv" it will be stored in the so-called "current working directory". Most likely this is the same folder that contains your python script.

To save the directory in another folder, you can specify an absolute path:

with open(r"C:\Users\my_user\Documents\my_csv_files\UserStory.csv", "w", newline="") as outputFile:

I suggest you take some time to learn about directory paths. You should learn the difference between absolute paths and relative paths.

answered Apr 22, 2020 at 15:32

Code-Apprentice

84k26 gold badges162 silver badges289 bronze badges

Comments

Nathan Mathews · Accepted Answer · 2020-04-22 15:46:12Z

1

Writing to specific directory using os.path.join

import os

def write_to_dir(file, dir):
    with open(os.path.join(dir, file), "w", newline="") as outputFile:
        os.makedirs(dir, exists_ok=True) #address directory DNE 
        writer = csv.DictWriter(outputFile, ["Number","Estimate", "Project", "CreateDate", "ClosedDate", "CompletedDate", "Sprint", "Sprint Start", "Sprint End","Planned","Team",  "BlockingIssues", "Status"])
        writer.writeheader()

answered Apr 22, 2020 at 15:46

Nathan Mathews

1511 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to get Python Script to send CSV file to specific folder location

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related