Importing csv to python with Variable Name

Question

I need to import (read) a csv from a path. Each csv per day is saved as yyyymmdd_filename.csv in C:\

Using pd.read_csv('C:/yyyymmdd_filename.csv') I can import the file of a current date

However, I want to assign a variable date = today() and run the file to import the csv.

So I imagine it would look something like this pd.read_csv('C:/' + date + '*filename.csv')

Is this possible to do using pd.read_csv? if not what should I use

Check out there : stackoverflow.com/questions/311627/…

olinox14
– olinox14

2019-03-21 16:38:30 +00:00
Commented Mar 21, 2019 at 16:38 — olinox14
– olinox14, Commented Mar 21, 2019 at 16:38

HappyCloudNinja · Accepted Answer · 2019-03-22 06:58:41Z

1

Here is a small code :

from datetime import date
today=date.today()
print(today.strftime('%Y%m%d') #'20190321'

And for your case , to get the whole way to file:

print('C:/{}_filename.csv'.format(today.strftime('%Y%m%d')))
print(f'C:/{today.strftime("%Y%m%d")}_filename.csv') #don't use the same quote inside and outside or it won't work, of course.
print('C:/'+today.strftime('%Y%m%d')+'_filename.csv')

edited Mar 22, 2019 at 6:58

answered Mar 21, 2019 at 16:45

HappyCloudNinja

4261 gold badge4 silver badges13 bronze badges

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

2 Comments

tp_1290 Over a year ago

thanks, but how can i also implement the today while importing my csv?

HappyCloudNinja Over a year ago

pd.read_csv('C:/{}_filename.csv'.format(today.strftime('%Y%m%d'))) or pd.read_csv(f'C:/{today.strftime('%Y%m%d')}_filename.csv') or pd.read_csv('C:/'+today.strftime('%Y%m%d')+'_filename.csv')

Collectives™ on Stack Overflow

Importing csv to python with Variable Name

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related