Ex 3.4 Filtering a Dataframe:

Objective: Learn how to filter a pandas Dataframe.

  1. Download the Ex3.4_Filtering.ipynb file.
  2. Work through parts 1 through 3.2 and submit your completed Jupyter Notebook (.ipynb) file to the first quiz question on Canvas. Your notebook should include both your code and the corresponding output that match the screengrabs provided below. Be sure to run all cells so that every output appears in the notebook.

Part 1:

Expected output: filtered pandas DataFrame showing Part 1 results with boolean filter applied

 

Expected output: proof that the Part 1 filter worked showing verified row count and values

Part 2:

Expected output: filtered DataFrame for Part 2 applying a second condition to the dataset

 

Expected output: proof that the Part 2 filter worked correctly showing row count verification

Part 3.1:

Expected output: DataFrame filtered with multiple AND conditions for Part 3.1

 

Expected output: proof that the Part 3.1 multi-condition filter worked with row count verification

Part 3.2:

Expected output: DataFrame filtered with OR conditions for Part 3.2

 

Expected output: proof that the Part 3.2 OR-condition filter worked with row count verification