Hello R lovers
I have written a little cute function to count the number of missing value
per row in a matrix and return the percentage of missing value
it takes a lot of time to run with a 1000 rows matrix
I'd like to know if there is a function already implemented to count the
number of occurence of a given values in a vector
For information,
here is the function
count<-0
for (i in 1:nrow(Matrix))
{
for (j in 1:ncol(Matrix)) {if (is.na(Matrix[i,j])) count<-count+1}
Result[i,1]<-((count/(ncol(Matrix)))*100);
count<-0
}
Result
thanks for any help
Vincent
*************************************************************************
Ce message et toutes les pieces jointes (ci-apres le "message") sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration.
La SOCIETE GENERALE et ses filiales declinent toute responsabilite au
titre de ce message s'il a ete altere, deforme ou falsifie.
********
This message and any attachments (the "message") are confidentia... {{dropped}}
counting missing values
5 messages · vincent.stoliaroff@socgen.com, Uwe Ligges, Torsten Hothorn +2 more
vincent.stoliaroff at socgen.com wrote:
Hello R lovers
I have written a little cute function to count the number of missing value
per row in a matrix and return the percentage of missing value
it takes a lot of time to run with a 1000 rows matrix
I'd like to know if there is a function already implemented to count the
number of occurence of a given values in a vector
For information,
here is the function
count<-0
for (i in 1:nrow(Matrix))
{
for (j in 1:ncol(Matrix)) {if (is.na(Matrix[i,j])) count<-count+1}
Result[i,1]<-((count/(ncol(Matrix)))*100);
count<-0
}
Result
thanks for any help
Vincent
Well, it's pretty easy to do it: apply(Matrix, 1, function(x) sum(is.na(x))) / ncol(Matrix) * 100 Uwe Ligges
Hello R lovers I have written a little cute function to count the number of missing value per row in a matrix and return the percentage of missing value
R> M <- matrix(rnorm(25), ncol=5) R> diag(M) <- NA R> M[2,3] <- NA R> apply(M, 2, function(x) sum(is.na(x)))/ncol(M) [1] 0.2 0.2 0.4 0.2 0.2 the percentage of missing values per row... Torsten
it takes a lot of time to run with a 1000 rows matrix
I'd like to know if there is a function already implemented to count the
number of occurence of a given values in a vector
For information,
here is the function
count<-0
for (i in 1:nrow(Matrix))
{
for (j in 1:ncol(Matrix)) {if (is.na(Matrix[i,j])) count<-count+1}
Result[i,1]<-((count/(ncol(Matrix)))*100);
count<-0
}
Result
thanks for any help
Vincent
*************************************************************************
Ce message et toutes les pieces jointes (ci-apres le "message") sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration.
La SOCIETE GENERALE et ses filiales declinent toute responsabilite au
titre de ce message s'il a ete altere, deforme ou falsifie.
********
This message and any attachments (the "message") are confidentia... {{dropped}}
______________________________________________ R-help at stat.math.ethz.ch mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
Torsten Hothorn <Torsten.Hothorn at rzmail.uni-erlangen.de> writes:
Hello R lovers I have written a little cute function to count the number of missing value per row in a matrix and return the percentage of missing value
R> M <- matrix(rnorm(25), ncol=5) R> diag(M) <- NA R> M[2,3] <- NA R> apply(M, 2, function(x) sum(is.na(x)))/ncol(M) [1] 0.2 0.2 0.4 0.2 0.2 the percentage of missing values per row...
Or:
apply(is.na(M), 2, mean)
[1] 0.2 0.2 0.4 0.2 0.2 (Actually, that's the proportions. ...*100 for percentages)
O__ ---- Peter Dalgaard Blegdamsvej 3 c/ /'_ --- Dept. of Biostatistics 2200 Cph. N (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907
On Thu, 5 Jun 2003, Uwe Ligges wrote:
vincent.stoliaroff at socgen.com wrote:
Hello R lovers
I have written a little cute function to count the number of missing value
per row in a matrix and return the percentage of missing value
it takes a lot of time to run with a 1000 rows matrix
I'd like to know if there is a function already implemented to count the
number of occurence of a given values in a vector
For information,
here is the function
count<-0
for (i in 1:nrow(Matrix))
{
for (j in 1:ncol(Matrix)) {if (is.na(Matrix[i,j])) count<-count+1}
Result[i,1]<-((count/(ncol(Matrix)))*100);
count<-0
}
Result
thanks for any help
Vincent
Well, it's pretty easy to do it: apply(Matrix, 1, function(x) sum(is.na(x))) / ncol(Matrix) * 100
and rowMeans(is.na(Matrix))*100 should be faster -thomas