converting chr (mm/dd/yyyy) to date with lubridate in r

Question

I have a column called date, chr class, format mm/dd/yyyy.

I have tried converting it to date with lubridate as follows:

df$date<- df %>% as.Date(date) 
df$date<- df %>% as_date(date)

both resulted in the Error in as.Date.default(., date): do not know how to convert '.' to class “Date”

df$date<- df %>% mdy(date)

resulted in Error in as.character(x): cannot coerce type 'closure' to vector of type 'character'

Instead of `df$date<- df %>% mdy(date)` try `df <- df %>% mutate(date = mdy(date))` — margusl, Jun 24 '23 at 13:39
https://stackoverflow.com/a/33408671/10276092 - The error means you are trying to write a dataframe into a column. Another option is to skip the pipe `df$date<-as.Date(df$date)` — M.Viking, Jun 24 '23 at 13:42
including the format with as.Date results in Error in data$date: object of type 'closure' is not subsettable — Lillian Welsh, Jun 24 '23 at 13:43
Please provide a sample of `df` paste the output of `dput(df)` into the question to make the question reproducible. — Peter, Jun 24 '23 at 13:48
@LillianWelsh, start form a clean state, i.e import your dataset again as your current `df$date` seems to be corrupt from previous attempts. — margusl, Jun 24 '23 at 13:51
df<- df %>% mutate(date= mdy(date)) results in Error in UseMethod("mutate"): no applicable method for 'mutate' applied to an object of class "function" — Lillian Welsh, Jun 24 '23 at 13:57

score 0 · Answer 1 · answered Jun 26 '23 at 02:12

0

df$date <- as.Date(df$date, "%m/%d/%Y")

should do it.

answered Jun 26 '23 at 02:12

U Bhalraam

1 Answers1