Python Pandas IMDb Movies Data: Exercises, Practice, Solution
This resource offers a total of 85 Pandas IMDb Movies Data Analysis problems for practice. It includes 17 main exercises, each accompanied by solutions, detailed explanations, and four related problems.
[An Editor is available at the bottom of the page to write and execute the scripts.]
Sample Table (based on IMDb - movies csv):
Download movies_metadata.csv table (50) records from here.
1. Getting DataFrame Columns
Write a Python Pandas program to get the columns of the DataFrame (movies_metadata.csv file).
Click me to see the sample solution
2. DataFrame Information
Write a Pandas program to get the information of the DataFrame (movies_metadata.csv file)including data types and memory usage.
Click me to see the sample solution
3. Third Movie Details
Write a Pandas program to get the details of the third movie of the DataFrame (movies_metadata.csv file).
Click me to see the sample solution
4. Count Rows and Columns
Write a Pandas program to count the number of rows and columns of the DataFrame (movies_metadata.csv file).
Click me to see the sample solution
5. Details of Columns Title and Genres
Write a Pandas program to get the details of the columns title and genres of the DataFrame.
Click me to see the sample solution
6. Details of 'Grumpier Old Men'
Write a Pandas program to get the details of the movie with title 'Grumpier Old Men'.
Click me to see the sample solution
7. Fifth Movie Details
Write a Pandas program to get the details of fifth movie of the DataFrame.
Click me to see the sample solution
8. Create a Subset DataFrame
Write a Pandas program to create a smaller DataFrame with a subset of all features.
Click me to see the sample solution
9. Display First 10 Rows
Write a Pandas program to display the first 10 rows of the DataFrame.
Click me to see the sample solution
10. Sort by Release Date
Write a Pandas program to sort the DataFrame based on release_date.
Click me to see the sample solution
11. Movies Released After 1995-01-01
Write a Pandas program to access those movies, released after 1995-01-01.
Click me to see the sample solution
12. Sort by Runtime Descending
Write a Pandas program to sort movies on runtime in descending order.
Click me to see the sample solution
13. Movies with Revenue > 2M and Spent < 1M
Write a Pandas program to get those movies whose revenue more than 2 million and spent less than 1 million.
Click me to see the sample solution
14. Longest and Shortest Runtime
Write a Pandas program to get the longest runtime and shortest runtime.
Click me to see the sample solution
15. Calculate Votes for the 70% Movie
Write a Pandas program to calculate the number of votes garnered by the 70% movie.
Click me to see the sample solution
16. Movies with Runtime Between 30 and 360 Minutes
Write a Pandas program to display the movies (title, runtime) longer than 30 minutes and shorter than 360 minutes.
Click me to see the sample solution
17. Movies with Specified Number of Votes
Write a Pandas program to display the movies (title, number of votes) that received specified number of votes.
Click me to see the sample solution
Python-Pandas Code Editor:
More to Come !
Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.
Test your Python skills with w3resource's quiz