擅长:python、mysql、java
<p>请尝试以下方法查看患者记录</p>
<pre><code>patients_df = pd.read_json(patients.json)
patient_id = []
patient_name =[]
# Get attributes from nested nested datatypes in Patient column
for patient in patients_df['Patients']:
patient_id = patient[0]['Patient id']
patient_name = patient[0]['Patient name']
# Add to the pandas dataframe
patients_df['Patient name'] = patient_name
patient_df['Patient id'] = patient_id
# Drop the 'Patient' column
patients_df = patients_df.drop(column='Patient')
</code></pre>