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

From: David Winsemius <>
Date: Sat, 23 Apr 2011 02:49:46 -0400

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  > <- 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

______________________________________________ mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.
Received on Sat 23 Apr 2011 - 06:51:57 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 23 Apr 2011 - 08:40:34 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive