如何从这个JSON文件中提取“结果”，并使用NumPy对其进行计算？

Question

我是Python新手，刚刚开始使用Python Boto3

这是我的JSON文件：

   Student = [{"Student_ID": 1,
    "Name":"Erik",
    "ExamSubject": "English",
    "Result": "72.3",
    "ExamDate": "9/12/2020",
    "Gender": "M"},



   {"Student_ID": 2,
    "Name":"Daniel",
    "ExamSubject": "English",
    "Result": "71",
    "ExamDate": "9/12/2020",
    "Gender": "M"},


   {"Student_ID": 3,
    "Name":"Michael",
    "ExamSubject": "English",
    "Result": "62",
    "ExamDate": "9/12/2020",
    "Gender": "M"}

    ]


    print(Student)

我需要从这个JSON文件中提取“结果”，并将其放入一个数组中，然后进行以下计算

最大值、最小值、平均值、标准偏差：

     x = np.array([0]) 
     max_x = x.max() #Maximum value of test data 
     min_x = x.min() #Minimum value of test data 
     mean_x = x.mean() #Mean average of test data 
     std_x = x.std() #Standard deviation of test data

Answer 1

您可以这样做：

results = [float(student["Result"]) for student in students]
x = np.array(results)

我还将Student重命名为students，以便更好地描述它是什么

Answer 2

您可以执行以下操作：

x = np.array([s['Result'] for s in Student]).astype(float)

# other operations
x.min(), x.max()