Extracting year from column with date and time in dataframe

Asked Jun 09 '23 at 19:33

Active Jun 09 '23 at 19:33

Viewed 28 times

I have some dataframes that have date and time in the format of YYYY-MM-DDTHH:MM:SS so year, month, date a random T for time, and then hours, minutes seconds. Here is another example with actual numbers: 2022-09-17T13:49:52

Ulitimately, I would only like to include data from the years 1993 to present (30 years) and this data frame has data from the 1800s. It will be easy to filter for after with dplyr but my main issue is getting the date column into a format where I can just consider the year for the filter function.

Than you so much!

asked Jun 09 '23 at 19:33

Melissa Duda

1

Try this: `as.integer(format(as.Date("2022-09-17T13:49:52"), "%Y"))` – Dave2e Jun 09 '23 at 19:40
1

Use `year` function from `lubridate` or more fun `parse_number()` from `readr`. – TarJae Jun 09 '23 at 19:41

Extracting year from column with date and time in dataframe

0 Answers0