Advanced Pandas

Learn the advanced functions in pandas that can help you more effectively work with your data.

Introduction

• Take pandas to the next level

1. From Beginner to Advanced pandas

• Getting started with pandas
• Intro to DataFrames using pandas
• Top functions using pandas
• Configuring options using pandas

2. Advanced Calculations

• Data type conversions using pandas
• Working with strings using pandas
• Working with dates using pandas
• Dealing with missing data using pandas
• Apply/Map/Applymap

3. Transforming Dataframes

• Groupby and aggregations using pandas
• Reshaping dataframes (pivot, stack)
• Merging (merge, join) and concatenating (concat) dataframes
• Mapping variables into groups

4. Exploratory Data Analysis & Visualization

• Plotting with pandas
• Correlations and statistical functions

5. Beyond pandas

• Accelerate EDA with pandas-Profiling
• Explore Geographic data with Geopandas
• Beyond pandas with Dask and Koalas (Spark)

Conclusion

• Your path forward using advanced pandas functions