[R] NA problem in rbind of an apply summary

Raffaello Vardavas r_vardavas at hotmail.com
Wed Dec 10 22:34:47 CET 2014


Dear All,

I have a data fame. Each column has numerical values but some columns may have NA values.
I'd like a table showing the summary statistics for each column. This is what I do:

I first do the following:

apply(df[,metrics],2,summary,na.rm=T)

giving:

$degree
   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
    0.0   261.9   489.3   500.6   698.5  1551.0 

$EV.centrality
     Min.   1st Qu.    Median      Mean   3rd Qu.      Max. 
0.0000000 0.0001067 0.0006391 0.0057460 0.0020410 1.0000000 

$betweenness
   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
    0.0     0.0   150.5  2955.0  2208.0 60940.0 

$knn
   Min. 1st Qu.  Median    Mean 3rd Qu.    Max.    NA's 
   2.00   21.50   32.44   36.75   46.15  224.50      26 


Then I rbind them and get:

do.call("rbind",apply(df[,metrics],2,summary,na.rm=T))

                            Min.   1st Qu.    Median      Mean   3rd Qu.    Max. NA's
degree                         0 2.619e+02 4.893e+02 5.006e+02 6.985e+02  1551.0    0
EV.centrality                  0 1.067e-04 6.391e-04 5.746e-03 2.041e-03     1.0    0
betweenness                    0 0.000e+00 1.505e+02 2.955e+03 2.208e+03 60940.0    0
knn                            2 2.150e+01 3.244e+01 3.675e+01 4.615e+01   224.5   26

Since the first 3 rows don't have NA's but the 4th has I get the following warning:

Warning message:
In rbind(degree = c(0, 261.9, 489.3, 500.6, 698.5, 1551), EV.centrality = c(0,  :
  number of columns of result is not a multiple of vector length (arg 1)
Calls: do.call -> rbind


How do I code this in a way to avoid this warning? 

Thanks.

Raff
 		 	   		  
	[[alternative HTML version deleted]]



More information about the R-help mailing list