STATA 利用PYTHON导入特大EXCEL文件速度快点

python
import os
os.chdir(r"D:\statashu1\0628\盈利能力144601848")
import pandas as pd
df=pd.read_excel("FI_T5.xlsx")
print(df.head())
df[df.columns.tolist()] = df[df.columns.tolist()].astype(str)
df.to_stata(r"D:\statashu1\0628\xx.dta",write_index=True,version=119)
end

 

posted @ 2023-06-28 10:05  myrj  阅读(23)  评论(0编辑  收藏  举报