Categories
Mastering Development

import multiple excel files to pandas and export to multiple stata files

my raw excels files are[excel_1,excel_2,…,excel_3], at first I want to import them into dataframes and then append them into a big dataframe, then df.to_dta, but python shows error and said: Memoryerror. I guess the problem is the appended dataframe is too big. so I thought I could transform each excel files to each stata file […]