[R] Locating data source error in large file

Rich Shepard r@hep@rd @ending from @ppl-eco@y@@com
Fri Jul 20 19:43:55 CEST 2018


   The structure of the dataframe is

str(wy2016)
'data.frame':	8784 obs. of  4 variables:
  $ date  : chr  "2015-10-01" "2015-10-01" "2015-10-01" "2015-10-01" ...
  $ time  : chr  "00:00" "01:00" "02:00" "03:00" ...
  $ elev  : num  90.7 90.7 90.7 90.7 90.7 ...
  $ myDate: Date, format: "2015-10-01" "2015-10-01" ...

   The command and results on this dataframe is:
wy2016$myTime <- as.POSIXct(paste(wy2016$date, wy2016$time))
Error in as.POSIXlt.character(x, tz, ...) :
   character string is not in a standard unambiguous format

   Data for other water years do not throw this error. How can I identify
which row(s) among the 8784 have a date or time formatting error?

Rich



More information about the R-help mailing list