Guides
pathlib vs os.path: Which Should You Use in Python?
pathlib vs os.path compared with side-by-side examples: joining paths, reading files, globbing and walking directories. Use pathlib unless you have a reason.
Read and Write Excel Files in Python (pandas, openpyxl)
Install openpyxl and use pandas to read and write Excel files: sheets, formulas, formatting, large files, the calamine engine change and common errors.