import pandas as pd
import openpyxl


file = r‘D:\测试\nicai\result.txt‘
i = 0
with open(file, ‘r‘,encoding= ‘utf-8‘) as file_object:
    for line in file_object:
        line = eval(line)
        index = line[‘id‘]
        if i == 0:
            df = pd.DataFrame(line, index= [index])
            i = 1
        else:
            df_x = pd.DataFrame(line, index=[index])
            df = df.append(df_x)


df.to_excel(r‘D:\测试\nicai\result.xlsx‘, index=False)

import pandas as pd
import openpyxl


file = r‘D:\测试\nicai\result.txt‘
with open(file, ‘r‘,encoding= ‘utf-8‘) as file_object:
    for i, line in enumerate(file_object):
        line = eval(line)
        if i == 0:
            df = pd.DataFrame(line, index= [i])
        else:
            df_x = pd.DataFrame(line, index=[i])
            df = df.append(df_x)

df.to_excel(r‘D:\测试\nicai\result.xlsx‘, index=False)