I need to Export or save pandas multiple Dataframe in one excel tab. Let's suppose my df's are below and need to export it the same way in the excel all together in one tab.

 df1:
Id  Name    Rank
1   Scott   4
2   Jennie  8
3   Murphy  1

df2:
Id  Name    Rank
1   John     14
2   Brown    18
3   Claire   11

df3:
Id  Name    Rank
1   Shenzen   84
2   Dass      58
3   Ghouse    31

df4:
Id  Name    Rank
1   Zen     104
2   Ben     458
3   Susuie  198

CodePudding user response：

You can loop through a list of your dfs and use