Dynamically read csv files python pandas

Question

I would like to iteratively read data from a set of csv files in a for loop. The csv files are named (1.csv, 2.csv and so on)

The normal way to read the data will be

data = pd.read_csv('1.csv')

Please can someone suggest how to replace 1 by i when using a for loop.

I tried data = pd.read_csv(i+'.csv') and data = pd.read_csv(i'.csv') but they did not work.

Viktor Kerkez · Accepted Answer · 2013-08-22 14:03:46Z

7

Use either percent formatting

 pd.read_csv('%d.csv' % i)

or format

 pd.read_csv('{0}.csv'.format(i))

answered Aug 22, 2013 at 14:03

Viktor Kerkez

46.8k13 gold badges109 silver badges88 bronze badges

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

2 Comments

dorvak Over a year ago

Or use string-concatenation: pd.read_csv(str(i)+'.csv') There is nothing bad about it, it's even faster than the format-expression.

Phillip Cloud Over a year ago

This is actually one of the areas of Python where the Perl mantra "there's more than one way to do it" applies. There's also '%i', you can pass a type specifier to format...so many ways!

DCA- · Accepted Answer · 2013-08-22 14:20:46Z

2

make a separate string?

if i is indeed an integer, using:

filename = str(i) + '.csv'
data=pd.read_csv(filename)

or even:

data=pd.read_csv(str(i)+'.csv')

should be fine :)

edited Aug 22, 2013 at 14:20

answered Aug 22, 2013 at 14:05

DCA-

1,2822 gold badges18 silver badges33 bronze badges

3 Comments

Dan Allan Over a year ago

I didn't downvote you, but FWIW that won't work for an integer i. You'd have to do str(i) + '.csv'.

dorvak Over a year ago

There is no information wether i is an int or a str. I don't understand the downvote, too.

Andy Hayden Over a year ago

Not downvoter, but I think it is clear in question that i is an integer, so probably that was it. I prefer the other answer though.

Collectives™ on Stack Overflow

Dynamically read csv files python pandas

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related