Planet Python
Follow
LernerPython blog, from Reuven Lerner: Free real-world Pandas exercises, with solutions
The author emphasizes that to improve at Pandas, one needs to practice with real-world data, not just tidy tables. The author has written Bamboo Weekly, a weekly set of Pandas exercises based on real, current, public data, for the last 3.5 years. As of now, issues older than two years are available for free, with over 500 exercises and fully worked-out solutions. The author highlights that real data teaches you how to handle messy data, such as badly named columns and inconsistent date formats. The exercises in Bamboo Weekly are designed to mimic real-world problems, requiring multiple steps to solve. The author also provides method guides for 16 common Pandas methods, covering what the method does, examples, and common mistakes. These guides are verified against Pandas 3 and include links to matching exercises on the LernerPython practice system. The author suggests starting with a method guide or an exercise that interests you and trying to solve it before reading the solution. The goal of Bamboo Weekly is to improve your data-analysis muscle memory, making you more confident in tackling problems at work. By practicing with real data and learning from common mistakes, you can become more proficient in using Pandas and improve your overall data analysis skills.