컴퓨터/Python
python pandas 시트합치기
풍경소리^^
2020. 3. 6. 18:40
import pandas as pd
xlsPath = r"C:\Users\유저이름\Desktop\\"
xlsFile = r"과일.xls"
df = pd.concat(pd.read_excel(xlsPath+xlsFile,sheet_name=None),ignore_index=True)
df.to_excel(xlsPath + '통합과일.xls', index=False, sheet_name='통합')