Python Export Dataframes To Excel

I will review on how to export many dataframes to one excel file.

Will be using the Pandas package in this video.

You can support channel at the following:

Book a 1 on 1 meeting with me at:

[immanuelsuleiman]

I prefer to use a context manager

with pd.ExcelWriter('path_to_file.xlsx', mode='w') as writer:
for tab_num, df in enumerate(df_list):
df.to_excel(writer,

[tigreonice]

I want to do something like this. the data was taken with webscrapping, so i have 3 lists. I have a column of 1 type of fruit, another column of price and another of price per kg. I would like it to only write or save to a new array, list or dictionary if the fruit (with its price1 and price per kg) includes a specific word, for example fruit in 'box' or 'bulk'. do you know how i can do it?
But if its fruit shampoo dont be write or save in excel column (it has not the word box or bulk).... or at least be written and the deleted that row

[vyron]

Hi Lu,
Is it possible to export dataframe to existing and open xlsm ( macro enabled workbook ) ?
Thanks