w3resource

Pandas: Get those movies whose revenue more than 2 million and spent less than 1 million

Pandas: IMDb Movies Exercise-13 with Solution

Write a Pandas program to get those movies whose revenue more than 2 million and spent less than 1 million.

Sample Solution:

Python Code :

import pandas as pd
df = pd.read_csv('movies_metadata.csv')
small_df = df[['title', 'release_date', 'budget', 'revenue', 'runtime']]
result = small_df[(small_df['revenue'] > 2000000) & (small_df['budget'] < 1000000)]
print("Movies, revenue more than 2 million and spent less than 1 million:")
print(result.head())

Sample Output:

Movies, revenue more than 2 million and spent less than 1 million:
                          title release_date   ...       revenue  runtime
4   Father of the Bride Part II   1995-02-10   ...      76578911    106.0
12                        Balto   1995-12-22   ...      11348324     78.0
30              Dangerous Minds   1995-08-11   ...     180000000     99.0

[3 rows x 5 columns]                                      

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 sort movies on runtime in descending order.
Next: Write a Pandas program to get the longest runtime and shortest runtime.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://198.211.115.131/python-exercises/pandas/movies/python-pandas-movies-exercise-13.php