• Post category:StudyBullet-3
  • Reading time:7 mins read




Continue your data analysis journey with Python by mastering the fundamentals of the pandas library

What you will learn

 

Best practices from pandas expert Ted Petrou author of Master Data Analysis with Python

 

Select subsets of data from DataFrames with just the brackets, loc, and iloc

 

Learn how to simultaneously select rows and columns

 

Learn how to filter for specific criteria using boolean selection

 

Learn a more intuitive procedure for filtering data with the query method

 

Take a challenging Certification Exam to validate your knowledge gained

Description

Master Data Analysis with Python – Selecting Subsets of Data targets those who want to completely master doing data analysis with pandas. This is the second course in the Master Data Analysis with Python series and provides extremely detailed coverage of how to do any type of subset selection within a pandas DataFrame or Series.

Exercises and a Free Certification Exam

Over 100 exercises with detailed solutions are available for you to practice. Additionally, there is a free challenging certification exam offered for those who want to validate their knowledge gained.

Expert Instructor

This course is taught by expert instructor Ted Petrou, author of the highly-rated text books Pandas Cookbook and Master Data Analysis with Python. Ted has taught over 1,000 hours of live in-person data science courses that use the pandas library. Pandas is a difficult library to use effectively and is often taught incorrectly with poor practices. Ted is extremely adept at using pandas and is known for developing best practices on how to use the library.


Get Instant Notification of New Courses on our Telegram channel.


All of the material and exercises are written in Jupyter Notebooks available for you to download. This allows you to read the notes, run the code, and write solutions to the exercises all in a single place.

Become an Expert

This course targets those who have an interest in becoming experts and completely mastering the pandas library for data analysis in a professional environment. This course does not cover all of the pandas library, just a small and fundamental portion of it. If you are looking for a brief introduction of the entire pandas library, this course is not it. It takes many dozens of hours, lots of practice, and rigorous understanding to be successful using pandas for data analysis in a professional environment.

The Master Data Analysis with Python Series

Selecting Subsets of Data is second in the Master Data Analysis with Python series which includes the following sequence of courses:

  • Intro to Pandas

  • Selecting Subsets of Data with Pandas

  • Essential Pandas Commands

  • Grouping Data with Pandas

  • Time Series with Pandas

  • Cleaning Data with Pandas

  • Joining Data with Pandas

  • Data Visualization

  • Advanced Pandas

  • Exploratory Data Analysis

This course assumes no previous pandas experience. The only prerequisite knowledge is to understand the fundamentals of Python.

 

English
language

Content

Selecting Subsets of Data from DataFrames with just the brackets
Intro to Subset Selection
Selecting with Just the Brackets.mp4
Exercises
Selecting Subsets of Data from DataFrames with loc
Simultaneous row and column subset selection
Slice Notation with loc
Other Subset Selections with loc
Exercises
Selecting Subsets of Data with iloc
Simultaneous row and column subset selection
Exercises
Selecting Subsets of Data from a Series
Selecting Subsets of Data from a Series
Exercises
Boolean Selection Single Conditions
Boolean Selection Single Conditions
Practical Boolean Selection
Exercises
Boolean Selection Multiple Conditions
Different logical operators for boolean Series
Inverting a condition with the not operator
Many equality conditions in a single column
Boolean Selection More
Boolean Selection on a Series
Simultaneous boolean selection of rows and column labels with loc
Column to Column Comparison
Filter for Missing Values
Filtering with the query Method
Intro to the query Method
Column to Column Comparison within the query method
Arithmetic Operations within query
Reference Variable Names
Selecting Columns with query
Summary of the query Method
Going to the Exam Website
Completing the Exam
Submitting the Exam