PyPath
Start learning

Unit 6 · Filtering and Deriving

Choosing rows, and building the column that answers your question.

  1. 1Filtering with MasksThe same idea as numpy, applied to whole rows.
  2. 2isin, between and queryThree ways to say a condition that reads like the question.
  3. 3Derived ColumnsThe column that answers your question usually is not in the file.
  4. 4apply, and When Not ToA general escape hatch that is slower than the thing it usually replaces.
  5. 5Binning ValuesTurning a measurement into a band you can count.
  6. 6Sorting and Top NOrdering a table, and taking the few rows that matter.