[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