Write dataframes from a list into multiple excel file using Python

Question

I have :

list_of_DataFrames = [df_1, df_2, df_n, ...]

I would like to write each of these dataframes into a distinct excel file.

I tried :

list_of_DataFrames.to_excel("pathTo/ExcelFile.xlsx")

Yevhen Kuzmovych · Accepted Answer · 2021-02-11 11:48:25Z

1

The list doesn't have a to_excel method. The only way you can do is by looping over the list.

for i in range(len(list_of_DataFrames)):
    list_of_DataFrames[i].to_excel("pathTo/ExcelFile-{}.xlsx".format(i))

Yevhen Kuzmovych

12.3k8 gold badges32 silver badges54 bronze badges

answered Feb 11, 2021 at 11:47

Petar

513 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

404pio · Accepted Answer · 2021-02-11 11:46:13Z

0

for i, df in enumerate([df_1, df_2, df_n, ...]):
    df.to_excel(f"pathTo/ExcelFile_{i}.xlsx")

answered Feb 11, 2021 at 11:46

404pio

1,0241 gold badge14 silver badges39 bronze badges