Python save panda to csv files separately within FOR loop

Question

I would like to save down some panda dataframe downloads separately as csv files. I am getting an error in the last line.

Is the syntax off?

Kind regards

sortedByISIN = pd.DataFrame()

for i in data['isin'].unique():
 print('Adding ' + i)
 d1 = data[data['isin'] == i]

 d1['next_signal'] = d1['signal'].shift(-1)

 #Shift x periods in the future 
 d1['futprice'] = d1['mid'].shift(-6)
 d1['futT'] = d1['creationTimeStamp'].shift(-6)


 d1['move'] = d1.apply(lambda row: (row['futprice'] - row['mid'])/row['mid'] * 10000 if row['futT'] - row['creationTimeStamp'] < 300000 else 0, axis=1)
 d1['signal_transition'] = d1['next_signal'] - d1['signal']

 sortedByISIN = sortedByISIN.append(d1)

 sortedByISIN['period'] = np.floor(sortedByISIN.creationTimeStamp/3600000)
 sortedByISIN.to_csv('Book'%i.csv')

Giuseppe Bonavita · Accepted Answer · 2018-07-11 13:06:16Z

2

or you can use also:

sortedByISIN.to_csv('Book' + str(i) + '.csv')

answered Jul 11, 2018 at 13:06

Giuseppe Bonavita

3493 silver badges10 bronze badges

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

Comments

jezrael · Accepted Answer · 2018-07-11 12:04:05Z

0

Use format:

sortedByISIN.to_csv('Book{}.csv'.format(i))

And for python 3.6+ is possible use f-strings:

sortedByISIN.to_csv(f'Book{i}.csv')

edited Jul 11, 2018 at 12:04

answered Jul 11, 2018 at 11:56

jezrael

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

Collectives™ on Stack Overflow

Python save panda to csv files separately within FOR loop

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