Q3: Create a series called 'directors' that contains each director's name and his or her average rating. Print out the type of your variable. Q4: Select the non-USA movies made after 1960 by Hayao Miyazaki. Save the result in a DataFrame called 'miyazaki', then print it. Here are the steps: 1. Query the data ('df' DataFrame) based on the following conditions: - Non-USA movies (country_id != 1) - Movies made after 1960 (title_year > 1960) - Movies made by director Hayao Miyazaki (director_id == 46) 2. Save the filtered data in a DataFrame called 'miyazaki' and print it Q5: Create a Pivot Table that shows the median rating for each director, grouped by their respective countries. Name your variable 'pivot_agg' Q6: How long did the movie Gladiator aim to keep your attention? Save the series with this information in a variable called 'gladiator_duration', then print it.
PLEASE DO IT IN PYTHON
Q3:
Create a series called 'directors' that contains each director's name and his or her average rating. Print out the type of your variable.
Q4:
Select the non-USA movies made after 1960 by Hayao Miyazaki.
Save the result in a DataFrame called 'miyazaki', then print it.
Here are the steps:
1. Query the data ('df' DataFrame) based on the following conditions:
- Non-USA movies (country_id != 1)
- Movies made after 1960 (title_year > 1960)
- Movies made by director Hayao Miyazaki (director_id == 46)
2. Save the filtered data in a DataFrame called 'miyazaki' and print it
Q5:
Create a Pivot Table that shows the median rating for each director, grouped by their respective countries. Name your variable
'pivot_agg'
Q6:
How long did the movie Gladiator aim to keep your attention? Save the series with this information
in a variable called 'gladiator_duration', then print it.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
