我有這個 json 數據集。從這個數據集中，我只想要“column_names”鍵及其值和“data”鍵及其值。column_names 的每個值對應于數據值。我如何在python中只組合這兩個鍵進行分析{"dataset":{"id":42635350,"dataset_code":"MSFT","column_names":["Date","Open","High","Low","Close","Volume","Dividend","Split", "Adj_Open","Adj_High","Adj_Low","Adj_Close","Adj_Volume"],"frequency":"daily","type":"Time Series","data":[["2017-12-28",85.9,85.93,85.55,85.72,10594344.0,0.0,1.0,83.1976157998082,83.22667201021558,82.85862667838872,83.0232785373639,10594344.0],["2017-12-27",85.65,85.98,85.215,85.71,14678025.0,0.0,1.0,82.95548071308001,83.27509902756123,82.53416566217294,83.01359313389476,14678025.0]for cnames in data['dataset']['column_names']:print(cnames)for cdata in data['dataset']['data']:print(cdata)For 循環給了我想要的列名和數據值，但我不知道如何將它組合起來，并將其作為 python 數據框進行分析。Ref：以上代碼來自qudal網站
3 回答
慕田峪9158850
TA貢獻1794條經驗 獲得超8個贊
data = {
"dataset": {
"id":42635350,"dataset_code":"MSFT",
"column_names": ["Date","Open","High","Low","Close","Volume","Dividend","Split","Adj_Open","Adj_High","Adj_Low","Adj_Close","Adj_Volume"],
"frequency":"daily",
"type":"Time Series",
"data":[
["2017-12-28",85.9,85.93,85.55,85.72,10594344.0,0.0,1.0,83.1976157998082, 83.22667201021558,82.85862667838872,83.0232785373639,10594344.0],
["2017-12-27",85.65,85.98,85.215,85.71,14678025.0,0.0,1.0,82.95548071308001,83.27509902756123,82.53416566217294,83.01359313389476,14678025.0]
]
}
}
下面的代碼應該做你想做的嗎？
import pandas as pd
df = pd.DataFrame(data, columns = data['dataset']['column_names'])
for i, data_row in enumerate(data['dataset']['data']):
df.loc[i] = data_row
慕娘9325324
TA貢獻1783條經驗 獲得超4個贊
以下代碼段應該適合您
import pandas as pd df = pd.DataFrame(data['dataset']['data'],columns=data['dataset']['column_names'])
檢查以下鏈接以了解更多信息 https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html
慕妹3242003
TA貢獻1824條經驗 獲得超6個贊
cols = data['dataset']['column_names']
data = data['dataset']['data']
這很簡單
labeled_data = [dict(zip(cols, d)) for d in data]
添加回答
舉報
0/150
提交
取消