Write a list of values as separate columns to a CSV file using Python

Question

I am trying to write the elements of a list (each time I get from a for loop) as individual columns to a CSV file. But the elements are adding as an individual rows, but not columns.

I am new to python. What needs to be changed in my code? Please tell me

import csv
row=['ABC','XYZ','','','ABCD','']  #my list looks like this every time
with open('some.csv', 'w') as writeFile:
    writer = csv.writer(writeFile, delimiter=',', quotechar='"')
    for item in row:
        writer.writerow([item])

But I am getting the output as below:

ABC

XYZ

ABCD

My expected output is a below:

ABC XYZ    ABCD

use writer.writerows[row]

Rakesh
– Rakesh

2019-06-28 06:53:36 +00:00
Commented Jun 28, 2019 at 6:53 — Rakesh
– Rakesh, Commented Jun 28, 2019 at 6:53
Still, its giving me the wrong output as below:

sairanga talari
– sairanga talari

2019-06-28 06:55:06 +00:00
Commented Jun 28, 2019 at 6:55 — sairanga talari
– sairanga talari, Commented Jun 28, 2019 at 6:55
No need of iteration here. Use without for

Arun Palanisamy
– Arun Palanisamy

2019-06-28 06:58:37 +00:00
Commented Jun 28, 2019 at 6:58 — Arun Palanisamy
– Arun Palanisamy, Commented Jun 28, 2019 at 6:58

Devesh Kumar Singh · Accepted Answer · 2019-06-28 08:43:28Z

2

You are iterating over the list row and writing each element as a new row in your code when you do writer.writerow([item]).

Instead you want to write the entire row in one line using writer.writerow

import csv

row=['ABC','XYZ','','','ABCD','']  #my list looks like this every time

with open('some.csv', 'w') as writeFile:

    writer = csv.writer(writeFile, delimiter=',', quotechar='"')
    #Write the list in one row
    writer.writerow(row)

The file will look like

ABC,XYZ,,,ABCD,

edited Jun 28, 2019 at 8:43

answered Jun 28, 2019 at 6:56

Devesh Kumar Singh

20.5k5 gold badges25 silver badges43 bronze badges

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

Comments

kuldeep rawani · Accepted Answer · 2019-06-28 07:13:51Z

1

Actually you are writing in different rows, you don't need to do that. You can write your whole list as a single row. You need spaces so for that you can modify your list.

answered Jun 28, 2019 at 7:13

kuldeep rawani

545 bronze badges

1 Comment

kuldeep rawani Over a year ago

import csv row=['ABC','XYZ','','','ABCD',''] #my list looks like this every time with open('some.csv', 'w') as writeFile: writer = csv.writer(writeFile, delimiter=',', quotechar='"') writer.writerow(row)

Collectives™ on Stack Overflow

Write a list of values as separate columns to a CSV file using 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