This is a set of small projects and tutorials presented in the textbook: https://automatetheboringstuff.com/
The material here covers a range of topics from basic Python syntax to more advanced topics such as regular expressions, web scraping, working with .xlsx, .csv, .json data formats, and more.