Information
AI Chat

This is a Premium Document. Some documents on Studocu are Premium. Upgrade to Premium to unlock it.

Imdb - IMDB Movie Analysis Final Project-1

IMDB Movie Analysis Final Project-1

Course

Data Analytics - Trainity

28 Documents

Students shared 28 documents in this course

University

Visvesvaraya Technological University

Academic year: 2023/2024

Uploaded by:

Anonymous Student

This document has been uploaded by a student, just like you, who decided to remain anonymous.

Visvesvaraya Technological University

Comments

Please sign in or register to post comments.

Preview text

Final Project- IMDB Movie Analysis By Shireen Fathima

Project description :

The main objective of this project is to analyse the movies dataset and understand the factors that lead to movies success.
It will also provide impact of various factors like genre, duration, budget etc on imdb ratings.
The insights will help investors, producers and directors take data driven decisions. Approach : ▪ Download the dataset ▪ Understand the data ▪ Data cleaning – removing null and duplicate columns , deleting all the unnecessary columns, and removing special characters. ▪ Using Excel and statistics formulas to solve the problems ▪ Create visuals to gain insights from it. Tech Stack Used: ▪ Microsoft Excel (2019) : To analyse the data and create visuals. ▪ Microsoft PowerPoint : To create report.

Descriptive Statistics

Count of movie_title Variance Standard Deviation

Genres like Action|Adventure|Sci-Fi , Comedy|crime and Comedy have high standard - 0. - 0. - 0. - 0. - 0. - 1. - 1. - 1. - 1. - - - - - - - - - - Drama Unique Genres Count - Comedy - Thriller - Action - Romance - Adventure - Crime - Fantasy - Sci-Fi - Family - Horror - Mystery - Biography - Animation - Music - War - History - Sport - Musical - Documentary - Western - Short - Film-Noir - News

Movie Duration Analysis: Task: Analyze the distribution of movie durations and identify the relationship between movie duration and IMDB score. Descriptive statistics of the Duration MEAN 109. MEDIAN 106. MODE 101. STANDARD DEVIATION 22. VARIANCE 515. MIN 34. MAX 330. SUM 3887. COUNT 427189. Duration of 80 to 130 has got the maximum of films and the imdb score lies between 4 – 8. Shortest movie duration is of 34 min whereas longest movie duration is of 330 min.

0.

2

4

6

8

10

12 0 50 100 150 200 250 300 350

imdb_score

Language Analysis: Task: Determine the most common languages used in movies and analyze their impact on the IMDB score using descriptive statistics. 3606 10 14 26 7 8 37 12 13 5 6. 6. 7 7. 7 7 7. 7 7 7 7.

0

1.

2

3

4

5

6

7

8

9

0

500 1000

1500

2000

2500

3000

3500

4000

English Hindi Mandarin Spanish Italian Cantonese French Japanese German Korean Portuguese Language Analysis Total Movies Average imdb_score English has the highest number of movies with an average imdb of 6. Portuguese, Korean, German, Japanese, French, Cantonese, Spanish, Italian, and Mandarin have higher average IMDb ratings This is due to consistent audience and fewer movies in these languages. We have used 11 most commonly used languages in movies

Languages Count of movie_title MEAN Variance Standard Deviation English 3606 6 1 1. French 37 7 0 0. Spanish 26 7 0 0. Mandarin 14 7 0 0. German 13 7 0 0. Japanese 12 7 0 0. Hindi 10 6 1 1. Cantonese 8 7 0 0. Italian 7 7 1 1. Korean 5 7 0 0. Portuguese 5 7 0 0. Average movie ratings are consistent across languages ranging from 6 – 7. Higher standard deviation mean more variability whereas variance gives us an idea of how spread the data is across mean.

Budget Analysis: Task: Analyze the correlation between movie budgets and gross earnings, and identify the movies with the highest profit margin.

237000000

150000000

200000000

11000000

10500000

760505847

652177271 658672302

460935665

523505847

502177271

458672302

449935665

Avatar Jurassic World Titanic Star Wars: Episode IV - A New Hope E. the Extra-Terrestrial Top 5 Profitable Movies budget gross Profit CORREL COEFFECIENT 0. Correl coefficient indicates the weak correlation between budget and gross across the dataset. Avatar movie has the highest profit. Star wars and Extra terrestrial despite low buget have huge profit. =CORREL($B$2:$B$ ,$C$2:$C$3787) Formula used:

THANK YOU

Excel file : docs.google/spreadsheets/d/10y- CnSXJR5oHGIbDDBXmQ5RoCnj5kH_V/edit?usp=sharing&ouid= 1&rtpof=true&sd=true

Was this document helpful?

Premium

This is a Premium Document. Some documents on Studocu are Premium. Upgrade to Premium to unlock it.