convert datetime to three letter month and year in R

Question

I need help to convert the first column of datetime in 3 letter month and year.

DF<-

Datetime              ID      Name
2020-01-01 10:12:14   I-1     Rnad
2020-01-01 16:32:43   I-2     Rnxa

Required output

Datetime              ID      Name   Month
2020-01-01 10:12:14   I-1     Rnad   Jan-20
2020-01-01 16:32:43   I-2     Rnxa   Jan-20

mrhellmann · Answer 1 · 2022-12-06T11:19:51.267

2

You can use the format function with strptime abbreviations.

my_df$Month <- format(my_df$Datetime, format = "%b-%y")

edited Dec 06 '22 at 11:19

answered Dec 11 '20 at 15:46

mrhellmann

5,069
11
38

My OCD, no.. Please accept at least one of the pending edits which no doubt will end your parenthesis. – Kasper Thystrup Karstensen Dec 06 '22 at 09:30

score 1 · Answer 2 · answered Dec 11 '20 at 15:46

Try this Sophia:

#Code
df$Month <- format(as.POSIXct(df$Datetime,format='%Y-%m-%d %H:%M:%S',
                              tz = 'GMT'),"%b-%y")

Output:

df
             Datetime  ID Name  Month
1 2020-01-01 10:12:14 I-1 Rnad Jan-20
2 2020-01-01 16:32:43 I-2 Rnxa Jan-20

Some data used:

#Data
df <- structure(list(Datetime = c("2020-01-01 10:12:14", "2020-01-01 16:32:43"
), ID = c("I-1", "I-2"), Name = c("Rnad", "Rnxa")), row.names = c(NA, 
-2L), class = "data.frame")

convert datetime to three letter month and year in R

2 Answers2