Excel
pandas io tools
https://pandas.pydata.org/pandas-docs/stable/user_guide/io.html#excel-files
pandas.read_excel
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
pandas.DataFrame.to_excel
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html
Tips
A Complete Guide to Automating Excel with Python | by Sigli Mumuni | May, 2022 | MediuM
https://medium.com/@siglimumuni/a-complete-guide-to-automating-excel-with-python-5d2a62cb2902