Combine multiple excel files into One
Jump to navigation
Jump to search
import glob import os import pandas as pd file = input('File Path: ') pth = os.path.dirname(file) extension = os.path.splitext(file)[1] print(pth) files = glob.glob(os.path.join(pth, '*.xls*')) files df = pd.DataFrame() for f in files: data = pd.read_excel(f) df = df.append(data) set(df['PDF Filename']) df.to_excel("combined_files.xlsx") df.shape