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?

Answer 1

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