How to count Number Of Occurences and Use it for Line Chart in R

Question

so for example i got this dataframe

Brand	owner	Period
Adidas	andy	May 2018
Nike	diana	June 2019
Adidas	rose	August 2019
Nike	sara	July 2020
Puma	laura	March 2020
Joma	harry	April 2018
Adidas	jon	May 2018
Diadora	keith	June 2021

how do i count the number of occurences of the brand and use it as a y axis, period for x axis (yearmon num), and group by owner to make a chart line?

Welcome to SO. It is helpful if you can make your question reproducible. See stackoverflow.com/help/minimal-reproducible-example and stackoverflow.com/questions/5963269/… — Dylan_Gomes
– Dylan_Gomes, Commented Jun 30, 2021 at 21:34

ToWii · Accepted Answer · 2021-06-30 21:19:59Z

2

Unfortunately, the number of obs is too little to run it properly. But transform Period to a date format for proper display (maybe use lubridate or zoo as package). Then run the following:

library(ggplot2)

df %>%
  group_by(Brand, owner, Period) %>%
  add_count() %>%
  ungroup() %>%
  ggplot(aes(Period, n, group=owner, col=owner) +
  geom_line()

answered Jun 30, 2021 at 21:19

ToWii

6806 silver badges9 bronze badges

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

2 Comments

Hash Slasher Over a year ago

what if i want to group it by brand and use the number of occurrence as the y axis, and the period( yearmon) as the x axis?

ToWii Over a year ago

Try df %>% group_by(Brand, Period) %>% add_count() %>% ungroup() %>% ggplot(aes(Period, n)) + geom_line(). Then, of course, no grouping by owner obtains. Just one remark: Be so kind to accept my post as answer to your question, if it answers your questions. Thanks!

Collectives™ on Stack Overflow

How to count Number Of Occurences and Use it for Line Chart in R

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related