Analysis of Movie Profitability

By: Jagandeep Singh & Eryk Wdowiak

Introduction

In this project we develop a dataset of 2312 movies. The data includes budget, domestic_gross, worldwide_gross, rating, principals, studio, genres and other information collected from several sources. We then prepared an analysis and visualizations with Pandas, numpy, Matplotlib and seaborn.

Here is a link to our presentation: Below is the description of this project and our work.

Project Goals

Our goal in this project is to answer the following questions using the data provided.

1. An Overview of Movie profitability
2. What is the relationship between:
   -a Movie’s Production Budget and its Profitability
   -the Month of Release and Profitability
   -Genres and Profitability
   -Ratings and Profitability

Data Cleaning

After loading all the data files, our first step was to clean the data. Since the data was lay out over multiple files, our first task was to merge the useful data in one pandas dataframe. We went through all of the given data files to clean the data and merge it appropriately. Our goal in data cleaning was to get everything we need in one place to make it easy for our exploratory data analysis.

Data Analysis and Visualization

Our first goal was an overview of movie profitability. We looked at the log of production budget and worldwide_gross, then we calculated log of profit for each movie. Then a histogram was plotted for log of profit. Then we looked at if movie's production budget is related to profitability. Similarly we looked at how was profitability related to month of release, genres and ratings of those movies. Here are some of the plots.

Histogram for rate of return.

Scatter plot of rate of return and ln budget

Average profit of movies by Release month

Percentage of genres in Most and Least profitable movies

Bar plot of ratings and profit of movies

Conclusion

Recommendations

Based on our analysis on rate of return, most movie investments are very profitable.
Larger movie budgets are associated with high rate of return.
We found that movies released in June and December are more profitable.
In terms of genres, Action, Adventure and Sci-Fi movies are most profitable whereas
Drama and comedy movies are least profitable.
We also found that highest rated movies are more profitable than low rated movies.

Here is the link to our presentation:

Movie-Analysis-Presentation