Pandas Dataframe to .csv file

Question

Code:

def print_data(data, dataframe):
      print('%3d | %s | %s, %s, %s, %s, %s'
            % (len(dataframe), data['Symbol'],
               pd.to_datetime(int(data['Updated']), unit='ms'),
               data['Rates'][0], data['Rates'][1], data['Rates'][2],
               data['Rates'][3]))

Output of Code:

8 | EUR/USD | 2019-05-22 14:03:21.475000, 1.1162, 1.11632, 1.11809, 1.11481

i want to save this output in an csv file

if i try with: df.to_csv(test, sep='\t', encoding='utf-8') i get: NameError: name 'df' is not defined — pythonway60
– pythonway60, Commented May 22, 2019 at 14:22
What is the variable of your dataframe? Is it data? Try data.to_csv(... — Scott Boston
– Scott Boston, Commented May 22, 2019 at 14:24

Borja_042 · Accepted Answer · 2019-05-22 14:44:07Z

2

data.to_csv("data.csv", sep = ",")

answered May 22, 2019 at 14:44

Borja_042

1,0711 gold badge16 silver badges27 bronze badges

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

2 Comments

pythonway60 Over a year ago

would work but its just working for 1 line - but the stream is updating every ms

pythonway60 Over a year ago

AttributeError: 'NoneType' object has no attribute 'to_csv'

Collectives™ on Stack Overflow

Pandas Dataframe to .csv file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related