[R] Mixed format

Val v@|kremk @end|ng |rom gm@||@com
Mon Jan 20 23:58:39 CET 2020


Hi All,

I have a data frame where one column is  a mixed date format,
a date in the form "%m-%d-%y"  and "%m/%d/%Y", also some are not in date format.

Is there a way to delete the rows that contain non-dates  and
standardize the dates in one date format like  %m-%d-%Y?
Please see my  sample data and desired output

DFX<-read.table(text="name ddate
  A  19-10-02
  B  22-11-20
  C  19-01-15
  D  11/19/2006
  F  9/9/2011
  G  12/29/2010
  H  DEX",header=TRUE)

Desired output
name ddate
A  19-10-2002
B  22-11-2020
C  19-01-2015
D  11-19-2006
F  09-09-2011
G  12-29-2010

Thank you



More information about the R-help mailing list