我有这个json数据集。从这个数据集中,我只需要“column\u names”键及其值和“data”键及其值。column\u names的每个值都对应于data的值。如何在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数据框架进行分析
参考:以上代码来自quandal网站
下面的代码片段应该适合您
查看以下链接了解更多信息 https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html
下面的代码是否应该满足您的要求
很简单
相关问题 更多 >
编程相关推荐