Message-ID: <C6B2B414-173A-4BF4-96C8-4DB73F597731@comcast.net>
Date: 2011-04-23T06:49:46Z
From: David Winsemius
Subject: How to delete an entire row, if a specific colum has the value of "#VALUE!"
In-Reply-To: <1303526150180-3469282.post@n4.nabble.com>
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