17、json_record
<pre><code>
import os
import json
import logging
import numpy as np
from collections import Counter
import hashlib
item_list = []
# raw
with open('record.json',encoding="utf-8") as fin:
for lidx, line in enumerate(fin):
sample = json.loads(line.strip())
data_list = sample["Data"]
for item in data_list:
item["问题描述"] = item["VehSysInfos"][0]["IssueStatus"]
item_list.append(item)
# print(item["Id"])
print(sample["PageIndex"])
from pandas.core.frame import DataFrame
data = DataFrame(item_list)
data = DataFrame(item_list)
data.to_excel('./record-2.xlsx')
</code></pre>