Masking DataFrame rows

The .mask method performs the complement of the .where method. By default, it creates missing values wherever the Boolean condition is True. In essence, it is literally masking, or covering up, values in your dataset.

In this recipe, we will mask all rows of the movie dataset that were made after 2010 and then filter all the rows with missing values.

How to do it…

1. Read the movie dataset, set the movie title as the index, and create the criteria:

   >>> movie = pd.read_csv(
   ...     "data/movie.csv", index_col="movie_title"
   ... )
   >>> c1 = movie["title_year"] >= 2010
   >>> c2 = movie["title_year"].isna()
   >>> criteria = c1 | c2
   

2. Use the .mask method on a DataFrame to remove the values for all the values in rows with movies that were made from 2010. Any movie that originally had a missing value for title_year is also masked:

   ...