Hi everyone, I want to score a set of data (-ve to +ve) using a 0-10 scale. I have the data in an R matrix, so I need to add another column, containing the scores and resave. I would be grateful for suggestions on how best to do this. Thanks, rcoder -- View this message in context: http://www.nabble.com/Mapping-data-onto-score-tp18463695p18463695.html Sent from the R help mailing list archive at Nabble.com.
On Jul 15, 2008, at 8:16 AM, rcoder wrote:> > Hi everyone, > > I want to score a set of data (-ve to +ve) using a 0-10 scale. I > have the > data in an R matrix, so I need to add another column, containing > the scores > and resave. >Hi, I am a little fuzzy on what you are asking, but my guess is that you want to normalize the data into the 0-1 range then multiply by 10. values <- rnorm(10) #some numbers mm <- range(values) #the minmax range scaled <- (values-mm[1])/(mm[2]-mm[1]) #normalize into 0-1 scaled10 <- 10 * scaled #scale 0-10 Is that what you seek? Ben
Hi Ben, Yes, this is more or less what I want to do. I want to apply this data in columns in a matrix, and insert the results to additional columns. I am not entirely aware of a good way of doing this. e.g. take data from column B, apply normalisation, and feed output into column C Thanks, rcoder Ben Tupper wrote:> > > On Jul 15, 2008, at 8:16 AM, rcoder wrote: > >> >> Hi everyone, >> >> I want to score a set of data (-ve to +ve) using a 0-10 scale. I >> have the >> data in an R matrix, so I need to add another column, containing >> the scores >> and resave. >> > > Hi, > > I am a little fuzzy on what you are asking, but my guess is that you > want to normalize the data into the 0-1 range then multiply by 10. > > values <- rnorm(10) #some numbers > mm <- range(values) #the minmax range > scaled <- (values-mm[1])/(mm[2]-mm[1]) #normalize into 0-1 > scaled10 <- 10 * scaled #scale 0-10 > > Is that what you seek? > Ben > > ______________________________________________ > R-help at 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. > >-- View this message in context: http://www.nabble.com/Mapping-data-onto-score-tp18463695p18475083.html Sent from the R help mailing list archive at Nabble.com.
On Jul 15, 2008, at 5:16 PM, rcoder wrote:> > Hi Ben, > Yes, this is more or less what I want to do. I want to apply this > data in > columns in a matrix, and insert the results to additional columns. > I am not > entirely aware of a good way of doing this. > > e.g. take data from column B, apply normalisation, and feed output > into > column C >Oh, I think you want to use cbind() to add columns to a matrix. Perhaps like this which works with the second column... v <- matrix(data = rnorm(100), nrow = 10, ncol = 10) mm <- range(v[,2]) s <- 10 * (v[,2]-mm[1])/(mm[2]-mm[1]) v2 <- cbind(v, s) Cheers, Ben> Thanks, > > rcoder > > > > Ben Tupper wrote: >> >> >> On Jul 15, 2008, at 8:16 AM, rcoder wrote: >> >>> >>> Hi everyone, >>> >>> I want to score a set of data (-ve to +ve) using a 0-10 scale. I >>> have the >>> data in an R matrix, so I need to add another column, containing >>> the scores >>> and resave. >>> >> >> Hi, >> >> I am a little fuzzy on what you are asking, but my guess is that you >> want to normalize the data into the 0-1 range then multiply by 10. >> >> values <- rnorm(10) #some numbers >> mm <- range(values) #the minmax range >> scaled <- (values-mm[1])/(mm[2]-mm[1]) #normalize into 0-1 >> scaled10 <- 10 * scaled #scale 0-10 >> >> Is that what you seek? >> Ben >> >> ______________________________________________ >> R-help at 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. >> >> > > -- > View this message in context: http://www.nabble.com/Mapping-data- > onto-score-tp18463695p18475083.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at 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.Ben Tupper PemaquidRiver at tidewater.net I GoodSearch for Ashwood Waldorf School. Raise money for your favorite charity or school just by searching the Internet with GoodSearch - www.goodsearch.com - powered by Yahoo!
Thank you Ben! This is very clear. rcoder Ben Tupper wrote:> > > On Jul 15, 2008, at 5:16 PM, rcoder wrote: > >> >> Hi Ben, >> Yes, this is more or less what I want to do. I want to apply this >> data in >> columns in a matrix, and insert the results to additional columns. >> I am not >> entirely aware of a good way of doing this. >> >> e.g. take data from column B, apply normalisation, and feed output >> into >> column C >> > > Oh, > > I think you want to use cbind() to add columns to a matrix. Perhaps > like this which works with the second column... > > v <- matrix(data = rnorm(100), nrow = 10, ncol = 10) > mm <- range(v[,2]) > s <- 10 * (v[,2]-mm[1])/(mm[2]-mm[1]) > v2 <- cbind(v, s) > > Cheers, > Ben > > > >> Thanks, >> >> rcoder >> >> >> >> Ben Tupper wrote: >>> >>> >>> On Jul 15, 2008, at 8:16 AM, rcoder wrote: >>> >>>> >>>> Hi everyone, >>>> >>>> I want to score a set of data (-ve to +ve) using a 0-10 scale. I >>>> have the >>>> data in an R matrix, so I need to add another column, containing >>>> the scores >>>> and resave. >>>> >>> >>> Hi, >>> >>> I am a little fuzzy on what you are asking, but my guess is that you >>> want to normalize the data into the 0-1 range then multiply by 10. >>> >>> values <- rnorm(10) #some numbers >>> mm <- range(values) #the minmax range >>> scaled <- (values-mm[1])/(mm[2]-mm[1]) #normalize into 0-1 >>> scaled10 <- 10 * scaled #scale 0-10 >>> >>> Is that what you seek? >>> Ben >>> >>> ______________________________________________ >>> R-help at 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. >>> >>> >> >> -- >> View this message in context: http://www.nabble.com/Mapping-data- >> onto-score-tp18463695p18475083.html >> Sent from the R help mailing list archive at Nabble.com. >> >> ______________________________________________ >> R-help at 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. > > Ben Tupper > PemaquidRiver at tidewater.net > > I GoodSearch for Ashwood Waldorf School. > > Raise money for your favorite charity or school just by searching the > Internet with GoodSearch - www.goodsearch.com - powered by Yahoo! > > ______________________________________________ > R-help at 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. > >-- View this message in context: http://www.nabble.com/Mapping-data-onto-score-tp18463695p18476293.html Sent from the R help mailing list archive at Nabble.com.