Python Pandas: Creating filename before saving dataframe as csv

Question

I am trying to make file name before saving dataframe as csv. Here is my code:

import glob
filename = 'Top20Apps' + ' ' +pd.to_datetime("now").strftime("%Y/%m/%d")+'.csv'

Then I am trying to check whether the any csv file with same name exists or not by following code:

files_present = glob.glob(filename)
    if files_present:
        df.to_csv(filename,index=False,mode='a',header=False)
    else:
        df.to_csv(filename,index=False)

When I ran the above code, it throws the following error:

FileNotFoundError: [Errno 2] No such file or directory: 'Top20Apps 2021/02/01.csv'

Error is showing on the else section. I am not sure where I made the mistake. Any help to fix the issue would be highly appreciated.

jezrael · Accepted Answer · 2021-02-01 09:36:09Z

1

I think you need change .strftime("%Y/%m/%d") to .strftime("%Y_%m_%d"), because / is not valid value for filename under Windows.

answered Feb 1, 2021 at 9:36

jezrael

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

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

Collectives™ on Stack Overflow

Python Pandas: Creating filename before saving dataframe as csv

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related