how to dump string(list of dictionaries) as json object in python

Question

I have item data in array of dictionary in python.

items = [{'key': {'Brand': 'Tesla', 'Date': '2020'}, 'Total': 56, 'my_vin': '#468123'},
            {'key': {'Brand': 'Toyota', 'Date': '2022'}, 'Total': 6, 'my_vin': '#468210'},
            {'key': {'Brand': 'Audi', 'Date': '2023'}, 'Total': 1, 'my_vin': '#468132'}]

I want to re-format this data and dump into json format. and I'm able to do that.

import json
with open('new_json.json', 'w') as njs:
    for i in items:
        format_data = {'only_brand': i['key']['Brand'], 'only_date': i['key']['Date']}
        print(format_data)

        json.dump(format_data, njs, indent=4)

But when I tried read json file it gives format error

with open('new_json.json', 'r') as f:
    data = json.loads(f.read())
    print(data)

json.decoder.JSONDecodeError: Extra data: line 4 column 2 (char 54)

I'm not sure this is the right way to do what I want to do and I have to loop through very long items in a real case. How can I get a proper json document ?

Rahul K P · Accepted Answer · 2022-09-29 23:04:51Z

2

You can do like this,

import json
with open('new_json.json', 'w') as njs:
    new_dict = [{"only_brand": i["key"]["Brand"], "only_date": i["key"]["Date"]} for i in items]
    json.dump(new_dict, njs, indent=4)

answered Sep 29, 2022 at 23:04

Rahul K P

16.2k4 gold badges40 silver badges56 bronze badges

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

Comments

Barmar · Accepted Answer · 2022-09-29 23:01:34Z

2

You can't write multiple JSON objects to the file. Put all the dictionaries in a list, and write that once.

import json
with open('new_json.json', 'w') as njs:
    format_data = [{'only_brand': i['key']['Brand'], 'only_date': i['key']['Date']} for i in items]
    print(format_data)

    json.dump(format_data, njs, indent=4)

answered Sep 29, 2022 at 23:01

Barmar

789k57 gold badges554 silver badges669 bronze badges

1 Comment

Alexander Over a year ago

Thanks all for your prompt answers.

Hai Vu · Accepted Answer · 2022-09-29 23:09:00Z

0

You need to dump the whole list at once, not individual items:

import json

output = [
    {'only_brand': i['key']['Brand'], 'only_date': i['key']['Date']}
    for i in items
]

with open('new_json.json', 'w') as njs:
        json.dump(output, njs, indent=4)

edited Sep 29, 2022 at 23:09

answered Sep 29, 2022 at 23:02

Hai Vu

41.4k16 gold badges75 silver badges106 bronze badges

2 Comments

Rahul K P Over a year ago

I accidentally edited your answer, Sorry. Rollbacked.

Hai Vu Over a year ago

It is alright. An accident is an accident.

Collectives™ on Stack Overflow

how to dump string(list of dictionaries) as json object in python

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related