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

Answer 1

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