[R] cleanse columns and unwanted rows

frenchcr frenchcr at btinternet.com
Fri Nov 13 20:32:35 CET 2009



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.




More information about the R-help mailing list