write a row to csv file using pandas

Question

I want to write days to csv file using pandas. I used below method

#create new df
df = pd.DataFrame({'col':day})
df.to_csv('test.csv', mode='a', index = False, header=False)

This writes to the csv with dates in new rows. Something like below...

I want all the dates to be in one row and it should start by leaving the first column because I want my csv to look something like below...

       01/08/18  02/08/18  03/08/18 ...
Heena
Megha
Mark

I am new to pandas so I am not getting the idea to deal with it.

You want to transpose the dataframe? There isn't much for us to go on here, where has Heena, megha etc. appeared from? — roganjosh
– roganjosh, Commented Aug 17, 2018 at 10:45
In any file system, you cannot directly "prepend" to a file. If you one to add line to the beginning of the file, by Pandas or not, you need to read in the whole file, write the first line, then write the whole file back down. — THN
– THN, Commented Aug 17, 2018 at 10:49
@raganjosh, I was not aware of transpose. Just looked into it and I guess I can try transpose. — Heenashree Khandelwal
– Heenashree Khandelwal, Commented Aug 17, 2018 at 10:50
@THN, I admit. I have to write back to the file after reading it. — Heenashree Khandelwal
– Heenashree Khandelwal, Commented Aug 17, 2018 at 10:51
Yes, that and transpose will solve it for you. If the processing is complicated, you may want to do all in pandas, then write the final df down. — THN
– THN, Commented Aug 17, 2018 at 10:54

Sunitha · Accepted Answer · 2018-08-17 14:06:11Z

3

Try to transpose the dataframe before writing.

>>> df=pd.DataFrame()
>>> df['co1']=pd.date_range(start='08/01/18',periods=4)
>>> df.T
         0          1          2          3
co1 2018-08-01 2018-08-02 2018-08-03 2018-08-04

>>> df.T.to_csv('test.csv',mode='a',index=False,header=False)

edited Aug 17, 2018 at 14:06

answered Aug 17, 2018 at 11:07

Sunitha

12.1k2 gold badges23 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

write a row to csv file using pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related