## Hello there, ## I have an issue where I need to use the value of column names to multiply with the individual values in a column and I have many columns to do this over. I have data like this where the column names are numbers:
mydf <- data.frame(`2.72`=runif(20, 0, 125), `3.2`=runif(20, 50, 75), `3.78`=runif(20, 0, 100), yy= head(letters,2), check.names=FALSE) ## I had been doing something like this but this seems rather tedious and clunky. These append the correct values to my dataframe but is there any way that I can do this generally over each column, also using each column name as the multiplier for that column? mydf$vd2.72 <- mydf$'2.72'*2.72 mydf$vd3.2 <- mydf$'3.2'*3.2 mydf$vd3.78 <- mydf$'3.78'*3.78 ## So can I get to this point with a more generalized solution? For now, I would also prefer to keep this in wide format and I am aware (thanks to the list!) that I could use melt() to get the values I want. mydf ## Thanks so much in advance! Sam ______________________________________________ R-help@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.