Install pip & pandas
curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
python3 get-pip.py
pip --version
pip install pandas
pip install openpyxl
Reference:
Combine Multiple Excel Worksheets Into a Single Pandas Dataframe
How to Install Pip on Mac
This script is used to merge 2 sheets in a single xlsx file
Pandas Documentation on pandas read_excel: https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html
Reference: https://www.youtube.com/watch?v=OB_ixIlQbWI