[R] Locating data source error in large file

William Dunlap wdun|@p @end|ng |rom t|bco@com
Fri Jul 20 22:59:05 CEST 2018


To find the lines in the file, tfile, with bogus dates, try
    readLines(tfile)[ is.na(dataFrame$DateTime) ]

Bill Dunlap
TIBCO Software
wdunlap tibco.com

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

> On Fri, 20 Jul 2018, David Winsemius wrote:
>
> I don't think you read Bill's message properly.
>>
>
> David,
>
>   Obviously not.
>
> He was not saying that there were NA's; he was telling you to use a format
>> specification in your as.POSIXct call and the the result of that call
>> would have NA's.
>>
>> wy2016$dt_time <- with( wy2016, as.POSIXct( paste( date, time ) , format=
>> "%Y-%m-%d %H:%M") )
>>
>
>   Thank you. This found 24 TRUEs; now to find them in the file.
>
> Thanks,
>
> 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