list to csv format using python

Question

a = [{'year': 222, 'title': 'abc'}, {'year': 111, 'title': 'ddd'}]

how can i convert to csv format like

b =     year, title
        222, abc
        111, ddd

I use aws lambda that I can't import pandas

Also, this is basically a dupe of your last question. stackoverflow.com/questions/49423634/json-to-csv-using-python — OneCricketeer
– OneCricketeer, Commented Mar 26, 2018 at 2:06
what is your "a dupe" meaning? I'm a dupe of python using I admit. Just I want to learn more about python and ask too simple question? — Kenny Chan
– Kenny Chan, Commented Mar 26, 2018 at 2:13
"I use aws lambda that I can't import pandas", means I don't want import pandas. Why you still ask me"Why do you need pandas?", So Funny? — Kenny Chan
– Kenny Chan, Commented Mar 26, 2018 at 2:15
Dup-licate. And what I meant was why you you think you need pandas? When there are other ways to write a CSV without external libraries. — OneCricketeer
– OneCricketeer, Commented Mar 26, 2018 at 2:23

Rahul · Accepted Answer · 2018-03-26 02:45:51Z

2

Use csv.dictwriter

import csv
import io


a = [{'year': 222, 'title': 'abc'}, {'year': 111, 'title': 'ddd'}]
f = io.StringIO()
fieldnames = ['year', 'title']
writer = csv.DictWriter(f, fieldnames=fieldnames)
writer.writeheader()
for d in a:
    writer.writerow(d)

print(f.getvalue())

out:
year,title
222,abc
111,ddd

edited Mar 26, 2018 at 2:45

answered Mar 26, 2018 at 2:15

Rahul

11.7k5 gold badges63 silver badges100 bronze badges

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

5 Comments

Kenny Chan Over a year ago

Sorry, I using aws lambda cann't use"with open('names.csv', 'w', newline='') as csvfile:", Can you help me ?

Kenny Chan Over a year ago

obj = s3.get_object(Bucket='excelfile23987', Key='ttttt.json')<br> body = obj['Body']<br> a = body.read().decode('utf-8')<br> # [{'year': 222, 'title': 'abc'}, {'year': 111, 'title': 'ddd'}]

Kenny Chan Over a year ago

my original "a"resource is show above. I have an error in"writer.writerow(d)". "errorMessage": "'str' object has no attribute 'keys'", "errorType": "AttributeError",Please help me

Rahul Over a year ago

Don't ask multiple question. I have answered your question. then you told you cant use file. I changed my answer. Now you want another answer.

Kenny Chan Over a year ago

Sorry..because I consider that cut down some useless code. And the action produce this problem. It's okay. Thank you very much answered me two time already.

Collectives™ on Stack Overflow

list to csv format using python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related