How to count records per year using R

Question

I have a Data frame 1 that runs from 1931 until 2020, I need to count how many records per year there are and create a table that only shows year and count. I'm trying to loop over a variable (in this case the year) but I'm just getting the table 2 with 1 row of the data of 2020.

    for(i in c("2011",
              "2012",
              "2013",
              "2014",
              "2015",
              "2016",
              "2017",
              "2018",
              "2019",
              "2020")){
  
  prueba <- prueba2 %>%
  filter(year == i) %>%
  group_by(year)%>%
  summarise(freq=n())}

You don't need the loop or `filter`. `group_by` and `summarise` will give you what you need. — Limey, Jul 16 '20 at 13:49
`prueba2 %>% group_by(year) %>% summarise(freq=n())` should work. — Duck, Jul 16 '20 at 13:49
In Base you could use `lengths(split(prueba2$year,prueba2$year))` — Daniel O, Jul 16 '20 at 14:09

score 0 · Answer 1 · answered Jul 16 '20 at 13:57

0

This will produce a count by year:

prueba %>% count(year)

answered Jul 16 '20 at 13:57

jnorman

606
8
14

Great that works, thanks! – Luna Paluna Jul 16 '20 at 14:08

How to count records per year using R

1 Answers1