Hi, I'm working on producing a simple cumulative frequency distribution. Thanks to the help of the good people on this list I now have four vectors that I'd like to join/relate into a table. e.g. v1 <- myHistogram$breaks # classes v2 <- myHistogram$counts # freqs v3 <- cumsum(v2) # cumulative freq v4 <- ((v3 / length(myData)) * 100) # cumulative % What is the recommend approach to turning these into a single table with four columns? ie effectively doing a relational join on row id? The goal is to ultimately have the data with one row per class in a format I can write out to a text file as: v1 v2 v3 v4 v1 v2 v3 v4 etc... Any advice will be appreciated. Regards Michael. ____________________________________________________ Coming soon: Celebrity Survivor - 11 celebrities, 25 days, unlimited drama
On 8/13/06, Michael Zatorsky <miczat at yahoo.com> wrote:> I'm working on producing a simple cumulative frequency > distribution. > > Thanks to the help of the good people on this list I > now have four vectors that I'd like to join/relate > into a table. e.g. > > > v1 <- myHistogram$breaks # classes > v2 <- myHistogram$counts # freqs > v3 <- cumsum(v2) # cumulative freq > v4 <- ((v3 / length(myData)) * 100) # cumulative % > > > What is the recommend approach to turning these into a > single table with four columns? ie effectively doing > a relational join on row id? > > The goal is to ultimately have the data with one row > per class in a format I can write out to a text file > as: > > v1 v2 v3 v4 > v1 v2 v3 v4 > etc... > > Any advice will be appreciated.An example follows:> V1 <- 1:4 > V2 <- 3:6 > V3 <- 2:5 > m <- matrix(nrow=4,ncol=3) > m[,1] [,2] [,3] [1,] NA NA NA [2,] NA NA NA [3,] NA NA NA [4,] NA NA NA> m[,1] <- V1 > m[,2] <- V2 > m[,3] <- V3 > m[,1] [,2] [,3] [1,] 1 3 2 [2,] 2 4 3 [3,] 3 5 4 [4,] 4 6 5>Paul
At 13:23 13/08/2006, Michael Zatorsky wrote:>Hi, > >I'm working on producing a simple cumulative frequency >distribution. > >Thanks to the help of the good people on this list I >now have four vectors that I'd like to join/relate >into a table. e.g. > > >v1 <- myHistogram$breaks # classes >v2 <- myHistogram$counts # freqs >v3 <- cumsum(v2) # cumulative freq >v4 <- ((v3 / length(myData)) * 100) # cumulative %data.frame(v1 = myHistogram$breaks, v2 = myHistogram$counts, and so on ...)>What is the recommend approach to turning these into a >single table with four columns? ie effectively doing >a relational join on row id? > >The goal is to ultimately have the data with one row >per class in a format I can write out to a text file >as: > > v1 v2 v3 v4 > v1 v2 v3 v4 > etc... > >Any advice will be appreciated. > >Regards >Michael. > > > > > >____________________________________________________ > >Coming soon: Celebrity Survivor - 11 celebrities, 25 days, unlimited dramaMichael Dewey med at aghmed.fsnet.co.uk http://www.aghmed.fsnet.co.uk/home.html