df = pd.concat(pd.read_excel(workbook_url, sheet_name=None), ignore_index=True)
import glob all_data = pd.DataFrame() path = 'd:/projects/chassis/data/*.xlsx' for f in glob.glob(path): df = pd.read_excel(f, sheet_name=None, ignore_index=True, skiprows=6, usecols=8) cdf = pd.concat(df.values()) all_data = all_data.append(cdf,ignore_index=True) print(all_data)
import os import pandas as pd cwd = os.path.abspath('') files = os.listdir(cwd) df = pd.DataFrame() for file in files: if file.endswith('.xlsx'): df = df.append(pd.read_excel(file), ignore_index=True) df.head() df.to_excel('total_sales.xlsx')