When using pandas, how to drop a row by its values and not by its label?

Question

I am trying to drop certain rows from a CSV file, but not by its label. I need to drop rows with certain values.

In this csv file, how would I drop every row with categroy == Physics?

Answer 1

Try this

df = df[df['Category'] != 'Physics']

Answer 2

Assuming you read the CSV into a dataframe df, we can do:

filtered = df[df["Category"] != "Physics"]