使用json_normalize从opentsdb导入时间序列

import pandas as pd
import json

# 假设从opentsdb获取的原始数据为response
response = [
    {
        "metric": "temperature",
        "tags": {
            "location": "room1"
        },
        "timestamp": 1634567890,
        "value": 25.5
    },
    {
        "metric": "temperature",
        "tags": {
            "location": "room2"
        },
        "timestamp": 1634567900,
        "value": 26.2
    }
]

json_str = json.dumps(response)

df = pd.json_normalize(json.loads(json_str))

print(df)

       metric tags.location   timestamp  value
0  temperature         room1  1634567890   25.5
1  temperature         room2  1634567900   26.2