TMDB stands for The Movie Database. In this project we will be investigating the TMDB Dataset which is providing us with various useful information regarding movies and how good or bad they performed both qualitatively and quantitatively. In this dataset there is movies from the year 1960 to 2015. Our aim is to get some insight into what makes movies get better reviews and get more viewers and hence make more revenues. This can give you an idea of how other viewers feel about the show.
- imdb_id: It represents imdb_id of the movie in the IMDB Database.
- popularity: It represents the popularity score of the movie.
- budget: It represents the budget of the movie in dollars.
- revenue: It represents the total revenue collected by the movie in dollars.
- original_title: It represents the title of the movie.
- cast: It tells the actors who acted in that movie.
- director: It tells the director of the movie.
- overview: It tells the overview of the plot of the movie.
- runtime: It tells the overall runtime of the movie in minutes
- genres: It represents the genres the movie represents.
- release_date: It tells the date of release of the movie.
- release_year: It tells the year in which the movie was released.
- Import Libraries : The first step to import libraries that are required like NumPy, matplotlib, seaborn and pandas by writing code.
- Load Dataset : Loaded TMDB Dataset through pandas read csv code.
- Data Wrangling : Ensured accuracy and consistency by removing null values and duplicate values, then derived significant columns for analysis.
- Data Analysis : Inserted additional profit column and then split one column to more columns.
- Data Interpretation : Drag various qualitative information through interpreting data.
- Data Visualization : Through Seaborn library, constructed various visuals for clear understanding.
- Which movie has a maximum budget and how much ?
- Which movie has a maximum profit and how much ?
- Which movie has a maximum popularity and how much ?
- Which movie has a maximum vote and how much ?
- Which movie has least profit and how much ?
- Which movie has least popularity and how much ?
- Which genre has gained the maximum profit ?
- Which genre has gained the maximum popularity ?
- Which genre has gained the maximum mean budget ?
- Which genre has gained the maximum mean revenue ?
- Which genre is most common between 1960-2015 ?
- In which year movies with the maximum mean budget has made ?
- In which year movies with the maximum mean profit has made ?
- In which year movies with the maximum mean revenue has made ?
- Which year we have more movies released ?
- "The Warrior's Way" movie has 425000000 budget which is the maximum budget than others.
- "Avatar" movie has 2544505847 profit which is the maximum profit than others.
- "Jurassic World" movie has 32.985763 popularity which is the maximum popularity than others.
- 'Inception' movie has 9767 votes which the maximum votes than others.
- "The Warrior's Way" movie has -413912431 loss, that means its revenue doesn't touch the total budget also and has suffered from greater loss.
- 'North and South, Book I' movie has got 6.5e-05 popularity only, which is the least popularity than others.
- Adventure genre has gained the maximum profit i.e. 7.559417e+07.
- Adventure genre has the maximum popularity i.e. 1.154259.
- Adventure genre has the maximum mean budget i.e. 3.754369e+07.
- Adventure genre has gained maximum mean revenue i.e. 1.131379e+08.
- Drama genre has made maximum movies i.e. 4672.
- Movies with the maximum mean budget were made in year 1999.
- Movies had the maximum mean profit in year 2015.
- Movies had the maximum mean revenue in year 2015.
- Maximum Movies were made in the year 2014.
This Report is helpful in gaining knowledge about the generation of movies after 1960, how film industry has developed itself that over time more and more movies were made per year. Starting at just 32 movies in 1960 up to 627 per year in 2015 with a max of 699 movies in 2014. From the given graphs in the project we can observe that revenue and profit developed almost in parallel until the early 1980s. In the 1980s budget is increasing more sharply. Probably as a consequence the gap between revenue and profit is starting to emerge. At the end of the 1990s budget starts decreasing, probably due to technological progress, and therefore profit starts to increase again. We also found that Drama is the most common genre (17.6%) followed by Comedy (14.2%) and then Thriller (10.7%). Hence we can gather more information about the movies from this Report.
- @Ritika821
- Ritika : Data Analyst