Nested json data into a data table using python

Question

i have a json file like below..

{
"assetPropertyValues" : {
    "A001234": {
        "PV": 1.2345
    },
    "A001235": {
        "PV": 1.234678
    },
    "A001236": {
        "PV": 1.234678
    }
 }
}

I want to display this data as below..

                 PV
A001234          1.2345
A001235          1.2345678
A001236          1.2345678

i don't have any idea how to do this..please help me out.. Thank you..

SO requires you to first work on the problem yourself and not just post the exercises directly. See stackoverflow.com/help/how-to-ask. — kkgarg
– kkgarg, Commented Aug 14, 2021 at 19:17
Yes sir..I have tried that problem using json_normalize() and I went through some videos and documents..I didn't get the answer like this..I should have post that output too..as this is my first question posting in stack over flow , I don't know how to post..I will make it better from the next time.. thank you so much sir. — anonymous098
– anonymous098, Commented Aug 15, 2021 at 7:28

Henry Ecker · Accepted Answer · 2021-08-14 17:38:29Z

2

We can use DataFrame.from_dict and orient='index':

v = {
    "assetPropertyValues": {
        "A001234": {
            "PV": 1.2345
        },
        "A001235": {
            "PV": 1.234678
        },
        "A001236": {
            "PV": 1.234678
        }
    }
}

df = pd.DataFrame.from_dict(v['assetPropertyValues'], orient='index')

Or when reading from a file with json.load:

import json

import pandas as pd

with open('source.json') as f:
    df = pd.DataFrame.from_dict(
        json.load(f)['assetPropertyValues'],
        orient='index'
    )

df:

               PV
A001234  1.234500
A001235  1.234678
A001236  1.234678

answered Aug 14, 2021 at 17:38

Henry Ecker♦

35.8k19 gold badges48 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Nested json data into a data table using python

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