Lubridate find invalid dates

[ply]

When I run this command to check if the date columns are in the correct yyyy-mm-dd format

df1 <- df %>% mutate(date_created = lubridate::ymd(df$date_created) )

I get the following message 2117 failed to parse- which is great ( there are over 200,000 rows ) as some will be wrong BUT how do I know which ones have failed ?

cheers

[nirgrahamuk]

@ply

date_created

if they failed to parse, then they will appear as NA at those locations in the date_created field you made.
p.s. when using the tidyverse you should avoid using $ selection unless you cannot achieve some effect without it, in your example if seems redundant at best, given that mutate knows it operates on df from the first pipe you make.

[ply]

Thanks. but how do I then ink the original dataframe and show what the dates entered were
cheers

[nirgrahamuk]

you can preserve your original data, by not overwriting it. perhaps

df1 <- df %>% mutate(date_created_parsed =  lubridate::ymd(date_created))

Then you will have in df1 both parsed and the original date created fields