Filtering Data - Pandas | Python ~ Episode 3
Hey Coders! After learning how to access and isolate the data in your pandas dataframe the 2nd most important operation is learning how to filter for the exact data that you want. For instance, let's say you had data on human heights across various ages. While examining your data, you may want to find the average height for just males, or just females, or maybe you want to find the ratio of males to females for those subjects whose height is greater than a certain value. All of these specifications are filters, and applying these filters to your dataframe is simple in pandas. In this video, we'll see the basic procedures and methods you can use for the vast majority of all filtering use cases.
Check out the source code on GitHub:
https://github.com/davidtheweiss/pand...
❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects! / davidweissprogramming
🧑💻 Pandas Documentation: https://pandas.pydata.org/docs/refere...
----------------------------------------------------------------------------------------------
🕒 Timestamps
0:00 Intro
1:10 Importing pandas and displaying the data
2:28 The basic structure of a filter
5:37 Passing a filter into loc provides more functionality
8:26 Common filter operators (==, &, |, ~)
12:05 isin()
13:26 str.contains()
15:08 str.len()
----------------------------------------------------------------------------------------------
Other playlists:
-------------------------------------
Python
-------------------------------------
Pandas:
• Pandas
-------------------------------------
Flutter
-------------------------------------
Basic Widgets:
• Flutter - Season 2 | Basic Widgets
Dart:
• Flutter - Season 1 | Dart
Flutter Orientation:
• Flutter - Season 0 | Orientation
-------------------------------------
Google Cloud
-------------------------------------
Compute Engine:
• Google Cloud - Season 2 | Compute Engine
App Engine:
• Google Cloud - Season 1 | App Engine
Google Cloud Orientation:
• Google Cloud - Season 0 | Orientation
-------------------------------------
Apps Script
-------------------------------------
Cache Service:
• Apps Script - Season 17 | Cache Service
JDBC Service:
• Apps Script - Season 16 | JDBC Service
Data Studio Service:
• Apps Script - Season 15 | Data Studio...
Maps Service:
• Apps Script - Season 14 | Maps Service
Utilities Service:
• Apps Script - Season 13 | Utilities S...
Properties Service:
• Apps Script - Season 12 | Properties ...
URL Fetch Service:
• Apps Script - Season 11 | URL Fetch S...
Drive Service:
• Apps Script - Season 10 | Drive Service
Forms Service:
• Apps Script - Season 9 | Forms Service
Lock Service:
• Apps Script - Season 8 | Lock Service
HTML Service:
• Apps Script - Season 7 | HTML Service
Document Service:
• Apps Script - Season 6 | Document Ser...
Slides Service:
• Apps Script - Season 5 | Slides Service
Calendar Service:
• Apps Script - Season 4 | Calendar Ser...
Script Service:
• Apps Script - Season 3 | Script Service
Gmail Service:
• Apps Script - Season 2 | Gmail Service
Spreadsheet Service:
• Apps Script - Season 1 | Spreadsheet ...
Apps Script Orientation:
• Apps Script - Season 0 | Orientation
----------------------------------------------------------------------------------------------