A

PROJECT REPORT ON

“Netflix Data Analysis”

Submitted By
Bambale Trupti Balasaheb

Under the Guidence of

Ms. Panchariya S.O.
Ms. Hase P.A.
MASTER OF COMPUTER APPLICATION

S.N. ARTS, D.J.M. COMMERCE & B.N.S. SCIENCE COLLEGE SANGAMNER

(AUTONOMOUS) COLLEGE

AFFILIATED WITH

SAVITRIBAI PHULE PUNE UNIVERSITY

DURING ACADEMIC YEAR

2025-2026
SHIKSHAN PRASARAK SANSTHA’S : (02425) 225893 (0),
SANGAMNER NAGARPALIKA ARTS, 225164 (R)
D.J. MALPANI COMMERCE & : (02425) 225893
B.N. SARDA SCIENCE COLLEGE Website : [Link]
SANGAMNER(AUTONOMOUS) COLLEGE E-mail : sangamnercollege@[Link]
-422605 Dist. –AHMEDNAGAR • NAAC Re-accredited College (A+ Grade)
(Id No. PU/AN/ASC/03/1961) • Pune University Best College
“Spread knowledge unto the last” • DBT Star College, DST-FIST

I/C PRINCIPAL
DR. A. H. GAIKWAD,
[Link]., [Link]., Ph.D., D.C.F.A

CERTIFICATE

This certificate is to certify the Project Entitled

“Netflix Data Analysis”
Is the bonafide work carried out by Bambale Trupti Balasaheb student of [Link]. (Computer
Application) – II during year 2025-2026 in partial fulfilment of the requirement for the award of
Master of computer application.

Date : / /2026

Project Guide Head Of Department

Internal Examiner IT Expert / External Examiner

 ACKNOWLEDGEMENT

I am using this opportunity to express my gratitude to everyone who supported me

throughout the course of this [Link]. (Comp. Application.)-II project. I am thankful for their
aspiring guidance, invaluably constructive criticism and friendly advice during the project work.
I am sincerely grateful to them for sharing their truthful and illuminating views on a number of
issues related to the project.
Today I am very pleased as I am presenting the project report on the Ecommerce website
of "Netflix Data Analysis".
I express my warm thanks to Ms. Tanusha Majumdar for their support and guidance at
Internship Studio Firstly we would to like to thank S. N. Arts, D. J. Malpani Commerce &
B. N. Sarda Science College (Autonomous), Sangamner and Department of Computer
Science for giving us an opportunity. Thanks to Ms. Panchariya S.O. and Ms. Hase P.A. for
her encouragement and valuable guidance.
I hereby take opportunity to regard my sincere thanks to internal guide Ms. Panchariya
S.O. and Ms. Hase P.A. for her kind co-operation during the project. Her efforts have been
monumental in the completion of this project. She has been very generous with her advice,
views, ideas and always ensured that I was on the right track. Taking this opportunity, would
also like to thanks our Principal Dr. Gaikwad A.H., Head of Department Mr. Pansare S,Y.,
Department incharge Ms. Khambekar R. S., Department of Computer Application Staff
for their valuable guidance during development of my project and encouraging me.
Last but not least, I most thanks to all my friends, colleagues who helped me a lot
throughout the project it is their support, cheerfulness, encouragement and helping nature with
which our project might not have been completed.
Any on mission in this brief acknowledgement does not meet lack of gratitude.
Thank You…!

Bambale Trupti Balasaheb

[Link]. (Comp. Application)-II
 Index
[Link] TITLE Page No.
1 Introduction 1
1.1 Company Profile
1.2 Abstract
1.3 Problem Definition
1.4 Existing System & Need for System
1.5 Scope of System
2 Proposed System 11
2.1 Feasibility Study
2.2 Fact Finding Technique
2.3 Objective of System
2.4 User Requirement
3 System Analysis & Design 16
3.1 ER Diagram
3.2 UML Diagrams
o Class Diagram
o Object Diagram
o Use Case Diagram
o Sequence Diagram
o Activity Diagram
o Component Diagram
o Deployment Diagram

4 Database Design 26

5 User Interface 28
5.1 Input/Output Screen
5.2 Report
6 Testing 39
7 Advantages, Limitations and Proposed enhancement 41
8 Conclusion 43
9 Bibliography 44
1. INTRODUCTION
 1.1 COMPANY PROFILE

 Company Name: Internship Studio

 Address: SV Business Connect, 5th Floor, Baner Hwy Side Rd, Baner, Pune, Maharashtra 411045
 Type: Ed-Tech Company / Training & Internship provider

About Company:

Internship Studio is a rapidly growing Ed-Tech platform that provides structured internship
programs and industry-oriented training to students across India. The organization is committed to
enhancing the practical knowledge of students by offering hands-on experience through real-time
projects.
In today’s competitive world, theoretical knowledge alone is not sufficient. Internship Studio helps
students gain practical exposure, improve their technical skills, and understand real industry
workflows. The company collaborates with experienced mentors and professionals to guide students
throughout their internship journey.

Objective of Company:
The main objective of Internship Studio is to:

 Provide practical knowledge to students

 Improve technical and analytical skills
 Prepare students for real-world industry challenges
 Abstract

Netflix is one of the world’s leading online streaming platforms that provides a wide range of
movies, TV shows, and web series. This project focuses on analyzing Netflix’s dataset to understand
content trends, user preferences, and various patterns present on the platform.

The main objective of this study is to analyze different aspects of Netflix content such as the
distribution of movies and TV shows, release years, genres, duration, and country-wise availability.
Tools like Python, Pandas, and Matplotlib have been used for performing data analysis and
visualization.

In this project, Exploratory Data Analysis (EDA) techniques are applied to extract meaningful
insights from the dataset. Various visualizations are used to identify content growth over the years,
popular genres, and recent trends on the platform.

The analysis reveals that movies are more in number compared to TV shows on Netflix, and there
has been significant growth in content production in recent years. It also highlights that certain
genres and countries dominate the platform.

This project can be useful for understanding content strategies, improving recommendation
systems, and supporting business decision-making through data-driven insights. Overall, it provides a
better understanding of how an OTT platform like Netflix operates.
 Problem Definition

Netflix hosts a vast collection of movies and TV shows across different genres, countries, and time
periods. However, due to the large volume of data, it becomes difficult to manually understand
content distribution, trends, and user preferences.

There is a need to analyze the available dataset to identify meaningful patterns such as the growth
of content over the years, the dominance of certain genres, and the distribution of movies versus TV
shows. Without proper analysis, it is challenging to extract useful insights that can support decision-
making and improve content strategies.

The problem addressed in this project is to perform a detailed analysis of Netflix’s dataset using
data analysis techniques in order to uncover hidden insights, trends, and patterns. This includes
understanding content categorization, identifying popular genres, and analyzing country-wise
contributions.

By solving this problem, the project aims to provide a clear understanding of how content is
distributed on Netflix and how data-driven insights can help improve recommendations and business
strategies.
 Existing System

Netflix provides a large collection of movies and TV shows to users worldwide. However, in terms
of data understanding, the existing system mainly focuses on content streaming rather than detailed
data analysis.

Currently, users can browse and watch content, but there is limited visibility into deeper insights
such as content trends, genre popularity, and growth patterns. The platform uses internal algorithms
for recommendations, but these are not openly available for study or analysis.

From a project perspective, the existing system lacks:

 Detailed data analysis for academic purposes

 Easy access to structured insights from raw data
 Visualization of content trends and patterns
 Understanding of dataset features without technical processing

Thus, the existing system is not sufficient for extracting meaningful insights from the dataset.

Need for the System

With the rapid growth of digital content on platforms like Netflix, there is a strong need for a
system that can analyze and interpret large datasets effectively.

The need for this system arises due to the following reasons:

 To convert raw data into meaningful insights

 To understand content distribution (movies vs TV shows)
 To identify popular genres and trends
 To analyze growth of content over the years
 To support data-driven decision-making
 To improve understanding of OTT platform behavior

This system helps students and analysts to study real-world data and gain practical knowledge of data
analysis techniques.
 Scope of the System

Netflix Data Analysis System focuses on analyzing the available dataset to generate meaningful
insights about the content on the platform.

The scope of the system includes examining various attributes such as type of content (movies and
TV shows), genres, release years, duration, and country-wise distribution. The system performs
exploratory data analysis (EDA) to identify patterns, trends, and relationships within the data.

It also includes the use of data visualization techniques to represent findings through graphs and
charts, making it easier to understand content growth, popular categories, and overall distribution.

This system is designed for academic and analytical purposes only. It does not interact with
Netflix’s real-time system or user data. The analysis is limited to the dataset provided and does not
include advanced predictive models or machine learning techniques.

Overall, the system helps in understanding how data can be used to extract useful information and
support decision-making in the context of an OTT platform.
2. PROPOSED SYSTEM
 Feasibility Study

a) Technical Feasibility:

The system is technically feasible because it uses simple and widely available technologies such as Python
programming language and libraries like Pandas, NumPy, Matplotlib, and Seaborn. These tools are easy to
learn and suitable for performing data analysis tasks. The system does not require high-end hardware or
complex infrastructure.

b) Economic Feasibility:

The project is economically feasible as it does not require any major financial investment. All the tools
and technologies used are open-source and free of cost. The dataset is also freely available from platforms
like Kaggle, which makes the project cost-effective.

c) Operational Feasibility:

The system is user-friendly and can be easily operated by students or beginners who have basic
knowledge of programming. It does not require any special training, and the results are presented in a simple
and understandable format using graphs and charts.
 Fact Finding Technique

Fact-finding techniques are used to collect relevant information required for the development of the system.

 Dataset Collection:

The dataset used in this project is collected from online sources such as Kaggle. It contains information
about Netflix content like title, type, genre, release year, duration, and country.

 Literature Review:

Various research papers, articles, and previous projects related to data analysis and OTT platforms were
studied to understand concepts and methodologies.

 Observation Method:

The dataset was carefully observed to understand its structure, attributes, and possible relationships
between different variables.

 Online Research:

Information about Netflix and its working model was gathered through websites and online resources.
 Objective of the System

The main objectives of the proposed system are:

 To perform detailed analysis of the Netflix dataset

 To identify trends in content over different years

 To analyze the distribution of movies and TV shows

 To find out the most popular genres and categories

 To study country-wise content availability

 To represent data visually using charts and graphs

 To gain practical knowledge of data analysis tools and techniques

 To understand how data-driven insights help in decision-making

 User Requirements

1. Hardware Requirements

 RAM: Minimum 4 GB
 Processor: Intel i3 or higher
 Storage: Minimum 500 MB

2. Software Requirements

 Operating System: Windows 10 / 11

 Frontend: Python
 Backend: Python
 Database: CSV File
 Tools: Jupyter Notebook
3. SYSTEM ANALYSIS &
DESIGN
 1. System Analysis

System Analysis involves studying the current system, identifying problems, and defining
requirements for the proposed system.

a) Problem Analysis:

 Large amount of Netflix data is difficult to analyze manually

 No clear insights about trends and patterns
 Raw data is unstructured and complex
 Lack of visualization for better understanding

b) Requirement Analysis:

Functional Requirements:

 Load and read the dataset

 Clean and preprocess data
 Analyze content (movies, TV shows, genres, etc.)
 Generate visualizations (charts/graphs)
 Display insights and results

Non-Functional Requirements:

 System should be easy to use

 Fast processing of data
 Accurate results
 Simple and clear output (graphs, charts)

c) Data Analysis Requirements:

 Dataset attributes: title, type, genre, country, release year, duration

 Data cleaning (handling null values, duplicates)
 Data transformation for better analysis
 Visualization for interpretation
 System Design

a) System Architecture:

The system follows a simple data analysis architecture:

Input → Processing → Output

 Input: Netflix dataset (CSV file)

 Processing: Data cleaning, analysis using Python
 Output: Graphs, charts, insights

b) Module Design:

The system is divided into the following modules:

1) Data Collection Module

 Import dataset from Kaggle
2) Data Preprocessing Module
 Handle missing values
 Remove duplicates
 Format data
3) Data Analysis Module
 Analyze content distribution
 Study trends and patterns
4) Visualization Module
 Generate graphs (bar chart, pie chart, etc.)
5) Result Interpretation Module
 Display insights and conclusions
 E-R Diagram
title
descriptio
n
show_i director_i
d d

1 directe M
Show Director
d_by

1
type director
1 _name
1
release
_year

has

country_i
Belong M d
s_to Country

has_
cast

country_na
me

gener_i
d

M
1
M

gener_nam
e
Cast Gener Rating

cast_nam rating_i
e d

cast_id
rating_ty
pe
 Class Diagram

Show
- show_id
- type
1
- title Cast
- description
- release_year
+ getShowDetails() - cast_id
+ updateShow() - cast_name
+deleteShow() 1 M

+ addCast()
1 + deleteCast()

Country
1

M -country_id
-country_name

+addCountry()
+deleteCountry()

Rating Director
1

M
-rating_id - director_id
Gener -rating_type - director_name

-gener_id +addRating() +addDirector()

-gener_name +deleteRating() +getDirectorDetails()

+addGenre()
+getGenre()
 Object Diagram

Show
show_id=”s2”
type=”Movie”
title=””Blood & Water”
description=”After Cast
crossing paths at a party,
a Cape Town”
cast_id=2434
release_year=2020
cast_name=”Ama
Qamata, Khosi Ngema,
Gail Mabalane,
Thaban.”

Country

country_id=1
country_name=”South
Africa”

Rating Director

rating_id=23 director_id=1
Gener rating_type=”TV-MA” director_name=”Kirsten
Johnson”
gener_id=1
gener_name=”Action
& Adventure”
Component Diagram
4. DATABASE DESIGN
 Data Dictionary

Data Dictionary Table:

Sr. No. Field Name Data Type Description

1 Show_ID String Unique identifier for each content

2 Type String Type of content (Movie / TV Show)

3 Title String Name of the movie or TV show

4 Director String Name of the director

5 Cast String List of actors/actresses

6 Country String Country where content is produced

7 Date_Added Date Date when content was added to Netflix

8 Release_Year Integer Year of release

9 Rating String Content rating (e.g., PG, TV-MA)

10 Duration String Duration (minutes or seasons)

11 Listed_In String Genre/category of content

12 Description Text Brief summary of content

5. USER INTERFACE
5.1 INPUT OUTPUT SCREEN
 Graphs and Charts:

Fig: Count Plot of Netflix Type

Fig: Count Plot of Country

 Fig: Count Plot of Netflix Rating

Fig: Relationship between Type and Rating

Fig: Count Plot of Duration
Fig: Count Plot of Release Year

Fig: Count Plot of Type

 Output Report – Netflix Data Analysis

1. Summary of Analysis:

 Total number of records analyzed: 8807

 Total Movies: 6000
 Total TV Shows: 2600-2700
 Most common content type: Movies
 Most frequent genre: Dramas / International Movies
 Most active year for content addition: 2018

2. Content Distribution:

The analysis shows that movies are more in number compared to TV shows on the platform. The dataset
indicates a higher proportion of movies, which highlights Netflix’s focus on movie content.

3. Year-wise Growth Analysis

The number of movies and TV shows has increased significantly over the years. A rapid growth is
observed especially after 2015, indicating expansion in content production.

4. Genre Analysis:

Different genres are available on the platform, but some genres are more popular than others.

 Most popular genres: Drama, Comedy, International Movies

 Least common genres: Classic & Cult TV, TV Horror

5. Country-wise Analysis:

The dataset shows that content is produced in multiple countries.

 Top contributing countries: USA, India, UK

 Majority of content is produced in USA
6. Observations:

 Movies dominate over TV shows

 Content production is increasing every year
 Certain genres are more popular among users
 Netflix has global content distribution

7. Conclusion of Report:

The report clearly shows trends and patterns in Netflix content. It helps in understanding user
preferences, popular genres, and growth of the platform. The insights generated can be useful for
decision-making and improving content strategies.
6. TESTING
 Test Case Input Expected Output Actual Output Status
ID

TC01 Valid Netflix Dataset Dataset loaded successfully Same as Pass

expected

TC02 Missing values in dataset System handles missing Same as Pass

data expected

TC03 Duplicate data Duplicates removed Same as Pass

expected

TC04 Select Genre Analysis Genre graph displayed Same as Pass

expected

TC05 Select Year-wise Year-wise chart generated Same as Pass

Analysis expected

TC06 Invalid file format Error message displayed Same as Pass

expected

Test Cases:
✅ ADVANTAGES:

1. Fast Data Analysis:

The system allows quick analysis of large Netflix datasets.
2. Accurate Results:
Using Python libraries reduces calculation errors and improves accuracy.
3. Data Visualization:
Graphs and charts help in better understanding of data.
4. Trend Identification:
It helps to identify popular genres, release trends, and content growth.
5. User-Friendly Tools:
Tools like Jupyter Notebook are easy to use and understand.
6. Time Saving:
It reduces the time required compared to manual analysis.
7. Better Decision Making:
Insights generated help in making better content-related decisions.

❌ LIMITATIONS:

1. Dependency on Dataset:
The results depend on the quality and completeness of the dataset.

2. Limited Data Scope:

The project uses a static dataset and not real-time data.

3. Technical Knowledge Required:

Basic knowledge of Python and data analysis tools is required.

4. No Real-Time Updates:
The system does not fetch live Netflix data.

5. Data Cleaning Challenges:

Handling missing or incorrect data can be difficult.
 PROPOSED ENHANCEMENT

1. Real-Time Data Integration:

In the future, live Netflix data can be integrated using APIs.

2. Machine Learning Implementation:

Recommendation systems can be developed using machine learning.

3. Interactive Dashboard:
Tools like Power BI or Tableau can be used for better visualization.

4. Advanced Data Visualization:

More interactive and attractive charts can be added.

5. Improved User Interface:

A graphical user interface (GUI) can make it more user-friendly.

6. Handling Big Data:

Advanced tools can be used to manage large-scale datasets.
 CONCLUSION

The Netflix Data Analysis project successfully demonstrates how large datasets can be analyzed
efficiently using tools like Python programming language, Jupyter Notebook, and libraries such as
Pandas and Matplotlib.

This project helps in understanding various aspects of Netflix content, such as trends in movies and TV
shows, popular genres, and distribution over different years. The use of data visualization techniques makes
the analysis more clear and meaningful.

The system reduces manual effort and provides accurate results in a short time. It also improves decision-
making by offering valuable insights into content patterns.

Overall, this project highlights the importance of data analysis in today’s digital world and shows how it
can be applied to real-world datasets to extract useful information.
 BIBLIOGRAPHY

📚 Books:

1. Data Analysis Using Python

2. Python for Data Science Handbook
3. Introduction to Data Analytics

🌐 Websites:

1. Kaggle – Netflix Dataset

2. GeeksforGeeks – Python & Data Analysis Tutorials
3. W3Schools – Python Basics
4. Netflix – Official Platform

🛠 Tools & Technologies:

 Python programming language

 Jupyter Notebook
 Pandas
 NumPy
 Matplotlib