Numerical Computing with Python

How to do it...

1. Read in the movie dataset, set the index as the title, and then create a boolean Series matching all movies with a content rating of G and an IMDB score less than 4:

>>> movie = pd.read_csv('data/movie.csv', index_col='movie_title')>>> c1 = movie['content_rating'] == 'G'>>> c2 = movie['imdb_score'] < 4>>> criteria = c1 & c2

2. Let's first pass these criteria to the .loc indexer to filter the rows:

>>> movie_loc = movie.loc[criteria]>>> movie_loc.head()

3. Let's check whether this DataFrame is exactly equal to the one generated directly from the indexing operator:

>>> movie_loc.equals(movie[criteria])True

4. Now let's attempt ...