CODEWITHSUNDEEP
rposixct
Ash S
Ash S

Reputation: 119

Changing datetime format in R using POSIXct-class

I have two data frames with Date/times in different formats. I wanted to make my EncounterDate in df2 match the format in df1 (eg: "1/1/21 00:00"). I don't have any times for my dates so it's okay to make all the times for my dates formatted to 00:00 (eg: "1/1/21 would be 1/1/21 00:00").

I was told to use POSIXct-class (timestamps) vectors using as.POSIXct(paste0(DateTime,"-00"), format="%m/%d/%Y %H:%M:%S"). I'm new to R. How would I go about using this with my dataframes?

df1 <- structure(list(UserID = c(1L, 2L, 3L, 4L, 5L, 6L, 7L, 1L), 
                      Full.Name = c( "John Smith", "Jack Peters", "Bob Brown", "Jane Doe", "Jackie Jane", "Sarah Brown", "Chloe Brown", "John Smith" ), 
                      Info = c("yes", "no", "yes", "yes", "yes", "yes", "no", "yes"), 
                      EncounterID = c(13L, 14L, 15L, 16L, 17L, 18L, 19L, 13L), DateTime = c("1/2/21 00:00", "1/5/21 12:00", "1/1/21 1:31", "1/5/21 3:34", "5/9/21 5:33", "5/8/21 3:39", "12/12/21 2:30", "12/11/21 9:21"), 
                      Temp = c("100", "103", "104", "103", "101", "102", "103", "105"), 
 
                      misc = c("(null)", "no", "(null)", "(null)", "(null)","(null)", "(null)", "(null)" 
                                    )), 
                 class = "data.frame", row.names = c(NA, 
                                                     -8L))

df2 <- structure(list(UserID = c(1L, 2L, 3L, 4L, 5L, 6L), 
                      Full.Name = c("John Smith", "Jack Peters", "Bob Brown", "Jane Doe", "Jackie Jane", "Sarah Brown"), 
                      DOB = c("1/1/90", "1/10/90", "1/2/90", "2/20/80", "2/2/80", "12/2/80"), 
                      EncounterID = c(13L, 14L, 15L, 16L, 17L, 18L), EncounterDate = c("1/1/21", "1/2/21", "1/1/21", "1/6/21", "5/7/21", "5/8/21"), 
                      Type = c("Intro", "Intro", "Intro", "Intro", "Care", "Out"), 
                      responses = c("(null)", "no", 
                                    "yes", "no", "no", "unsat")), 
                      
                 class = "data.frame", row.names = c(NA, 
                                                     -6L))

Upvotes: 1

Views: 70

Answers (1)

TarJae
TarJae

Reputation: 79246

Update: We could use lubridate package's mdy and as_datetimefunction:

library(dplyr)
library(lubridate)
df1 %>% 
  separate(DateTime, c("Date", "Time"), sep=" ") %>% 
  mutate(Date = as_datetime(mdy(Date))) %>% 
  select(-Time) %>% 
  as_tibble()

df2 %>% 
  mutate(across(c(DOB, EncounterDate), mdy)) %>% 
  mutate(across(c(DOB, EncounterDate), as_datetime)) %>% 
  as_tibble()

 UserID Full.Name   Info  EncounterID Date                Temp  misc  
   <int> <chr>       <chr>       <int> <dttm>              <chr> <chr> 
1      1 John Smith  yes            13 2021-01-02 00:00:00 100   (null)
2      2 Jack Peters no             14 2021-01-05 00:00:00 103   no    
3      3 Bob Brown   yes            15 2021-01-01 00:00:00 104   (null)
4      4 Jane Doe    yes            16 2021-01-05 00:00:00 103   (null)
5      5 Jackie Jane yes            17 2021-05-09 00:00:00 101   (null)
6      6 Sarah Brown yes            18 2021-05-08 00:00:00 102   (null)
7      7 Chloe Brown no             19 2021-12-12 00:00:00 103   (null)
8      1 John Smith  yes            13 2021-12-11 00:00:00 105   (null)
> 

  UserID Full.Name   DOB                 EncounterID EncounterDate       Type 
   <int> <chr>       <dttm>                    <int> <dttm>              <chr>
1      1 John Smith  1990-01-01 00:00:00          13 2021-01-01 00:00:00 Intro
2      2 Jack Peters 1990-01-10 00:00:00          14 2021-01-02 00:00:00 Intro
3      3 Bob Brown   1990-01-02 00:00:00          15 2021-01-01 00:00:00 Intro
4      4 Jane Doe    1980-02-20 00:00:00          16 2021-01-06 00:00:00 Intro
5      5 Jackie Jane 1980-02-02 00:00:00          17 2021-05-07 00:00:00 Care 
6      6 Sarah Brown 1980-12-02 00:00:00          18 2021-05-08 00:00:00 Out

Upvotes: 1

Related Questions