[R] cleanse columns and unwanted rows

[rmailbox at justemail.net]

?subset


----- Original message -----
From: "frenchcr" <frenchcr at btinternet.com>
To: r-help at r-project.org
Date: Fri, 13 Nov 2009 11:32:35 -0800 (PST)
Subject: [R]  cleanse columns and unwanted rows



hello folks,

Im trying to clean out a large file with data i dont need.
The column im manipulating in the file is called "legal status"
Their are three kinds of rows i want to remove.
Those that have "Private", "Private (Op", or "Unknown" in the legal_status
column.


I wrote this code but it syas im missing a TRUE/ False thingy...im
lost...heres the code...



cleanse <- function(a){
data1<-a

  for (i in 1:dim(data1)[1])
  {
    if (data1[i,"legal_status"] == "Private")
    {
    data1[i,"legal_status"]<-data1[-i,"legal_status"]
    }
    if (data1[i,"legal_status"] == "Private (Op"){
    data1[i,"legal_status"]<-data1[-i,"legal_status"]
    }
    if (data1[i,"legal_status"] == "Unknown"){
    data1[i,"legal_status"]<-data1[-i,"legal_status"]
    }
 }

 return(data1)
}
new_data<-cleanse(data)




Any ideas?
-- 
View this message in context: http://old.nabble.com/cleanse-columns-and-unwanted-rows-tp26342169p26342169.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.