Output format of csv file - Python

Question

From a csv file having the following format:

Date,Data
01-01-01,111
02-02-02,222
03-03-03,333

I am calculating the monthly average of the values using the following code:

data = pd.read_csv("input.csv")
data['Month'] = pd.DatetimeIndex(data.reset_index()['Date']).month
mean_data = data.groupby('Month').mean()

Then I would like to write the outputted monthly values on a new csv file. I am currently using the following lines of code:

 with open ("test.csv", "w") as f:
     print(mean_data, file=f)

Unfortunately, this produces a weird output having the following format:

I would like to obtain a real csv output as follow:

Month,Data
1,2
2,3
3,4
4,5

Does anyone knows how to achieve that?

Bas Witte · Accepted Answer · 2018-05-21 10:17:38Z

2

Instead of using:

 with open ("test.csv", "w") as f:
    print(mean_data, file=f)

You could try and use:

import csv

header = ['Month', 'Data']
with open("test.csv", "w") as f:
    writer = csv.writer(f)
    writer.writerow(header)
    writer.writerows(mean_data)

I've tried to recreate your problem and above should provide a solution.

answered May 21, 2018 at 10:17

Bas Witte

561 silver badge6 bronze badges

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

Comments

eoxxs · Accepted Answer · 2018-05-21 10:07:25Z

1

You could use mean_data.to_csv(...)

Here is the documentation:

Pandas to_csv

answered May 21, 2018 at 10:07

eoxxs

754 bronze badges

Collectives™ on Stack Overflow

Output format of csv file - Python

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