Mar-21-2021, 02:34 PM
Hey guys I am trying to export a pretty big data frame. I am using this code
When I open the CSV file, it says "not loaded completely" and only 1 million rows are loaded.
If I use this code
Anyone know how to solve this problem?
df = pd.DataFrame(historicalData) df.to_csv(r'dataframe.csv')Now my dataframe has 5 million rows in it.
When I open the CSV file, it says "not loaded completely" and only 1 million rows are loaded.
If I use this code
df = pd.DataFrame(historicalData) df.to_excel(r'dataframe.xlsx', header=True)I get the ValueError : This sheet is too large! Your sheet size is: 5218863, 8 Max sheet size is: 1048576, 16384
Anyone know how to solve this problem?