How to print list value as each row in csv using python?

Question

I would like to generate a csv something like below but my python code generating .cvs file like this -

names
delectus aut autem,quis ut nam facilis et officia qui,fugiat veniam minus,et porro tempora

I would like to print each name in a separate row, please find my python code below

test.py

import requests
import csv
my_list = []
for i in range(1, 10):
    
    url = 'https://jsonplaceholder.typicode.com/todos/'+str(i)
    response = requests.get(url)
    jsonResponse = response.json()
    my_list.append(jsonResponse['title'])


print(my_list)

fields = ['names'] 
    
# data rows of csv file 
rows = [my_list]
  
with open('data.csv', 'w') as f:
    write = csv.writer(f)
    write.writerow(fields)
    write.writerows(rows)

Expected output -data.csv

names
delectus aut autem 
quis ut nam facilis et officia qui 
fugiat veniam minus 
et porro tempora

Jitesh · Accepted Answer · 2021-07-10 03:29:23Z

1

Method 1 (Using CSV)

import requests
import csv

writer=csv.writer(open('data.csv','w'))

fields = ['names'] 
writer.writerow(fields)

my_list = []
for i in range(1, 10):
    url = 'https://jsonplaceholder.typicode.com/todos/'+str(i)
    response = requests.get(url)
    jsonResponse = response.json()
    my_list.append(jsonResponse['title'])
    writer.writerow([jsonResponse['title']])


print(my_list)

Method 2 (Using pandas)

import requests
import pandas as pd

my_list = []
for i in range(1, 10):
    url = 'https://jsonplaceholder.typicode.com/todos/'+str(i)
    response = requests.get(url)
    jsonResponse = response.json()
    my_list.append(jsonResponse['title'])

print(my_list)

df = pd.DataFrame({'names': my_list})
df.to_csv('data.csv', index=False)

Output in csv file

names
delectus aut autem
quis ut nam facilis et officia qui
fugiat veniam minus
et porro tempora
laboriosam mollitia et enim quasi adipisci quia provident illum
qui ullam ratione quibusdam voluptatem quia omnis
illo expedita consequatur quia in
quo adipisci enim quam ut ab
molestiae perspiciatis ipsa

--- Edit ---

Added method 2, which uses pandas library.

edited Jul 10, 2021 at 3:29

answered Jul 10, 2021 at 3:04

Jitesh

3181 silver badge10 bronze badges

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

2 Comments

Dave Brady Over a year ago

Thanks, this looks good. In this approach, we are writing into csv file inside for loop, is there any alternative approach where we can write all 10 records into csv file in one shot because I've to write more than 200 data into csv file and I don't want to do file operation inside for loop. Appreciated your help in advance on this!

Jitesh Over a year ago

@DaveBrady Method 2 should solve your problem.

Tim Roberts · Accepted Answer · 2021-07-10 03:04:08Z

0

That's not a CSV file. That's just a plain text file.

with open('data.txt','w') as f:
    print(fields, file=f)
    print('\n'.join(rows), file=f)

answered Jul 10, 2021 at 3:04

Tim Roberts

55.3k4 gold badges28 silver badges41 bronze badges

Collectives™ on Stack Overflow

How to print list value as each row in csv using python?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related