Answered step by step
Verified Expert Solution
Link Copied!

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 disney_movies.csv in the data/ directory contains information about 579 such Disney movies. Its columns are described below.
Column Description
'movie_title' Name of the movie
'genre' Genre of the movie
'MPAA_rating' Content rating, determining suitability for children
'total_gross' Total box office revenue
'adjusted_gross' Total box office revenue, after adjustment for inflation
'year' Year of release
Question 7.1. Read this file into a DataFrame called disney_movies.
'
disney_movies = bpd.read_csv('data/disney_movies.csv')
disney_movies
movie_title genre MPAA_rating total_gross adjusted_gross year
0 Snow White and the Seven Dwarfs Musical G 18492548552289532511937
1 Pinocchio Adventure G 8430000021882290521940
2 Fantasia Musical G 8332000021870908081940
3 Song of the South Adventure G 6500000010785105791946
4 Cinderella (1950) Drama G 850000009206087301950
.....................
574 The Light Between Oceans Drama PG-1312545979125459792016
575 Queen of Katwe Drama PG 887438988743892016
576 Doctor Strange Adventure PG-132325329232325329232016
577 Moana Adventure PG 2460820292460820292016
578 Rogue One: A Star Wars Story Adventure PG-135294839365294839362016
579 rows \times 6 columns
grader.check("q7_1")
q7_1 passed!
Question 7.2. Since the values in total_gross are so large, let's add a column to disney_movies called 'total_gross_millions' that contains the total box office revenue in millions of dollars. Similarly, create a column called 'adjusted_gross_millions' with the inflation-adjusted amounts in millions of dollars. Then, drop the original 'total_gross' and 'adjusted_gross' columns. Do not round.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions