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$.$

$($

disney$\_100$m $=($disney$.$get$(\text{'}$adjusted$\_$gross$\_$millions'$)>100).$sum$()$

disney$\_100$m

$179$

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

q$7\_5$ passed!

Question $7\mathrm{.}6.$ Assign fifth$\_$highest$\_$revenue to the fifth$-$highest value of adjusted$\_$gross$\_$millions. Assign fifth$\_$highest$\_$name to the name of the movie with the fifth$-$highest adjusted revenue.

Again, don't type in these values by hand; get Python to extract this information for you.

Note: Remember that you can perform intermediate steps by adding new cells above the provided ones, or by adding in additional lines of code.

fifth$\_$highest$\_$revenue $=...$

fifth$\_$highest$\_$name $=...$

$$

# Don't change the lines below.

print$(\text{'}$Revenue:$\text{'},$ fifth$\_$highest$\_$revenue, 'million dollars'$)$

print$(\text{'}$Name:$\text{'},$ fifth$\_$highest$\_$name$)$

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

Question $7\mathrm{.}7.$ Disney is known for making movies for children, many of which are rated G for "general audiences". Let's see how much money Disney has earned in total across all of its G$-$rated movies. Find the sum of the total$\_$gross$\_$millions column for G$-$rated movies only, and assign your answer to g$\_$revenue.

g$\_$revenue $=...$

g$\_$revenue

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

Question $7\mathrm{.}8.$ Finally, let's see which genres are most popular by seeing how much money movies from each genre earn on average. Create a DataFrame called revenue$\_$by$\_$genre that is indexed by genre and contains just one column, called adjusted$\_$gross$\_$millions, which contains the average adjusted box office revenue of all movies from a given genre. Order the rows of revenue$\_$by$\_$genre in descending order of adjusted$\_$gross$\_$millions to see what genres Disney does best! $$

Hint: Our solution for this question used only one line of code $($thanks$,$ groupby$)!$