Using pandas to merge multiple excel method example

Specific methods:

1 Load excel using the panda read_excel method
2 Use concat to concatenate a list of DataFrames
3 Then use the object and to_excel to save the merged DataFrame to excel

The method is very simple and easy to use, here is the code and excel image

reference document.to_excel

import pandas as pd
file1='C:/Users/Administrator/Desktop/00/'
file2='C:/Users/Administrator/Desktop/00/'
file3='C:/Users/Administrator/Desktop/00/'
file=[file1,file2,file3]
li=[]
for i in file:
  (pd.read_excel(i))
writer = ('C:/Users/Administrator/Desktop/00/')
(li).to_excel(writer,'Sheet1',index=False)
 
()

Below:

This is the whole content of this article.