Pandas: Sort movies on runtime in descending order

Pandas: IMDb Movies Exercise-12 with Solution

Write a Pandas program to sort movies on runtime in descending order.

Sample Solution:

Python Code :

import pandas as pd
df = pd.read_csv('movies_metadata.csv')
small_df = df[['title', 'release_date', 'budget', 'revenue', 'runtime']]
#Sort Movies based on runtime (in descending order)
result = small_df.sort_values('runtime', ascending=False)
print("DataFrame sort on Runtime.")

Sample Output:

DataFrame sort on Runtime.
                    title release_date    budget    revenue  runtime
13                  Nixon   1995-12-22  44000000   13681765    192.0
15                 Casino   1995-11-22  52000000  116112375    178.0
5                    Heat   1995-12-15  60000000  187436818    170.0
16  Sense and Sensibility   1995-12-13  16500000  135000000    136.0
22              Assassins   1995-10-06  50000000   30303072    132.0  

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 access those movies,released after 1995-01-01.
Next: Write a Pandas program to get those movies whose revenue more than 2 million and spent less than 1 million.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Follow us on Facebook and Twitter for latest update.