Transformation of Several Variables in a Dataframe
[This article was first published on theBioBucket*, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
This is how I transform several columns of a dataframe, i.e., with count-data into binary coded data (this would apply also for any other conversion..).Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
count1 <- count2 <- count3 <- count4 <- sample(c(rep(0, 10), 1:10)) some <- LETTERS[1:20] thing <- letters[1:20] mydf <- data.frame(count1, count2, count3, count4, some, thing) ids <- grep("count", names(mydf)) myfun <- function(x) {ifelse(x > 0, 1, 0)} mydf[, ids] <- lapply(mydf[, ids], myfun)
p.s.: Let me know if you know of a slicker way.
To leave a comment for the author, please follow the link and comment on their blog: theBioBucket*.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.