stratascratch
  • Interview Questions
    • Interview Loops
    • Analytical
    • Algorithm
    • ML Coding
    • Stats Coding
    • Visualization
    • Concept
  • Data Labs
    • Discover
    • Your Notebooks
  • Mock Interview
  • Learn
  • Blog
  • Pricing
  • About
Log in
  • Interview Questions

    • Interview Loops
    • Analytical
    • Algorithm
    • ML Coding
    • Stats Coding
    • Visualization
    • Concept
  • Data Labs

    • Discover
    • Your Notebooks
  • Mock Interview
  • Learn
  • Blog
  • Pricing
  • About
Log inSign up
Back to Projects
  1. Assignment
  2. Your Solution
  3. Solution
  4. Solutions from Users
  5. Discussion

New Shows and Movies

You must be logged in to download the datasets

Netflix: Inform production decisions through genre trends and actor frequency analysis. Python, Pandas, Matplotlib, Seaborn.

Assignment

Analyze the data and generate insights that could help Netflix in deciding which type of shows/movies to produce and how they can grow the business in different countries.

You can start by exploring a few questions:

  1. What type of content is available in different countries?
  2. How has the number of movies released per year changed over the last 20-30 years?
  3. Comparison of tv shows vs. movies.
  4. What is the best time to launch a TV show?
  5. Analysis of actors/directors of different types of shows/movies.
  6. Does Netflix has more focus on TV Shows than movies in recent years?
  7. Understanding what content is available in different countries.

Data Description

The dataset provided to you in netflix_data.csv consists of a list of all the TV shows/movies available on Netflix.

  • show_id - a unique ID for every movie/show
  • type - identifier: a movie or TV show
  • title - the title of the movie/show
  • director - the name of the director of the movie/show
  • cast - actors involved in the movie/show
  • country - a country where the movie/show was produced
  • date_added - date it was added on Netflix
  • release_year - the actual release year of the movie/show
  • rating - TV rating of the movie/show
  • duration - total duration in minutes or number of seasons
  • listed_in - genre
  • description - the summary description

Practicalities

The exploration should have a goal. As you explore the data, keep in mind that you want to answer which type of shows to produce and how to grow the business. Ensure each recommendation is backed by data. The company is looking for data-driven insights, not personal opinions or anecdotes. Assume that you are presenting your findings to business executives who have only a basic understanding of data science. Avoid unnecessary technical jargon.

This question is part of an interview loop

See the full interview round by round, with questions for each stage.

Social, media & entertainment · Analytics Engineer