CSV file from a list with multiple dictionaries in Python?

Question

I have data of following form:

{'count': '274',  'file_type': 'json', 'limit': '100000',    observation_end': '9999-12-31',    'observation_start': '1776-07-04',    'observations': "[{'date': '1947-01-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '3.962'}, {'date': '1947-04-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '4.052'}, {'date': '1947-07-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '4.172'}, {'date': '1947-10-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '4.270'}, {'date': '1948-01-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '4.372'}, {'date': '1948-04-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '4.432'}, {'date': '1948-07-01', 'realtime_start': '2015-08-20', 'realtime_end': '2015-08-20', 'value': '4.521'}]

I want to create CSV or Excel file from it so that different values appear on different rows. E.g data 1948-07-01 value 4521. Is it possible and how? I tried following:

writer = csv.writer(open('dict.csv', 'wb'))
for key, value in mydict.items():
    writer.writerow([key, value])

But getting last row containing all the dictionaries of list in single row.

please make sure your dictionary syntax is correct .

Thothadri Rajesh
– Thothadri Rajesh

2015-08-20 13:32:58 +00:00
Commented Aug 20, 2015 at 13:32 — Thothadri Rajesh
– Thothadri Rajesh, Commented Aug 20, 2015 at 13:32

Thothadri Rajesh · Accepted Answer · 2015-08-20 13:27:55Z

1

import ast # since your observations seems to be a string 
a=your_dictionary
observations=ast.literal_eval(a["observations"]) # this will convert this string to list
headers=observations[0].keys() 
writer = csv.writer(open('dict.csv', 'wb'))
writer.writerow(headers) # to make sure your headings are date,realtime_start etc
for data in observations:
    row=[data[header] for header in headers] #will create the row in same order as headers
    writer.writerow(row)

answered Aug 20, 2015 at 13:27

Thothadri Rajesh

5227 silver badges16 bronze badges

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

2 Comments

Rajesh_Sharma Over a year ago

Thanks a ton@Rajesh. Great help indeed.

Thothadri Rajesh Over a year ago

@Rajesh_Sharma - please mark it as answered, if you feel i have answered your question correctly

amirouche · Accepted Answer · 2015-08-20 13:14:07Z

0

You must first write the headers with the keys and then write your values.

Given the fact that all your data has the sames keys, the following will work:

writer = csv.writer(open('dict.csv', 'wb'))
# retrieve the first dict to  write the csv header:
header = data[0].keys()
writer.writerow(header)
# iterate over data:
for data in datas:
    writer.writerow(data.values())

Remember to use collections.OrderedDict to make sure that .keys and .values methods return items in the same order.

answered Aug 20, 2015 at 13:14

amirouche

7,9417 gold badges42 silver badges100 bronze badges

Collectives™ on Stack Overflow

CSV file from a list with multiple dictionaries in 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