Parsing a json object-array in python

Question

I have a json file in following format:

{
"alpha":"12233321",
"beta":
      { 
       "beta1":12.2232,
       "beta2":23.4445
       },
"gamma":
      {
        "gamma1":23.12312,
        "gamma2":12.33445
       }
}

I want to store alpha in a variable, beta and gamma in a numpy arrays.

I am actually clueless on how to start. Because i am confused as this json object contains a single variable and then sets of variables — Kathan Vyas
– Kathan Vyas, Commented Apr 19, 2020 at 5:38

Shubham Sharma · Accepted Answer · 2020-04-19 05:41:28Z

2

Use:

import json
import numpy as np

with open("data.json", "r") as f: # data.json is your json file
    info = json.load(f)
    alpha = info["alpha"]
    beta = np.array(list(info["beta"].values())) # instantiate np array
    gamma = np.array(list(info["gamma"].values())) # instantiate np array

    print("Alpha:", alpha)
    print("Beta:", beta)
    print("Gamma:", gamma)

This prints:

Alpha: 12233321
Beta: [12.2232 23.4445]
Gamma: [23.12312 12.33445]

answered Apr 19, 2020 at 5:41

Shubham Sharma

71.8k6 gold badges26 silver badges58 bronze badges

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

Comments

jcaliz · Accepted Answer · 2020-04-19 05:34:16Z

0

Use pandas to read the json

import pandas as pd
import numpy as np

df = pd.read_json('<json_file>')

beta_array = np.array(df[~df.beta.isnull()].beta)
gamma_array = np.array(df[~df.gamma.isnull()].gamma)

answered Apr 19, 2020 at 5:34

jcaliz

4,0732 gold badges11 silver badges16 bronze badges

3 Comments

Robinson Over a year ago

There is actually a module that could be used instead of pandas, json. Using json.loads(string) the output would be a dict.

Kathan Vyas Over a year ago

@jcaliz ValueError: Unexpected character found when decoding 'true'

Kathan Vyas Over a year ago

@TomRobinson could you provide me an example on how will you work on this? also it is difficult to convert dicts to numpy ndarrays

Collectives™ on Stack Overflow

Parsing a json object-array in python

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related