[R] Make a table

apjaworski@mmm.com apjaworski at mmm.com
Wed Dec 22 15:11:24 CET 2004






Muhammad,

Try

tapply(prevRND.dat$Z, list(X=prevRND.dat$X, Y=prevRND.dat$Y), mean)

Cheers,

Andy

__________________________________
Andy Jaworski
518-1-01
Process Laboratory
3M Corporate Research Laboratory
-----
E-mail: apjaworski at mmm.com
Tel:  (651) 733-6092
Fax:  (651) 736-3122


                                                                           
             Muhammad Subianto                                             
             <subianto at cs.uu.n                                             
             l>                                                         To 
             Sent by:                  r-help at stat.math.ethz.ch            
             r-help-bounces at st                                          cc 
             at.math.ethz.ch                                               
                                                                   Subject 
                                       [R] Make a table                    
             12/22/2004 07:26                                              
             AM                                                            
                                                                           
                                                                           
                                                                           
                                                                           




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

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html




More information about the R-help mailing list