Activity-1

Source of Dataset -https://docs.google.com/spreadsheets/d/1jbcZm8eyaYG7QSQcVu_jU4fUdESL-YuR3YE-opJGvWQ/edit?usp=sharing

Description of rows and columns for Netflix Movies and TV Dataset 

This dataset lists titles available on Netflix, including both movies and TV shows, with useful metadata for each.

Essential Columns

• show_id
  Unique ID for each entry (e.g., s1, s2).

• type
  Indicates whether the title is a Movie or TV Show.

• title
  The name of the movie or show.

• director
  Director's name(s); may be blank.

• cast
  List of actors; can be missing.

• country
  Country of production; may list multiple.

• date_added
  When the title was added to Netflix (e.g., January 1, 2020).

• release_year
  Year the content was originally released.

• rating
  Content rating (e.g., TV-MA, PG, R).

• duration
  For movies: runtime in minutes (e.g., 90 min),
  For TV shows: number of seasons (e.g., 2 Seasons).

• listed_in
  Genre/categories like Comedies, Documentaries, etc.

• description
  Short summary of the content.

Interesting Observations About Dataset

1. More Movies than TV Shows
   There are significantly more movies than TV shows in the dataset
   This shows that Netflix has more individual films than episodic content
   
   

2. Top Countries
   The most frequent countries listed are United States India and United Kingdom
   Netflix has a strong presence in these countries in terms of content production
   
   

3. Most Frequent Directors
   Some directors like Raul Campos and Marcus Raboy appear frequently
   They often direct comedy specials and recurring series
   
   

4. Popular Content Ratings
   The most common ratings for movies are TV MA and PG 13
   For TV shows the common ratings are TV MA and TV 14
   This shows a focus on teen and adult audiences
   
   

5. Content Addition Trends
   There is a noticeable increase in content added between 2017 and 2020
   Netflix was expanding its library rapidly during this time
   
   

6. TV Show Duration
   Many TV shows have just 1 or 2 seasons
   This suggests that there are many limited series or short run shows
   
   

7. Top Genres
   The most common genres listed are Dramas Comedies Documentaries and International TV Shows
   These appear often in the listed in column
   
   

8. Missing Data
   Fields like director cast and country are often missing or blank
   This is especially common for older titles or Netflix Originals
   
   

9. Old vs New
   The earliest release year in the dataset is 1925
   However most of the content is from the year 2000 onwards
   
   

10. Global Reach
    Many titles are marked as international content
    This shows that Netflix is targeting global audiences and promoting regional productions