我的 API 回應是這樣的
{
'1644205500': {'date': '06-02-2022', 'open': 501.85, 'high': 504.2, 'low': 500.75, 'close': 503.05},
'1644205800': {'date': '06-02-2022', 'open': 502.85, 'high': 503.05, 'low': 497.45, 'close': 498.55},
'1644206100': {'date': '06-02-2022', 'open': 498.85, 'high': 498.85, 'low': 495.3, 'close': 498.75},
'1644206400': {'date': '06-02-2022', 'open': 498.7, 'high': 498.75, 'low': 497.2, 'close': 498.05},
'1644206700': {'date': '06-02-2022', 'open': 497.95, 'high': 498.85, 'low': 496.45, 'close': 496.45},
'1644207000': {'date': '06-02-2022', 'open': 496.45, 'high': 498, 'low': 496.45, 'close': 497.5}
}
當我使用pd.json_normalize(data)時，只有一行和這么多列。像這樣：
1644205500.date 1644205500.open 1644205500.high 1644205500.low 1644205500.close 1644205800.date 1644205800.open 1644205800.high 1644205800.low 1644205800.close 1644206100.date 1644206100.open 1644206100.high 1644206100.low 1644206100.close
我怎樣才能讓它像這樣的桌子？
date open high low close
06-02-2022 500 501 490 501
06-02-2022 501 502 480 470
....
uj5u.com熱心網友回復：
這很容易：
df = pd.DataFrame(data.values())
編輯（見評論）
df = pd.DataFrame(data.values()).assign(timestamp=data.keys())
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/438174.html