Writing string in CSV and getting multiple rows - Python

Question

This must be very simple.

I'm trying to put a header in my csv file, the string 'Date,Value', as you can see below.

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

writer = csv.writer(f)
writer.writerows('Date,Value')
writer.writerows(izip(dates, values))
f.close()

However I'm getting a multirowed string, like this:

D

a

t

e

","

V

a

l

u

e

2002-03,12.9

2002-04,12.5

2002-05,11.9

How can I fix that?

when using with open('ticker.csv', 'wb') as f: you can avoid f.close() as it will inherently do it. effbot.org/zone/python-with-statement.htm — nish
– nish, Commented Nov 28, 2015 at 14:08

Kaushal Kumar Singh · Accepted Answer · 2015-11-28 13:23:22Z

1

Here is the solution

writer = csv.writer(f)
writer.writerow(['Date','Value'])
writer.writerows(izip(dates, values))
f.close()

answered Nov 28, 2015 at 13:23

Kaushal Kumar Singh

82911 silver badges19 bronze badges

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

Comments

Daniel Roseman · Accepted Answer · 2015-11-28 13:19:09Z

0

Use writerow - without the s - to write a single row.

answered Nov 28, 2015 at 13:19

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

1 Comment

aabujamra Over a year ago

thanks! almost there. now I'm getting D,a,t,e,",",V,a,l,u,e. How do I take out those commas between letters?

Collectives™ on Stack Overflow

Writing string in CSV and getting multiple rows - Python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related