Advanced Pandas

Advanced Pandas

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 02m | 141 MB

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.

Table of Contents

1 Take pandas to the next level
2 Getting started with pandas
3 Intro to DataFrames using pandas
4 Top functions using pandas
5 Configuring options using pandas
6 Data type conversions using pandas
7 Working with strings using pandas
8 Working with dates using pandas
9 Dealing with missing data using pandas
10 Apply Map Applymap
11 Groupby and aggregations using pandas
12 Reshaping dataframes (pivot, stack)
13 Merging (merge, join) and concatenating (concat) dataframes
14 Mapping variables into groups
15 Plotting with pandas
16 Correlations and statistical functions
17 Accelerate EDA with pandas-Profiling
18 Explore Geographic data with Geopandas
19 Beyond pandas with Dask and Koalas (Spark)
20 Your path forward using advanced pandas functions