try: tapply( Z, list( X, Y ), mean )
---------------------- Bendix Carstensen Senior Statistician Steno Diabetes Center Niels Steensens Vej 2 DK-2820 Gentofte Denmark tel: +45 44 43 87 38 mob: +45 30 75 87 38 fax: +45 44 43 07 06 [EMAIL PROTECTED] www.biostat.ku.dk/~bxc ---------------------- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Muhammad Subianto > Sent: Wednesday, December 22, 2004 2:26 PM > To: [EMAIL PROTECTED] > Subject: [R] Make a table > > > Dear useR, > > I have a dataset like this below, > > prevRND.dat <- read.table("C:\\workdir\\prevRND.txt", > + header=FALSE, # No header. > + col.names = c("X","Y","Z"), > + sep = ",") > > prevRND.dat > X Y Z > 1 A A 0.950933 > 2 A B 0.143600 > 3 A C 0.956133 > 4 B A 0.000533 > 5 B B 0.986467 > 6 B C 0.032066 > 7 C A 0.005333 > 8 C B 0.000000 > 9 C C 0.009266 > > How can I make that data above as table, > > Y > X A B C > A 0.950933 0.143600 0.956133 > B 0.000533 0.986467 0.032066 > C 0.005333 0.000000 0.009266 > > I cannot use table() or ftable() functions because the 3rd > column (Z) is > probability. Are there any function to make a table as I want? > > Kind regards, > Muhammad Subianto > > ______________________________________________ > [EMAIL PROTECTED] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read > the posting guide! http://www.R-project.org/posting-guide.html > ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html