w3resource

Python Pandas IMDb Movies Data: Exercises, Practice, Solution

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

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). Go to the editor
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. Go to the editor
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). Go to the editor
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). Go to the editor
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. Go to the editor
Click me to see the sample solution

6. Write a Pandas program to get the details of the movie with title 'Grumpier Old Men'. Go to the editor
Click me to see the sample solution

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

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

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

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

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

12. Write a Pandas program to sort movies on runtime in descending order. Go to the editor
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. Go to the editor
Click me to see the sample solution

14. Write a Pandas program to get the longest runtime and shortest runtime. Go to the editor
Click me to see the sample solution

15. Write a Pandas program to calculate the number of votes garnered by the 70% movie. Go to the editor
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. Go to the editor
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. Go to the editor
Click me to see the sample solution

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



Python: Tips of the Day

Python: Annotated Assignment Statement

This might not seem as impressive as some other tricks but it's a new syntax that was introduced to Python in recent years and just good to be aware of.

Annotated assignments allow the coder to leave type hints in the code. These don't have any enforcing power at least not yet. It's still nice to be able to imply some type hints and definitely offers more options than only being able to comment regarding expected types of variables.

day: str = 'Monday'
print(day)
lst: list = [1,2,3,4]
print(lst)

Output:

Monday
[1, 2, 3, 4]

Or the same thing in a shorter way:

day= 'Monday' #str
print(day)
lst= [1,2,3,4] # list
print(lst)

Output:

Monday
[1, 2, 3, 4]