Python-Pandas JSON.normalize on non-Array JSON keys

Question

I have the following JSON from a string and read it via json.load.
I would like to normalize its contents into a pandas data frame. But instead of creating a column for each "node" in the JSON graph, I want it to create a row for each depth=1 node

import pandas as pd

pd.json_normalize({'a': {'i': 1, 'm': 'msg'}, 'b': {'i': 5, 'm': 'msg2'}} )

Output:

   a.i  a.m b.i b.m
0   1   msg 5   msg2

I want this instead:

    i   m
a   1   msg 
b   5   msg2

Do you know how to achieve that?

Thank you very much!

Eric Truett · Accepted Answer · 2020-04-17 18:20:45Z

1

Use the orient='index' parameter

data = {'a': {'i': 1, 'm': 'msg'}, 'b': {'i': 5, 'm': 'msg2'}}
pd.DataFrame.from_dict(data=data, orient='index')

Output

   i     m
a  1   msg
b  5  msg2

answered Apr 17, 2020 at 18:20

Eric Truett

3,0201 gold badge20 silver badges22 bronze badges

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

1 Comment

Nicolai Schmid Over a year ago

You're a saint! Thank You!

Collectives™ on Stack Overflow

Python-Pandas JSON.normalize on non-Array JSON keys

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related