Pandas: Display the movies that received specified number of votes
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.
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
For more Practice: Solve these Related Problems:
- Write a Pandas program to filter movies_metadata.csv for movies that received a specified range of vote counts, then display title and vote_count.
- Write a Pandas program to create a function that accepts a vote count parameter and returns movies with vote_count equal to that value.
- Write a Pandas program to filter movies based on vote_count thresholds provided by the user and then sort the results by title.
- Write a Pandas program to extract movies with vote_count matching a specified criterion and generate a summary of the results.
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.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.