我正在嘗試從這個 JSON 資料中提取一個元素并將其格式化為我的 pandas DataFrame 中的另一列。
這是我到目前為止的代碼：
#Import libraries
import json
import requests
from IPython.display import JSON
import pandas as pd
#Load data
astronaut_db_url = 'https://supercluster-iadb.s3.us-east-2.amazonaws.com/adb.json'
astronauts_db = requests.get(astronaut_db_url).json()
#Format data
df = pd.json_normalize(astronauts_db['astronauts'])
df_astro = df[['_id','astroNumber','awards','name','gender','inSpace','overallNumber','spacewalkCount','species','speciesGroup',
'totalMinutesInSpace','totalSecondsSpacewalking','lastLaunchDate.utc']]
#Get row per award
df_awards = df_astro.explode(['awards']).reset_index(drop=True)
df_awards.head()
df_awards['awards'][0]['title']
我想在我的 DataFrame 中為每位宇航員獲取獎項的標題，并在一個單元格中創建一個新列，其中包含獎項串列，如下所示：
Astronaut_ID Awards
dh3405kdmnd [First Person In Space, First Person to Cross Karman Line]
ert549fkfl3 [Crossed Karman Line, First Person on Moon]
我解決這個問題的想法是：
- 為每位宇航員獲得每個獎項
- 將 JSON 單元格剝離到標題
- 每位宇航員在一個細胞中重組
我不確定如何完成此程序的第 2 步。有人可以幫我指出正確的方向嗎？
uj5u.com熱心網友回復：
我會使用awards作為字典串列并將函式應用于它的每個元素。
import json
import requests
from IPython.display import JSON
import pandas as pd
#Load data
astronaut_db_url = 'https://supercluster-iadb.s3.us-east-2.amazonaws.com/adb.json'
astronauts_db = requests.get(astronaut_db_url).json()
#Format data
df = pd.json_normalize(astronauts_db['astronauts'])
df_astro = df[['_id','astroNumber','awards','name','gender','inSpace','overallNumber','spacewalkCount','species','speciesGroup',
'totalMinutesInSpace','totalSecondsSpacewalking','lastLaunchDate.utc']]
#Get row per award
df_awards = df_astro[['_id', 'awards']].copy()
df_awards['awards'] = df_awards['awards'].apply(lambda awards: [award['title'] for award in awards])
df_awards.columns = ['Astronaut_ID', 'Awards']
print(df_awards.head())
uj5u.com熱心網友回復：
無需執行步驟 1-2，您可以record_path直接meta傳入json_normalize. 然后可以使用groupby 完成第 3 步agg(list)：
df_awards = pd.json_normalize(astronauts_db['astronauts'], 'awards', '_id').groupby('_id', as_index=False)['title'].agg(list)
print(df_awards.head(5))
輸出：
_id title
0 0554c903-e8a6-43c5-8da8-76fb3495e93f [First Steppe Tortoise (Agrionemys horsfieldii)]
1 0729eec8-ae2f-44a5-900f-08b2f491c8fe [Crossed Kármán Line, ISS Visitor]
2 0ff02f81-a865-465d-97b8-cd6be84c56aa [Crossed Kármán Line, ISS Visitor, Space Resid...
3 157edd2d-58a0-4f47-b85d-4c6ade14a973 [Crossed Kármán Line]
4 15c82ce2-10d5-45e7-848e-6df388307e1f [Crossed Kármán Line]
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/429587.html