在python中解析json objectarray

Question

我有一个json文件，格式如下：

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

我想将alpha存储在变量中，beta和gamma存储在numpy数组中

Answer 1

使用：

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)

这张照片是：

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

Answer 2

使用pandas读取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)