Concatenates Exel files into a DataFrame

excel_concat.py

#!/usr/bin/env python
# coding: utf-8

import pandas as pd
from pathlib import Path


def excel_cat(my_dir):
    """Concatenates Exel files into a DataFrame"""
    # Make a list of Excel files in the file path
    excel_dir = Path(my_dir)
    excel_list = list(excel_dir.glob('*xlsx'))

    # Convert each excel to Pandas DataFrame
    list_df = [pd.read_excel(each_excel) for each_excel in excel_list]

    # Concatenate the DFs into a single DF.
    df = pd.concat(list_df)

    return df


if __name__ == '__main__':
    file_dir = input('Excel path? >>  ')
    print(excel_cat(file_dir).head())