I would appreciate it if you could let me know R studio annual data extraction.

How do I separate the data by year for files that are listed in this way? How many in 2018 and how many in 2019? I'd appreciate it if you could tell me.

2023-01-31 12:02

1 Answers

There is a method using the dplyr::count function.

library(dplyr)

df = data.frame(
    date = c(20100111, 20130517, 20130408, 20210123, 20210813, 20210927, 20160425)
)

df %>% mutate(year = substr(date, 1, 4)) %>% count(year)

output

2023-01-31 16:26

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656