Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The file disney _ movies.csv in the data / directory contains information about 5 7 9 such Disney movies. Its columns are described below. Column
The file disneymovies.csv in the data directory contains information about such Disney movies. Its columns are described below.
Column Description
'movietitle' Name of the movie
'genre' Genre of the movie
'MPAArating' Content rating, determining suitability for children
'totalgross' Total box office revenue
'adjustedgross' Total box office revenue, after adjustment for inflation
'year' Year of release
Question Read this file into a DataFrame called disneymovies.
disneymovies bpdreadcsvdatadisneymovies.csv
disneymovies
movietitle genre MPAArating totalgross adjustedgross year
Snow White and the Seven Dwarfs Musical G
Pinocchio Adventure G
Fantasia Musical G
Song of the South Adventure G
Cinderella Drama G
The Light Between Oceans Drama PG
Queen of Katwe Drama PG
Doctor Strange Adventure PG
Moana Adventure PG
Rogue One: A Star Wars Story Adventure PG
rows times columns
grader.checkq
q passed!
Question Since the values in totalgross are so large, let's add a column to disneymovies called 'totalgrossmillions' that contains the total box office revenue in millions of dollars. Similarly, create a column called 'adjustedgrossmillions' with the inflationadjusted amounts in millions of dollars. Then, drop the original 'totalgross' and 'adjustedgross' columns. Do not round.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started