How to generate loop CSV file names with Pandas?

Question

I need to output CSV files in a loop. Using pandas

for i in range(1,int(len(feed_file_order)/2000)+2): 
    print(i)

    final_frame = final_frame.append(feed_file_order[u:(2000*i)])

    u=u+2000
    final_frame.drop(final_frame.index, inplace=True)

    final_frame.to_csv('C:\\Users\\7005243\\Desktop\\trail_i.csv')

I want my output csv files as trail_1, trail_2 etc.

dont understant what is your problem, to build the file name? — Frenchy
– Frenchy, Commented Mar 18, 2019 at 16:43
change 'C:\\Users\\7005243\\Desktop\\trail_i.csv' to f'C:\\Users\\7005243\\Desktop\\trail_{i}.csv', it should work. The problem was that i in your case was the character i and not the variable ii — Tacratis
– Tacratis, Commented Mar 18, 2019 at 16:45
@Tacratis f-strings are great, but they available only from Python 3.6 onwards. — Blackecho
– Blackecho, Commented Mar 18, 2019 at 16:47

Blackecho · Accepted Answer · 2019-03-18 16:46:02Z

3

Just change the last line of the loop to:

final_frame.to_csv('C:\\Users\\7005243\\Desktop\\trail_{}.csv'.format(i))

The format function will take care of putting the current value of i where the {} is.

answered Mar 18, 2019 at 16:46

Blackecho

1,2905 gold badges18 silver badges28 bronze badges

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

Comments

Venkatesh Garnepudi · Accepted Answer · 2019-03-18 16:44:49Z

1

final_frame.to_csv('C:\\Users\\7005243\\Desktop\\trail_'+str(i)+'.csv')

You are adding i inside the string which is wrong. It's a variable which should change, so isolate it.

answered Mar 18, 2019 at 16:44

Venkatesh Garnepudi

3161 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to generate loop CSV file names with Pandas?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related