SigmaAnalytics & Tech
C4PythonIntermediateAbout 110 min to complete

Selecting & Filtering Data

Precise, safe access to any subset of a DataFrame — and a definitive answer to the warning that confuses people for years.

Notebook

About 110 minutes to complete

Enrol to read the notebook and download it to run.

What this module covers

Precise, safe access to any subset of a DataFrame — and a definitive answer to the warning that confuses people for years.

By the end of it

  • Select rows and columns with .loc and .iloc in two dimensions
  • Filter with boolean masks, combining conditions safely
  • Use .isin, .between, .str.contains, and .query idiomatically
  • Explain what SettingWithCopyWarning means and fix it correctly
  • Select by dtype with .select_dtypes
  • Sample rows reproducibly
  • Choose between .loc, .query, and .filter for readability
  • Build a reusable multi-criteria filtering function