python代码片段

eXCel,pickle

# -*- coding: utf-8 -*-
import pandas as pd
import pickle

xls_file_name='3.data2022.xls'
df = pd.read_excel(io=xls_file_name)
df = df.values.tolist()

# 保存 RA_list
f = open('RA_list.txt','wb')
pickle.dump(RA_list,f)

# 读取RA_list
f = open('RA_list.txt','rb')
RA_list= pickle.load(f)
f.close()

# list转dataframe
df = pd.DataFrame(new_df, columns=['序号','单位名称','许可证号','发证机关','分类'])

# 保存到本地excel，格式为 xlsx
df.to_excel("company_list.xlsx", index=False)