Pandas: Get the details of the movie with title 'Grumpier Old Men'
6. Details of 'Grumpier Old Men'
Write a Python Pandas program to get the details of the movie with title 'Grumpier Old Men'.
Sample Solution:
Python Code :
import pandas as pd
df = pd.read_csv('movies_metadata.csv')
#Set the index to the title
df = df.set_index('title')
#Details of the movie 'Grumpier Old Men'
result = df.loc['Grumpier Old Men']
print("Details of the movie 'Grumpier Old Men:")
print(result)
Sample Output:
Details of the movie 'Grumpier Old Men:
adult False
belongs_to_collection {'id': 119050, 'name': 'Grumpy Old Men Collect...
budget 0
genres [{'id': 10749, 'name': 'Romance'}, {'id': 35, ...
homepage NaN
id 15602
imdb_id tt0113228
original_language en
original_title Grumpier Old Men
overview A family wedding reignites the ancient feud be...
popularity 11.7129
poster_path /6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg
production_companies [{'name': 'Warner Bros.', 'id': 6194}, {'name'...
production_countries [{'iso_3166_1': 'US', 'name': 'United States o...
release_date 1995-12-22
revenue 0
runtime 101
spoken_languages [{'iso_639_1': 'en', 'name': 'English'}]
status Released
tagline Still Yelling. Still Fighting. Still Ready for...
video False
vote_average 6.5
vote_count 92
Name: Grumpier Old Men, dtype: object
For more Practice: Solve these Related Problems:
- Write a Pandas program to load movies_metadata.csv and display all details of the movie titled 'Grumpier Old Men'.
- Write a Pandas program to search movies_metadata.csv for a title containing 'Grumpier Old Men' (case insensitive) and print its row.
- Write a Pandas program to retrieve the record of 'Grumpier Old Men' and display only selected columns like title, release_date, and revenue.
- Write a Pandas program to load movies_metadata.csv, locate 'Grumpier Old Men', and output its details in a formatted table.
Go to:
PREV : Details of Columns Title and Genres.
NEXT : Fifth Movie Details.
Python-Pandas Code Editor:
Sample Table:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
