Pandas: Display the movies that received specified number of votes

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

Write a Pandas program to display the movies (title, number of votes) that received specified number of votes.

Sample Solution:

Python Code :

import pandas as pd
df = pd.read_csv('movies_metadata.csv')
n = 500
small_df = df[['title', 'vote_count']]
result = small_df[small_df['vote_count'] >= n]
print("List of movies longer than 30 minutes and shorter than 360 minutes:")
print(result)

Sample Output:

 List of movies longer than 30 minutes and shorter than 360 minutes:
                             title  vote_count
0                        Toy Story        5415
1                          Jumanji        2413
5                             Heat        1886
9                        GoldenEye        1194
15                          Casino        1343
17                      Four Rooms         539
18  Ace Ventura: When Nature Calls        1128
31                  Twelve Monkeys        2470
33                            Babe         756
38                        Clueless         828
46                           Se7en        5915
47                      Pocahontas        1509
49              The Usual Suspects        3334
                       

Python-Pandas Code Editor:

Sample Table:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to display the movies (title, runtime)longer than 30 minutes and shorter than 360 minutes.
Next: Python Pandas Data Series, DataFrame Exercises Home.