Parsing multi-level json file into Python dict

Question

I'm trying to parse a json file into a python dict (to make it copy-ready for Redshift).

My intended output format is:

{col1:val1, col2:val2,..}
{col1:val1, col2:val2,..}

The current format of the file is:

{"val0": {"col1":"val1", "col2":"val2",..},
 "val0": {"col1":"val1", "col2":"val2",..},..}

Where "val0" is a date field (only value, no column name) that I don't need in my output.

How do I convert the latter format to the former? I've tried going through documentation for the json module (as well as a few other StackOverflow answers), but nothing seems to click. Any help is appreciated. Thanks!

The json module is definitely the way to go here. Why isn't it working? — user2201041
– user2201041, Commented Jul 22, 2016 at 21:56
Do you care about the order of lines in your intended output forma? — UltraInstinct
– UltraInstinct, Commented Jul 22, 2016 at 21:56
The code I'm using is f = open("<PATH>/jsoninput.json","r").read() import json parsed_json = json.loads(f) print parsed_json I just get the same format as before. @SuperSaiyan: The order of lines doesn't particularly matter. Only that the order within each line stays consistent (I'll be loading the output file into redshift tables daily). — MNav
– MNav, Commented Jul 25, 2016 at 15:24
@MNav: Please update your question with it. Also, you need to show us what you have tried relevant to the question being asked. Not just how use parse the JSON. — UltraInstinct
– UltraInstinct, Commented Jul 25, 2016 at 16:35

brennan · Accepted Answer · 2016-08-31 16:45:31Z

1

It sounds like you need a json array.

import json


with open('example.json', 'r') as f:
    data = json.load(f)

array_data = list(data.values())

print(array_data)  # [{'col1': 'val1', 'col2': 'val2'},
                   #  {'col1': 'val1', 'col2': 'val2'}]

with open('array_result.json', 'w') as f:
    json.dump(array_data, f)

edited Aug 31, 2016 at 16:45

answered Aug 31, 2016 at 15:46

brennan

3,50328 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Parsing multi-level json file into Python dict

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related