Pandas writing in csv file as columns not rows-Python

Question

This is my code:

import os

file=[]

directory ='/Users/xxxx/Documents/sample/'
for i in os.listdir(directory):
   file.append(i)


Com = list(file)
df=pd.DataFrame(data=Com)
df.to_csv('com.csv', index=False, header=True)

print('done')

at the moment I am getting all the values for i in one column as a row header. Does anyone know how to make each i value in one row as a column header?

IIUC you can transpose the df: df=pd.DataFrame(data=Com).T prior to writing out to csv — EdChum
– EdChum, Commented Dec 7, 2016 at 15:17

EdChum · Accepted Answer · 2016-12-07 15:18:58Z

6

You need to transpose the df first using .T prior to writing out to csv:

In [44]:
l = list('abc')
df = pd.DataFrame(l)
df

Out[44]:
   0
0  a
1  b
2  c

compare with:

In [45]:
df = pd.DataFrame(l).T
df

Out[45]:
   0  1  2
0  a  b  c

answered Dec 7, 2016 at 15:18

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

2 Comments

Steven Rumbalski Over a year ago

Is there a good reason to prefer df.T over df.transpose()? I imagine they are exactly the same under the hood. To me .transpose() seems more self-documenting, but perhaps that's not idiomatic pandas.

EdChum Over a year ago

@StevenRumbalski it's a numpy convention, if you're coming from numpy then it should be familiar to the reader, plus if you hate typing

Collectives™ on Stack Overflow

Pandas writing in csv file as columns not rows-Python

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