Need help with coding in script

[snippsat]

It can be useful to make json data to a Pandas the DataFrame,then is easier to work with datat eg query and get a result.
Example.

import pandas as pd
import json

with open('state.json') as file:
    json_data = json.load(file)

df = pd.json_normalize(json_data['states'][0], record_path='state')

Usage.

>>> df
    id tempValue  dhw
0  [0]    [2000]  [1]
1  [1]    [1900]  [1]
2  [2]    [1700]  [1]
3  [3]    [1800]  [1]
4  [4]    [1000]  [1]

>>> # Clean up
>>> df = df.applymap(lambda x: x[0]).astype(int)
>>> df
   id  tempValue  dhw
0   0       2000    1
1   1       1900    1
2   2       1700    1
3   3       1800    1
4   4       1000    1

>>> # To eg get id-1 tempValue 
>>> df.query('id == 1')['tempValue']
1    1900

>>> val = df.query('id == 1')['tempValue']
>>> val.values[0]
1900