[R] Locating data source error in large file

Eric Berger er|cjberger @end|ng |rom gm@||@com
Fri Jul 20 21:18:48 CEST 2018

Hi Rich,
This may not be the most efficient but it will identify the offenders.

>  foo <-  paste(wy2016$date, wy2016$time))
> uu <- sapply(1:length(foo),
             function(i) { a <- try(as.POSIXct(foo[i]),silent=TRUE)
             "POSIXct" %in% class(a) })
> which(!uu)


On Fri, Jul 20, 2018 at 9:58 PM, Rich Shepard <rshepard using appl-ecosys.com>

> On Fri, 20 Jul 2018, William Dunlap wrote:
> The problem occurs because no commonly used format works on all your date
>> strings. If you give as.POSIXlt the format you want to use then items that
>> don't match the format will be treated as NA's. Use is.na() to find them.
> Bill,
>   No NAs found using both is.na() and scrolling through the source file.
> That's why I asked for help: I saw nothing different in the dates or times.
> Regards,
> Rich
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posti
> ng-guide.html
> and provide commented, minimal, self-contained, reproducible code.

	[[alternative HTML version deleted]]

More information about the R-help mailing list