This project involves a comprehensive analysis of Netflix's movies and TV shows data using MySQL. The data contains 8807 rows and 12 columns. The goal is to extract valuable insights and answer various business questions based on the dataset. The following README provides a detailed account of the project's objectives, business problems, findings, and conclusions.
- Analyze the distribution of content types (movies vs TV shows).
- Identify the most common ratings for movies and TV shows.
- List and analyze content based on release years, countries, and durations.
- Explore and categorize content based on specific criteria and keywords.
- Count the Number of Movies vs TV Shows
- Find the Most Common Rating for Movies and TV Shows
- List All Movies Released in a Specific Year (e.g., 2020)
- Find the top 5 countries with the most content on Netflix
- Identify the Longest Movie
- Find Content Added in the Last 5 Years
- Find All Movies/TV Shows by Director 'Rajiv Chilaka'
- List All TV Shows with More Than 5 Seasons
- Count the Number of Content Items in Each Genre
- Find each year and the average numbers of content release in India on netflix.
- List All Movies that are Documentaries
- Find All Content Without a Director
- Find How Many Movies Actor 'Salman Khan' Appeared in the Last 10 Years
- Categorize Content Based on the Presence of 'Kill' and 'Violence' Keywords
- Content Distribution: The dataset contains a diverse range of movies and TV shows with varying ratings and genres.
- Common Ratings: Insights into the most common ratings provide an understanding of the content's target audience.
- Geographical Insights: The top countries and the average content releases by India highlight regional content distribution.
- Content Categorization: Categorizing content based on specific keywords helps in understanding the nature of content available on Netflix.
This analysis provides a comprehensive view of Netflix's content and can help inform content strategy and decision-making.