Exporting a huge dataFrame

[stylingpat]

Hey guys I am trying to export a pretty big data frame. I am using this code

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?