Write Large dataframe to excel using Python

CoderGirl

Edited On 16 DECEMBER 2022

Category: Python

1 Answers
99 Views
0 Likes

What is the efficient way to write large dataframe to excel....

I have 7000 rows and 100+ columns and it is taking quite a time...

Using i5 with 8 GB RAM

1 Replies

Answer Now

7000 rows is not big.

If possible, write it to CSV. If you must use excel, use .to_ezcel(), but be sure to use 'openpyxl' as engone.

If you need to write multiple dataframes to a single excel file, you'll need openpyxl

Published on 16 DECEMBER 2022 at 0:12

0 Likes Reply

Ask Question

Users Leaderboard

Online Tools