| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- import json
- import pandas as pd
- feature = ["1_vovh0分子",
- "2_vovh0分子",
- "2_vovh1分子",
- "3_vovh0分子",
- "3_vovh1分子",
- "3_vovh2分子",
- "4_vovh0分子",
- "4_vovh1分子",
- "4_vovh3分子",
- "7_vovh0分子",
- "7_vovh1分子",
- "7_vovh6分子",
- "13_vovh0分子",
- "13_vovh1分子",
- "13_vovh12分子",
- "25_vovh0分子",
- "25_vovh1分子",
- "25_vovh24分子",
- "1_vovd0分子",
- "2_vovd0分子",
- "2_vovd1分子",
- "3_vovd0分子",
- "3_vovd1分子",
- "3_vovd2分子",
- "1_vovh分母",
- "2_vovh分母",
- "3_vovh分母",
- "4_vovh分母",
- "7_vovh分母",
- "13_vovh分母",
- "25_vovh分母",
- "1_vovd分母",
- "2_vovd分母",
- "3_vovd分母", ]
- with open("/Users/zhao/Desktop/1.json", "r") as file:
- result = json.loads(file.read())
- data = []
- for item in result:
- d = {
- 'score': item['score'],
- "vovScore": item["scoresMap"]['vovScore'],
- '小时': item['allFeatureMap']['weightKey']
- }
- for f in feature:
- d[f] = item['allFeatureMap'][f]
- data.append(d)
- df = pd.DataFrame.from_records(data)
- df.to_csv("/Users/zhao/Desktop/1.csv", index=False)
|
