我正在努力通过json_normalize获得所需的信息。我查看了文档以及可能深度嵌套的JSON文件的10个示例,但我不太了解该函数的上下文以提取正确的信息。我正在尝试建立一个数据框,其中将包含每个传感器的带有时间戳的值(值键)。 1534023900是UTC秒的时间戳。
下面是JSON的简短示例。
有什么想法吗?
{
"created": "2020-05-12T15:10:37Z","device": {
"device_info": {
"device_fw": 204,"device_sn": "06-02133","device_trait": 2,"device_type": 190
},"timeseries": [
{
"configuration": {
"sensors": [
{
"measurements": [
"BATTERY","BATTERY_MV"
],"port": 7,"sensor_bonus_value": "Unavailable","sensor_firmware_ver": "Unavailable","sensor_number": 133,"sensor_sn": "Unavailable"
},{
"measurements": [
"REFERENCE_KPA","TEMPC_LOGGER"
],"port": 8,"sensor_number": 134,"sensor_sn": "Unavailable"
}
],"valid_since": "2018-08-11T21:45:00Z","values": [
[
1534023900,19,[
{
"description": "Battery Percent","error": false,"units": "%","value": 100
},{
"description": "Battery Voltage","units": " mV","value": 7864
}
],[
{
"description": "Reference Pressure","units": " kPa","value": 100.62
},{
"description": "Logger Temperature","units": " \u00b0C","value": 28.34
}
]
]
}
}
}
}
}
}