[R] NA problem in rbind of an apply summary
Karim Mezhoud
kmezhoud at gmail.com
Wed Dec 10 22:48:05 CET 2014
Hi,
Could you try rbind.na.R function.
karim
Ô__
c/ /'_;~~~~kmezhoud
(*) \(*) ⴽⴰⵔⵉⵎ ⵎⴻⵣⵀⵓⴷ
http://bioinformatics.tn/
On Wed, Dec 10, 2014 at 10:34 PM, Raffaello Vardavas <r_vardavas at hotmail.com
> wrote:
> 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]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
More information about the R-help
mailing list