How to avoid repetition of categorical variables while plotting a column chart?

Question

https://www.kaggle.com/shivamb/netflix-shows-and-movies-exploratory-analysis/notebook contains the data set. (File size - 2.13 MB).

I am trying to plot the top twenty category of contents that are provided by Netflix.

The code that I have tried is as follows,

library(tidyverse)
library(lubridate)    

net_flix <- read.csv("netflix_titles_nov_2019.csv")

net_flix %>% separate_rows(listed_in, sep = ",")%>%
    count(listed_in)%>%
    slice_max(n, n = 20)%>%
    ggplot(aes(y = fct_reorder(listed_in, n), x = n))+
    geom_col()

The resultant output is as follows, [Top 20 categories of shows on Netflix]

As it can be seen from the graph that there are a lot categories like Dramas, Comedies, International TV Shows are appearing in multiple positions.

The expected output is as follows:

Can you give a hint on how the data looks like after slice_max? Or in general, how it looks like? This would help (you) a lot. — Ben
– Ben, Commented Jun 10, 2020 at 14:40

Bruno · Accepted Answer · 2020-06-10 15:01:39Z

1

welcome to SO, I think you messed up your strings with spaces, also try to follow the ggplot convention on the grammar of graphics

library(tidyverse)
library(lubridate)

net_flix <- read_csv("netflix_titles.csv")

net_flix %>%
  separate_rows(listed_in, sep = ",") %>%
  mutate(listed_in = listed_in %>% str_squish()) %>%
  count(listed_in) %>%
  top_n(20, wt = n) %>%
  ggplot(aes(x = fct_reorder(listed_in, n), y = n)) +
  geom_col() +
  coord_flip()

answered Jun 10, 2020 at 15:01

Bruno

4,1701 gold badge13 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Silent_bliss Over a year ago

Thanks. It worked. str_squish() function is something new that I learnt today.

Collectives™ on Stack Overflow

How to avoid repetition of categorical variables while plotting a column chart?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related