Advanced Pandas (2021)

Advanced Pandas (2021)

1h 2mAdvanced2021-02-01

Authors

Brett Vanderblock

Brett Vanderblock

Data Scientist with Patagonia and Cofounder of Think Fast Analytics

Madecraft

Madecraft

Full-Service Learning Content Company

Course details

If you've worked in Python, you're likely familiar with the basic of pandas. In this advanced course, instructor Brett Vanderblock shares how you can take advantage of the advanced functions of pandas—such as working with dates, dealing with missing data, merging DataFrames, and more—to work more effectively with your data. First, Brett introduces you to DataFrames, identifies the top functions in pandas, and shows you how to configure your pandas workspace efficiently. He walks you through converting data types, working with strings, and using the apply map and applymap functions effectively. He shows you how to combine Groupby and multiple aggregate functions in pandas and how to use the merge, join, and concat functions. Brett steps through plotting and statistical functions with pandas. He concludes by explaining how you can use pandas-profiling and Geopandas to get the most out of your functions and data.

Skills covered

pandasPythonData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceDeep Dive (X:Y)

Concepts

Introduction

  • Take pandas to the next level

From Beginner to Advanced pandas

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

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

Transforming Dataframes

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

Exploratory Data Analysis & Visualization

  • Plotting with pandas
  • Correlations and statistical functions

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
40,000 Toman