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-12T03:54:28.243

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 '19 at 03:54

answered Aug 12 '19 at 03:37

Ayyan Khan

507
2
12

Tried your code, got values row by row, however, after every row i'm getting empty row. 20191 20192 20193 20194 20195 – Spark Aug 12 '19 at 03:43
just add `newline=''` to `open`. I am editing the code – Ayyan Khan Aug 12 '19 at 03:53

Write into CSV, row by row using Python

1 Answers1