I am trying to export a dataframe with more than 2 million rows into Excel. But since Excel's maximum limit is ~1mil rows. All of the data doesn't go through. Is there any way of doing it? Thanks in advance.
new1.to_csv( "combined.csv", index=False, encoding='utf-8-sig')
enter image description here
