Python for Data · Unit 6
Unit 6: Filtering and Deriving
Filter pandas rows with conditions and add columns that answer questions.
Lessons
- Filtering with MasksThe same idea as numpy, applied to whole rows.
- isin, between and queryThree ways to say a condition that reads like the question.
- Derived ColumnsThe column that answers your question usually is not in the file.
- apply, and When Not ToA general escape hatch that is slower than the thing it usually replaces.
- Binning ValuesTurning a measurement into a band you can count.
- Sorting and Top NOrdering a table, and taking the few rows that matter.
-
Take the Unit 6 test
End of unit test
Ten multiple choice questions and one free response problem. You need 70 to finish the unit. Retakes are unlimited and your best score is the one that counts.