Read multiple Excel files within a file folder into single pandas dataframe.

read_multi_excel.py

import pandas as pd
import glob

def read_multi_excel(path):
    '''
    Given a file path with wildcard and extension, parse all files with that extension in directory 
    into a single dataframe.
    '''
    
    all_files = glob.glob(path)
    li = []
    
    for filename in all_files:
        df = pd.read_excel(filename, index_col=None, header=1)
        li.append(df)
        
    df = pd.concat(li, axis=0, ignore_index=True)
    
    return df