如何使用 Python 中 JSON 输出的数据创建表
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/36862308/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to Create a table with data from JSON output in Python
提问by user6255719
I am very new to Python, so i trying to create a Data frame from my JSON OUTPUT
我对 Python 很陌生，所以我尝试从我的 JSON OUTPUT 创建一个数据框
My json output looks like as shown below
我的 json 输出如下所示
{
"tags":[
{
"stats":{
"rawCount":9
},
"name":"Temperature1",
"results":[
{
"attributes":{
"Location":[
"3rd Floor"
],
"Sensor-Serial-Number":[
"PT100"
]
},
"values":[
[
1460958592800,
24.2,
3
],
[
1460958602800,
24.1,
1
],
[
1460958612800,
23.9,
1
],
[
1460958622800,
24.2,
1
],
[
1460958632800,
24.5,
1
],
[
1460958642800,
24.9,
1
],
[
1460958652800,
24.6,
1
],
[
1460958662800,
24.7,
1
],
[
1460958672800,
24.7,
1
]
],
"groups":[
{
"type":"number",
"name":"type"
}
]
}
]
}
]
}
I only require values, i need to convert into a data frame as shown in the below PIC(click on Timeseries data link)
我只需要值，我需要转换成如下图所示的数据框（点击时间序列数据链接）
回答by sameera sy
try this to pull out only a list of valuesfrom your json
试试这个只values从你的 json 中提取一个列表
import json
import ast
import pandas as pd
mystr = """
{'tags': [{'name': 'Temperature1',
'results': [{'attributes': {'Location': ['3rd Floor'],
'Sensor-Serial-Number': ['PT100']},
'groups': [{'name': 'type', 'type': 'number'}],
'values': [[1460958592800, 24.2, 3],
[1460958602800, 24.1, 1],
[1460958612800, 23.9, 1],
[1460958622800, 24.2, 1],
[1460958632800, 24.5, 1],
[1460958642800, 24.9, 1],
[1460958652800, 24.6, 1],
[1460958662800, 24.7, 1],
[1460958672800, 24.7, 1]]}],
'stats': {'rawCount': 9}}]}
"""
val = ast.literal_eval(mystr)
val1 = json.loads(json.dumps(val))
val2 = val1['tags'][0]['results'][0]['values']
print pd.DataFrame(val2, columns=["time", "temperature", "quality"])
the result turns out to be
结果是
time temperature quality
0 1460958592800 24.2 3
1 1460958602800 24.1 1
2 1460958612800 23.9 1
3 1460958622800 24.2 1
4 1460958632800 24.5 1
5 1460958642800 24.9 1
6 1460958652800 24.6 1
7 1460958662800 24.7 1
8 1460958672800 24.7 1
which is your table for dataset
这是你的数据集表
