Project_1

Analyzing IMDB Movie Dataset

The Objective of this project is to analyze the IMDb Movie Dataset to uncover trends in ratings, genres and Revenues and Analyzing Based on the given Questions ..

import pandas as pn df = pn.read_csv("IMDBMovie.csv") df

TASK-1

#How many rows are there in the IMDB dataset? df.shape[0]

Code Commentary : df.shape[0] retrieves the number of rows present in the Dataframe named as df.

TASK-2

# What is the 75th percentile of rating in the IMDB dataset? df.describe()

Code Commentary : The function df.describe() provides summary statistics for numerical columns in the DataFrame df, including count, mean, standard deviation, minimum, quartiles, and maximum values.

TASK-3

# How many NA values are there in the field ‘Revenue’? df['Revenue_millions'].isnull().sum()

Code Commentary : Using sum function calculates the total number of missing values in the 'Revenue_millions' column of the DataFrame df.

TASK-4

#How many movies have revenue higher than 75 million? (df['Revenue_millions'] > 75).sum()

Code Commentary : Count the Sum of occurrences where the 'Revenue_millions' column in DataFrame df has a value greater than 75.

TASK-5

# How many movies have revenue great"er than 50 million but rating less than 7? df[(df["Revenue_millions"] > 50) & (df["Rating"] < 7)]["Title"].count()

Code Commentary : Counts the number of movies in DataFrame df Using count function that have a revenue greater than 50 million and a rating less than 7.

TASK-6

# What is the total revenue generated by movies in the year 2015? df[df["Year"] == 2015]["Revenue_millions"].sum()

Code Commentary : Calculates the total revenue generated by movies released in the year 2015 in the DataFrame df.

TASK-7

# What is the average rating for the genre adventure in the year 2015? df[(df["Genre"] == "Adventure") & (df["Year"] == 2015)]["Rating"].mean()

Code Commentary : Computes the average rating of adventure genre movies released in the year 2015 in the DataFrame df.

TASK-8

# What is the average duration of movies in rows 75 to 150? Please note that the rows in python start from 0. df.iloc[75:151]["Runtime_minutes"].mean() #OR cond = df.iloc[75:151] cond ["Runtime_minutes"].mean()

Code Commentary : Using mean function Calculates the average runtime in minutes for the movies indexed from 75 to 150 in the DataFrame df.

TASK-9

# Which year generated the highest revenue? df.groupby(by = "Year")["Revenue_millions"].sum().sort_values(ascending = False)

Code Commentary : Here Using groupby function groups the DataFrame df by the "Year" column, calculates the sum of "Revenue_millions" for each year, and show the results in descending order based on the total revenue.

TASK-10

# What is the maximum revenue out of (10,20,30,40,50) rows? df.iloc[10:60:10]["Revenue_millions"].max()

Code Commentary : By using iloc function it selects every 10th row from index 10 to index 59 in the DataFrame df, and then calculates the maximum value of the "Revenue_millions" column within this subset.

TASK-11

# How many movies with the genres ‘Adventure’, ‘Action’, ‘Horror’, and ‘Crime’ exist in the IMDB dataset? df[df["Genre"].isin(["Adventure","Action","Horror","Crime"])]["Title"].count()

Code Commentary : Using Count Function counts the number of movies in the DataFrame df that belong to the genres Adventure, Action, Horror, or Crime.

TASK-12

# Create a genre-level report with metrics average rating, the average number of votes, and average revenue. # What is the average rating of the ‘Horror’ genre? df[df["Genre"] == "Horror"]["Rating"].mean()

Code Commentary : Calculates the mean (average) rating of movies belonging to the Horror genre in the DataFrame df.

TASK-13

# How many movies has Billy Ray directed and find the year of release of those movies cond = df[df["Director"] == "Billy Ray"]["Title"].count() print("The no of movies has Billy Ray directed is",cond) year = df[df["Director"] == "Billy Ray"]["Year"] print("The year of movie that billy ray directed is",year)

Code Commentary : This code first counts the number of movies directed by "Billy Ray" and stores it in the variable cond. It then prints this count. Next, it retrieves the years of the movies directed by "Billy Ray" and prints them.

TASK-14

# How many movies were released in the year 2012 - 14. What type of genre were released the most x = df[df["Year"].isin([2012,2013,2014])]["Title"].count() print("The no of movies were released in the year 2012 - 14 is",x) y= df[df["Year"].isin([2012,2013,2014])]["Genre"].min() print("Type of Genre were released the most is",y)

Code Commentary : In 1st Line of code counts the number of movies released between 2012 and 2014 and i stored it in variable x, then prints it out. Subsequently, it determines the genre that appears first alphabetically among the movies released in that time frame, storing it in variable y, and prints out the most released genre.

TASK-15

# Which Movie had the highest vote and what genre it belongs to. print(df[df["Votes"] == df["Votes"].max()]["Title"]) df[df["Votes"] == df["Votes"].max()]["Genre"]

Code Commentary : This code prints the titles of the movie(s) with the maximum number of votes and retrieves their corresponding genres.

TASK-16

# Find the Director whose movie grossed the highest. Also find the total revenue generated by that director x = df[df["Revenue_millions"] == df["Revenue_millions"].max()]["Director"] print("The Director whose movie grossed the highest is",x) y = df[df["Director"] == 'J.J. Abrams']["Revenue_millions"].sum() print("The total revenue generated by director J.J. Abrams is",y)

Code Commentary : First I identifies the directors whose movies grossed the highest revenue and stores the director names in variable x, then prints it out. I got the answer as "j.j.Abrams" And I calculates the total revenue generated by the director "J.J. Abrams" and stores it in variable y, and prints out the total revenue.

TASK-17

#Create a report to showcase the revenue of each movie, as % revenue concerning the total revenue of the respective genre and year of the movie. #For example if a movie ‘ABC’ has genre ‘Action’ and released in 2015, then % revenue will be #(Revenue of the movie ‘ABC’ *100)/ (Total revenue of the genre ‘Action’ in 2015) #What is the % revenue of the movie ‘Split’ in its respective genre and year? df['%_Revenue'] = (df['Revenue_millions'] / df.groupby(['Genre', 'Year'])['Revenue_millions'].transform('sum')) * 100 split_revenue = df[df['Title'] == 'Split']['%_Revenue'].values[0] print(f'The % revenue of the movie ‘Split’ in its respective genre and year is : {split_revenue:}')

Code Commentary : This code snippet calculates the percentage of revenue generated by each movie within its respective genre and year, assigns it to a new column named '%_Revenue', and then extracts the percentage revenue of the movie 'Split' using its respective genre and year. Finally, it prints out the percentage revenue of the movie 'Split'.