Click the Original, Code and Reconstruction tabs to read about the issues and how they were fixed.

Original


Source: Netflix Data Visualisation,2021.


Objective

The objective of the data visualisation is to demonstrate the number of movies and tv shows that get uploaded on Netflix every month. The data visualisation also aims to draw the attention to the months December and January, as most new content is uploaded in these two months.

Targeted audience

The data visualisation is targeted to a vast audience, which includes worldwide Netflix users and also movie and tv show producers.The creator wants to help users understand, when is the best time to buy Netflix subscription to view the latest content.Also the producers of movies and tv shows can plan their release date with th help of this data visualisation.

The visualisation chosen had the following three main issues:

1. Selection of plot

The creator has used a polar area plot to demonstrate the number of new content uploaded on Netflix every month. Polar area plot uses area to compare different months, which is not precise and has a wide scope of misinterpretation. It is difficult to compare areas which makes it harder to visualise the differences in every month.

2. Labeling of plot

The data visualisation is missing the labels for each month. This doesn’t give a clear picture of the data, and might lead to misinterpretation. It becomes hard to find the exact difference between different months.An appropriate title is also missing from the data visualisation.

3. Comparing total content(movies + tv shows)

Total number of new content is plotted on the chart which includes number of movies and tv shows. The data visualisation does not separate the type of the content, this again doesn’t give a clear picture of the data to the audience. A user who is more interested in tv shows would want to know when are the highest number of tv shows released. Similarly, content producers would also want to compare this data for movies and tv shows separately.

Reference

Code

The following code was used to fix the issues identified in the original.

library(ggplot2)
library(readr)
library(dplyr)
library(tidyr)

# Read the data
netflix_data <- read_csv("~/Documents/Data Visualisation/Assignment 2/netflix_titles.csv")

# Change date_added to date format
netflix_data$date_added <- as.Date(netflix_data$date_added, format="%B %d, %y")

# Create a new Month_added variable 
netflix_data$Month_added <- format(netflix_data$date_added, format="%B")

# Filter the data 
netflix_sub_data <- select(netflix_data,show_id, type,Month_added)

# Data Preprocessing to get count variable
netflix_sub_data <- netflix_sub_data %>% group_by(Month_added, type) %>% summarise(count = n())

# Data Preprocessing to define the factors
netflix_sub_data$Month_added <- factor(netflix_sub_data$Month_added , levels = c("January","February","March","April","May","June","July","August","September","October","November","December"), ordered = TRUE)
netflix_sub_data$type <- as.factor(netflix_sub_data$type)

# Data Preprocessing to remove the NAs
netflix_sub_data <- netflix_sub_data %>% drop_na()


# Plot the bar graph
p1 <- ggplot(data = netflix_sub_data, aes(y=Month_added,x=count))
p1 <- p1 + geom_bar( stat= "identity",position = position_dodge(width = 0.2))  + theme_minimal() + labs(title = "Number of Movies and TV shows released in each month", y =  "Months", x = "Number of movies and tv shows") + theme(plot.title = element_text(hjust = 0.5)) + scale_x_continuous(limits = c(0,600)) 

# Highlight December and January
p1 <- p1 + geom_bar(data=subset(netflix_sub_data, Month_added=="December"), aes(count, Month_added), fill="red", stat="identity") + geom_bar(data=subset(netflix_sub_data, Month_added=="January"), aes(count, Month_added), fill="red", stat="identity")

# Add count as text
p1 <- p1 + geom_text(aes(label = count, group =1), hjust = 2, position = position_dodge(0.001), colour="white")

# Add Facet with respect to type
p1 <- p1+ facet_grid(~ type) + theme(panel.spacing.x = unit(2, "lines"))

Data Reference

Reconstruction

The following plot fixes the main issues in the original.