Error with writing a list to a csv file using python pandas

Question

i have a list. which has 8 lists inside it and each list have 50 elements

ex - [[list 1 with 50 elements ],[list 2 with 50]........,[list 8 with 50]]

i want to write the list to a CSV file as all 8 lists inside the outer list as 8 columns and 50 items in each.But when i try to write it it brings an error message saying i need 50 columns instead of 8. how to fix this problem?

df = ps.DataFrame( data = newresult , columns=['1','2','3','4','5','6','7','8'])
df.to_csv("k-mean-test.csv", index = False)

What did you use csv module? or DictWriter?

ha9u63a7
– ha9u63a7

2014-11-08 14:53:13 +00:00
Commented Nov 8, 2014 at 14:53 — ha9u63a7
– ha9u63a7, Commented Nov 8, 2014 at 14:53

John Zwinck · Accepted Answer · 2014-11-08 14:54:13Z

1

import pandas as pd
lists = [range(10)] * 3
df = pd.DataFrame(lists)
print df.to_csv(index=False, header=False)

This gives you:

0,1,2,3,4,5,6,7,8,9
0,1,2,3,4,5,6,7,8,9
0,1,2,3,4,5,6,7,8,9

answered Nov 8, 2014 at 14:54

John Zwinck

252k44 gold badges346 silver badges459 bronze badges

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

4 Comments

Nipun Alahakoon Over a year ago

mmmm yeah but i am taking data from a long process john. there is no way i could simplified result as that.

John Zwinck Over a year ago

If your data is as you said it is, this solution should work. Your list of lists is longer and wider than mine, sure, but the rest looks the same.

Nipun Alahakoon Over a year ago

i am sorry. I understood it wrong. Yeah it come out this way. But i want transpose of your result. First column 0-9, 2nd column 0-9 and third column 0-9

John Zwinck Over a year ago

@Optimuskck: OK then do df.T.to_csv(...).

Collectives™ on Stack Overflow

Error with writing a list to a csv file using python pandas

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related