Create csv file in python

Question

I created one program in python in which I used collaborative filtering to find Item based CF. My code is,

# Create a placeholder items for closes neighbours to an item
data_neighbours = pd.DataFrame(index=data_ibs.columns,columns=[range(1,13)])
print data_neighbours
# Loop through our similarity dataframe and fill in neighbouring item names
for i in range(0,len(data_ibs.columns)):
    ##use sort_values(...)
    data_neighbours.ix[i,:10] = data_ibs.ix[0:,i].sort_values(ascending=[1, 0])[:10].index
    data_neighbours.ix[i,:10] = data_ibs.ix[0:,i].sort_values(ascending=[1, 0])[:10].index



print data_neighbours.ix[i,:10]

Output is in table:


         user         1          2          3
    0   192.   c1s1b1p3   c1s1b1p4   c1s1b1p5
    1   192.   c1s1b1p3   c1s1b1p4   c1s1b1p5
    2   192.   c1s1b1p3   c1s1b1p4   c1s1b1p5
    3   192.   c1s1b1p3   c1s1b1p4   c1s1b1p5
    4   192.   c1s1b1p7   c1s1b1p8  c1s1b1p10
    5   192    c1s1b1p5   c1s1b1p6   c1s1b1p7
    6   192.   c1s1b1p3   c1s1b1p4   c1s1b1p5
    7   192.   c1s1b1p8   c1s1b1p9   c1s1b1p4
    8   192.   c1s1b1p6  c1s1b1p10   c1s1b1p5
    9   192.   c1s1b1p3   c1s1b1p5   c1s1b1p7
    10  192.   c1s1b1p6   c1s1b1p8   c1s1b1p9

This is table display on cmd prompt I want to save this table in csv file. How I can create csv file to store this table.

Look at pandas.DataFrame.to_csv. And always try googling first, this looks like a very common and basic question. — nostradamus
– nostradamus, Commented Aug 26, 2016 at 12:25
I did google, but didn't get it.and I am new in python. hence why I'm facing such problems. — Yogesh Nikam Patil
– Yogesh Nikam Patil, Commented Aug 26, 2016 at 12:31

Lokesh Sanapalli · Accepted Answer · 2016-08-26 12:40:25Z

1

with open('hi.csv','wb') as ff:
    sw=csv.writer(ff,delimiter=',',quoting=csv.QUOTE_MINIMAL) 
       for rows in data_neighbours: 
           sw.writerow(rows)

data_neighbours must contain lists in row wise....

edited Aug 26, 2016 at 12:40

answered Aug 26, 2016 at 12:33

Lokesh Sanapalli

1,0324 gold badges19 silver badges39 bronze badges

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

5 Comments

Ma0 Over a year ago

the ff.close() is not needed. the with block takes care of all that.

Yogesh Nikam Patil Over a year ago

sw.writerow(rows) _csv.Error: sequence expected

Lokesh Sanapalli Over a year ago

yeah, how your data_neighbours contains ? as I mentioned it should be like this [ [row1],[row2],[row3]....]

Yogesh Nikam Patil Over a year ago

I want to print- " data_neighbours.ix[i,:10] " this is output of data_neighbours.ix[i,:10]

Yogesh Nikam Patil Over a year ago

I don't want to print data_neighbours

Xavier C. · Accepted Answer · 2016-08-26 12:25:52Z

0

You should consider to use the csv module. In the documentation there is all the explanations and examples you need to create your csv file.

answered Aug 26, 2016 at 12:25

Xavier C.

1,98117 silver badges23 bronze badges

Collectives™ on Stack Overflow

Create csv file in python

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related