[R] How to delete an entire row, if a specific colum has the value of "#VALUE!"

David Winsemius dwinsemius at comcast.net
Sat Apr 23 08:49:46 CEST 2011

On Apr 22, 2011, at 10:35 PM, empyrean wrote:

> I am importing CSV data with thousands of rows, if any row contains  
> an error
> from excel, the whole program crashes, so i need to delete all rows  
> with the
> value of #VALUE!, all other values are non-numeric...
> I've tried a bunch of strategies, but nothing seems to work.

A set of error targets:
 > lines <- textConnection("a,#NAME?,b
+ #DIV/0!,b,v
+ #VALUE!,bb,nn")
 > dat <- read.table(lines, sep="," , header=FALSE, comment="")
 > dat
        V1     V2 V3
1       a #NAME?  b
2 #DIV/0!      b  v
3 #VALUE!     bb nn

# This will turn all the #VALUE!'s into <NA>'s
 > is.na(dat) <- dat == "#VALUE!"
 > dat
        V1     V2 V3
1       a #NAME?  b
2 #DIV/0!      b  v
3    <NA>     bb nn


David Winsemius, MD
West Hartford, CT

More information about the R-help mailing list