Move from Excel to Python with Pandas Transcripts
Chapter: Data wrangling with Pandas
Lecture: Concept: Filtering data

Login or purchase this course to watch this video and the rest of the course contents.
0:00 When I'm working with Excel, one of the most common things I use is the Excel Auto Filter. This is a really useful way to sort and filter your data
0:09 by multiple criteria. Pandas conduce something very similar to this and in many ways more powerful using Boolean indexing and the local command.
0:18 So Boolean Index, in this example here shows all of the rows that have the
0:23 company named Viva. And then we could have another Boolean Index that tells us how many purchases are greater than 10.
0:31 And then we can combine these two using the local command to select all of the rows and all the columns where it is company Viva!
0:41 And they purchased at least 10 items.

Talk Python's Mastodon Michael Kennedy's Mastodon