Pandas: Get the details of the movie with title '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
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 get the details of the columns title and genres of the DataFrame.
Next: Write a Pandas program to get the details of fifth movie of the DataFrame.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics