Advanced Pandas
Advanced Pandas
What you’ll learn
Skills you’ll gain
If you've worked in Python, you're likely familiar with the basics of Pandas. In this course, Patagonia data scientist Brett Vanderblock shares how you can take advantage of the advanced functions of Pandas to work more effectively with your data. From advanced calculations to exploratory data analysis, you will learn how to work with dates, deal with missing data, merge dataframes, map/apply Lambda functions and much more. By the end of this course, you'll feel confident working with advanced Pandas.
Syllabus
Download syllabus-
1
Getting started with pandas pandas is the key python library for dealing with your data with all sorts of neat functions. 1m
-
2
Intro to DataFrames using pandas There are a few key things to know about working with dataframes. 2m
-
3
Top functions using pandas Do you know the top functions that are used in pandas? After watching this video, you'll be able to identify the top functions in pandas. 3m
-
4
Configuring options using pandas There are a few options you should be aware of when configuring your pandas workspace. 1m
-
1
Data type conversions using pandas Do you know how to convert your data types? After watching this video, you'll be able to convert data types. 2m
-
2
Working with strings using pandas There are a few key things you should know about using strings. After watching this video, you'll be able to effectively work with strings. 2m
-
3
Working with dates using pandas There are a few key things you should know about handling date data. 3m
-
4
Dealing with missing data using pandas Missing data can really derail an analysis. After watching this video, you'll be able to handling missing data with pandas functions. 4m
-
5
Apply/Map/Applymap Do you know how to use the apply and map functions? After watching this video, you'll be able to use the apply map and applymap functions effectively. 3m
-
1
Groupby and aggregations using pandas Do you know how to combine Groupby and Multiple Aggregate Functions in pandas? 3m
-
2
Reshaping DataFrames (pivot, stack) Reshaping DataFrames can be done simply. After watching this video, you'll be able to reshape your dataframes using pivot and stack. 5m
-
3
Merging (merge, join) and concatenating (concat) DataFrames Combining data from different DataFrames is essential to getting the most out of your data. 5m
-
4
Mapping variables into groups Pandas has capabilities to make categorizing your data simpler. After watching this video, you'll be able to map your variables into groups. 3m
-
1
Plotting with pandas Plotting can be done simply using pandas functions. After watching this video, you'll be able to plot with advanced pandas functions. 4m
-
2
Correlations and statistical functions Statistics functions are right at your fingertips in pandas. 4m
-
1
Accelerate EDA with pandas-Profiling Exploratory Data Analysis can be done easily in python. After watching this video, you'll be able to make use of pandas-profiling for fast EDA. 3m
-
2
Explore Geographic data with Geopandas Working with geographic data is easy and rewarding with Geopandas. 2m
-
3
Beyond pandas with Dask and Koalas (Spark) When dealing with truly big data, there are other optimized approaches outside of pandas. 2m
-
1
Your path forward using advanced pandas functions Congratulations on completing this course! 1m
Certificate
Certificate of Completion
Awarded upon successful completion of the course.
Instructor
Brett Vanderblock
Brett Vanderblock is a data scientist with Patagonia and co-founder of Think Fast Analytics. He has proven experience surfacing insights across industries, from start-ups, state and local governments, higher education, healthcare, to retail. He is always furthering his deep expertise in machine learning, data visualization, and data pipelines. An educator at heart, Brett enjoys providing "data therapy" to enable others to realize the benefits of their data through self-service analytics.
Brett Vanderblock
Data Scientist
Accreditations
Link to awards
How GoSkills helped Chris
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth. Seeing how much this has helped me become a more efficient employee is a big motivation.
