Write into CSV, row by row using Python

Question

I have a requirement, where i need to generate a number with year and month(concatenated), and write the same numbers into csv, which should be in row by row, tried below code,

import csv

l = []
for x in range(2019,2031):
    for i in range(1,13):
        m = str(x)+str(i)
        l.append(m)
        #l.append('\n')
    writer = csv.writer(open("path\\test.csv","w"))
    writer.writerows([l])

But i'm getting values in single row, not row by row(in single column)

Ayyan Khan · Accepted Answer · 2019-08-12 03:54:28Z

3

You need to use writerow().

import csv

l = []
for x in range(2019,2031):
    for i in range(1,13):
        m = str(x)+str(i)
        l.append(m)
writer = csv.writer(open("path\\test.csv","w",newline=''))
for each in l:
    writer.writerow([each])

edited Aug 12, 2019 at 3:54

answered Aug 12, 2019 at 3:37

Ayyan Khan

5072 silver badges12 bronze badges

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

2 Comments

Spark Over a year ago

Tried your code, got values row by row, however, after every row i'm getting empty row. 20191 20192 20193 20194 20195

Ayyan Khan Over a year ago

just add newline='' to open. I am editing the code

Collectives™ on Stack Overflow

Write into CSV, row by row using Python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related