pandas beyond the basics
Take your knowledge of pandas to the next level, and become more efficient at processing and analysing data in Python.
About the course
This course helps analysts, researchers, BI experts and developers go beyond the basics of pandas: learning its more advanced features and the practices that make it possible to slice and dice complex data.
Through interactive examples and hands-on exercises, the course focuses on making your pandas code more efficient. Some basic familiarity with pandas and its core concepts is assumed.
Syllabus
Efficient data modelling
- Deep dive into pandas data types
- Choosing data types when loading the data
- Data type conversions
- Reducing memory usage when dealing with large datasets
Efficient data pipelines
- Understanding mutability and immutability
- Method chaining to improve readability
- Developing and maintaining complex data transformation and query pipelines
Efficient slicing and dicing
- Complex aggregations (groupby) on multiple columns
- Mastering the hierarchical (multi-level) index
- Index stacking and unstacking
- Pivoting and reshaping
Beyond pandas: exploring the ecosystem
- Other libraries built on top of pandas for specific needs in data preparation, analysis and visualisation