python - 如何将存储为txt的列表导入pandas？

Question

我有以下问题。我需要将 txt 文件加载为 pandas 数据帧。看看我的 txt 是什么样子的:

[        {
            "type": "VALUE",
            "value": 93.5,
            "from": "2020-12-01T00:00:00.000+01",
            "to": "2020-12-01T00:00:01.000+01"
        },
        {
            "type": "VALUE",
            "value": 75,
            "from": "2020-12-01T00:00:01.000+01",
            "to": "2020-12-01T00:05:01.000+01"
        },
        {
            "type": "WARNING",
            "from": "2020-12-01T00:00:01.000+01",
            "to": "2020-12-01T00:05:01.000+01"
        } ]

换句话说，我需要将txt作为字典列表来读取。然后将其作为 pandas 数据框读取。期望的输出是:

      type       value    from                             to
0     VALUE      93.5     2020-12-01T00:00:00.000+01       2020-12-01T00:00:01.000+01
1     VALUE      75       2020-12-01T00:00:01.000+01       2020-12-01T00:05:01.000+01
2     WARNING    NaN      2020-12-01T00:00:01.000+01       2020-12-01T00:05:01.000+01

请问我该怎么做？我查看了这个问题，但没有帮助:Pandas how to import a txt file as a list , How to read a file line-by-line into a list?

Answer 1

import json
import pandas as pd

with open('inp_file.txt', 'r') as f:
    content = json.load(f)

df = pd.DataFrame(content)