python code for print data in csv

Question

import csv

reader = csv.reader(post.text, quotechar="'")

with open('source91.csv', 'wb') as f:

  writer = csv.writer(f)
  writer.writerows(list(reader))

output is showing vertically i need to print the data horizantally in CSV

getiing output in csv but printing vertically....

Siva Sai
– Siva Sai

2016-11-22 06:36:47 +00:00
Commented Nov 22, 2016 at 6:36 — Siva Sai
– Siva Sai, Commented Nov 22, 2016 at 6:36

sriramkumar · Accepted Answer · 2016-11-22 09:14:58Z

1

Simple Answer : if you have only one array

with open('source91.csv', 'wb') as f:
    writer = csv.writer(f, delimiter='\n')
    writer.writerows(list(reader))

Complicated answer:

you may need numpy to make is happen. transpose will simply converts row to column

import numpy as np
a = np.array(list(reader))
a = np.append(a, list(reader)) # if you have multiple lines 
a = np.transpose(a)
np.savetxt('source91.csv', a)

edited Nov 22, 2016 at 9:14

answered Nov 22, 2016 at 7:13

sriramkumar

1642 silver badges16 bronze badges

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

3 Comments

Siva Sai Over a year ago

after executing above code the file is saved in NPY file...but i want to save it as CSV

Siva Sai Over a year ago

i am having lots of data in post.text variable

Siva Sai Over a year ago

savetxt(fname, X, fmt, delimiter, newline, header, footer, comments) savetxt support only these getting error TypeError: Mismatch between array dtype ('object') and format specifier ('%.18e')

Collectives™ on Stack Overflow

python code for print data in csv

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related