Question $7\mathrm{.}3.$ Create a new DataFrame, called disney, by setting the index of disney$\_$movies to 'movie$\_$title'. Don't change disney$\_$movies.

disney $=$ disney$\_$movies.set$\_$index$(\text{'}$movie$\_$title'$)$

disney

genre MPAA$\_$rating year total$\_$gross$\_$millions adjusted$\_$gross$\_$millions

movie$\_$title

Snow White and the Seven Dwarfs Musical G $1937184\mathrm{.}9254855228\mathrm{.}953251$

Pinocchio Adventure G $194084\mathrm{.}3000002188\mathrm{.}229052$

Fantasia Musical G $194083\mathrm{.}3200002187\mathrm{.}090808$

Song of the South Adventure G $194665\mathrm{.}0000001078\mathrm{.}510579$

Cinderella $(1950)$ Drama G $195085\mathrm{.}000000920\mathrm{.}608730$

$..................$

The Light Between Oceans Drama PG$-13201612\mathrm{.}54597912\mathrm{.}545979$

Queen of Katwe Drama PG $20168\mathrm{.}8743898\mathrm{.}874389$

Doctor Strange Adventure PG$-132016232\mathrm{.}532923232\mathrm{.}532923$

Moana Adventure PG $2016246\mathrm{.}082029246\mathrm{.}082029$

Rogue One: A Star Wars Story Adventure PG$-132016529\mathrm{.}483936529\mathrm{.}483936$

$579$ rows $\backslash$times $5$ columns

grader.check$("$q$7\_3")$

q$7\_3$ passed!

You should think about why we've chosen to set the index to 'movie$\_$title', instead of any other column.

Question $7\mathrm{.}4.$ Time for some movie trivia! What genre is the movie 'Finding Nemo' $$ and in what year was it released? Assign your answers to nemo$\_$genre, which should be a string, and nemo$\_$year, which should be an int.

Don't type in the answers by hand; get Python to extract this information for you.

year

nemo$\_$genre $=$ disney.get$(\text{'}$genre$\text{'}).$loc$[\text{'}$Finding Nemo'$]$

nemo$\_$year $=$ disney.get$(\text{'}$year$\text{'}).$loc$[\text{'}$Finding Nemo'$]$

$$

# Don't change the lines below.

print$(\text{'}$Genre$\text{'},$ nemo$\_$genre$)$

print$(\text{'}$Year:$\text{'},$ nemo$\_$year$)$

Genre Adventure

Year: $2003$

grader.check$("$q$7\_4")$

q$7\_4$ passed!

Question $7\mathrm{.}5.$ Disney has produced many successful films over the years. Find the number of movies with an adjusted box office revenue of over $100$ million dollars. Assign your answer to disney$\_100$m$.$