Getting Output of my Python code to a csv file

Question

I am writing a python code to pull a list and give the output in a .CSV file . The code is splitting after each character instead of each name . The [Name] in the below code contains a list of names like : aeims aelog amscompatibilitytool

with open("csvtest.csv", "wb") as f:
    writer = csv.writer(f,delimiter='\t', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    for namespace in namespaces:
        writer.writerows(namespace['name'])

Expected :

aeims
aelog
amscompatibilitytool
cgr

Result I am getting in csv file :

a
e
i
m
s
a
e
l
o
g
a
m

.... so on

can you please format code more better. just select all code and click on format button. — Aish Sharma
– Aish Sharma, Commented Jun 26, 2019 at 9:48
namespace is a class name which is pulling the list from a node — user11702296
– user11702296, Commented Jun 26, 2019 at 9:55
One more doubt , if i add another write statement , and want the output of that in the 2nd column of the csv file , is there a way to do that ? — user11702296
– user11702296, Commented Jun 26, 2019 at 10:48

trotta · Accepted Answer · 2019-06-26 09:54:16Z

1

writerows writes multiple rows to your csv file:

Write all elements in rows (an iterable of row objects as described above) to the writer’s file object, formatted according to the current dialect.

Try to use writerow instead:

Write the row parameter to the writer’s file object, formatted according to the current dialect.

Like This:

with open("csvtest.csv", "wb") as f:
    writer = csv.writer(f,delimiter='\t', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    for namespace in namespaces:
        writer.writerow(namespace['name'])

answered Jun 26, 2019 at 9:54

trotta

1,2221 gold badge16 silver badges23 bronze badges

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

1 Comment

user11702296 Over a year ago

One more doubt , it i add another write statement , and want the output of that in the 2nd column of the csv file , is there a way to do that ?

Collectives™ on Stack Overflow

Getting Output of my Python code to a csv file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related