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.