Hi Farnoosh, Perhaps this will help: drop_dollar<-function(x) return(as.numeric(as.character(gsub("\\$","",x)))) sapply(My.Data,drop_dollar)
Jim On Thu, Apr 19, 2018 at 7:23 AM, Farnoosh Sheikhi via R-help <r-help@r-project.org> wrote: > Hello, > I have a data frame with 400 columns and wanted to filter character columns > with "$" in it.For example: > x <- c("$5", "$89", "$10", "$34") > y <- > c(1:4)> My.Data <- data.frame (x,y)> My.Data x y1 $5 12 $89 23 $10 34 > $34 4 > I want to detect the columns with $ and remove the $ from the selected > columns.I have tried apply(My.Data, 2, function (x) any(grepl("$", x))) but > it's not really working.Or: apply(My.Data, 2, function(x){x<-gsub("\\$", "", > x)}) works but it turns all the columns to a factor. > Thanks. > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.