[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