Python Pandas IMDb Movies Data: Exercises, Practice, Solution

Last update on December 21 2024 07:53:55 (UTC/GMT +8 hours)

[An editor is available at the bottom of the page to write and execute the scripts. Go to the editor]

Sample Table (based on IMDb - movies csv):
Download movies_metadata.csv table (50) records from here.

Pandas IMDb Movies Data Analysis [17 exercises with solution]

1. Write a Python Pandas program to get the columns of the DataFrame (movies_metadata.csv file).
Click me to see the sample solution

2. 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. 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. 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. 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. Write a Pandas program to get the details of the movie with title 'Grumpier Old Men'.
Click me to see the sample solution

7. Write a Pandas program to get the details of fifth movie of the DataFrame.
Click me to see the sample solution

8. Write a Pandas program to create a smaller DataFrame with a subset of all features.
Click me to see the sample solution

9. Write a Pandas program to display the first 10 rows of the DataFrame.
Click me to see the sample solution

10. Write a Pandas program to sort the DataFrame based on release_date.
Click me to see the sample solution

11. Write a Pandas program to access those movies, released after 1995-01-01.
Click me to see the sample solution

12. Write a Pandas program to sort movies on runtime in descending order.
Click me to see the sample solution

13. 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. Write a Pandas program to get the longest runtime and shortest runtime.
Click me to see the sample solution

15. Write a Pandas program to calculate the number of votes garnered by the 70% movie.
Click me to see the sample solution

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