Custom csv file name using to_csv Python

Question

I'm working on writing a pandas DataFrame to a CSV file using to_csv :

df.to_csv("Output.csv")

I'm looking to customize the naming of the csv file by adding the actual datetime so it should look like this : Output_2021-12-17T14:09:09Z

Any idea?

jezrael · Accepted Answer · 2021-12-17 13:17:44Z

4

Use f-strings with to_datetime and Timestamp.strftime:

print (f"Output_{pd.to_datetime('now').strftime('%Y-%m-%dT%H:%M:%SZ')}.csv")
Output_2021-12-17T13:12:58Z.csv

df.to_csv(f"Output_{pd.to_datetime('now').strftime('%Y-%m-%dT%H:%M:%SZ')}.csv")

edited Dec 17, 2021 at 13:17

answered Dec 17, 2021 at 13:12

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

Amamra Over a year ago

Hum, got this error message when trying to run this : OSError: [Errno 22] Invalid argument: 'Output_2021-12-17T13:27:11Z.csv' Is it smthg wrong with my OS ?

jezrael Over a year ago

@Amamra - I think yes, need remove : like df.to_csv(f"Output_{pd.to_datetime('now').strftime('%Y-%m-%dT%H%M%SZ')}.csv")

Collectives™ on Stack Overflow

Custom csv file name using to_csv Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related