[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