使用此代碼:
import pandas as pd
import requests
import json
url = 'https://www.loves.com/api/sitecore/StoreSearch/SearchStores'
#get the data from url
response = requests.get(url).json()
df = pd.read_json(url)
df1 = pd.json_normalize(response)
兩個 DF 都回傳這個:

這就是回應的樣子

如何獲得正常的熊貓資料框?
uj5u.com熱心網友回復:
像這樣試試
import pandas as pd
import requests
import json
url = 'https://www.loves.com/api/sitecore/StoreSearch/SearchStores'
#get the data from url
response = requests.get(url).json()
df1 = pd.json_normalize(response, record_path=['Points'])
uj5u.com熱心網友回復:
我找到了答案,這就是訣竅
df1 = pd.json_normalize(response, record_path=['Points'])
轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/528608.html
