Hi,
Here i have a matrix like this,
OLDMatrix <-
X1 X2 X3
----- ------ ------
22 24 23
25 27 27
10 13 15
the thing is,
im running two function(SUM,COUNT) to get output in another matrix called
NEWMatrix
NEWMatrix <- c("SUM",colSums(OLDMatrix ))
NEWMatrix <- c("COUNT",colSums(!is.na(OLDMatrix )))
Actually i need to get output like this,
NEWMatrix <-
SUM 57 64 65
COUNT 3 3 3
Instead of getting out put like above, new row getting replaced by new row
of vales.
and after executing the function i getting the values with header. How can i
insert row
of vales into NewMatrix without header. ?
Can anyone please help me ?
Thanks & Regards,
-Antony
--
View this message in context: http://r.789695.n4.nabble.com/Add-row-into-a-Matrix-witout-headers-from-Function-tp4636256.html
Sent from the R help mailing list archive at Nabble.com.
Add row into a Matrix witout headers from Function
5 messages · Jean V Adams, Rantony, arun
Hello,
The reason you are only getting one row is because each time you are replacing the NEWMatrix with new output.
Try this:
Oldmatrix<-read.table(text="
?X1??????? X2??????? X3
?22????????? 24??????? 23
?25????????? 27??????? 27
?10????????? 13??????? 15
?",sep="",header=TRUE)
NewMatrix1<-rbind( c("SUM",colSums(Oldmatrix )),c("COUNT",colSums(!is.na(Oldmatrix))))
NewMatrix1
???????????? X1?? X2?? X3? [1,] "SUM"?? "57" "64" "65" [2,] "COUNT" "3"? "3"? "3"
NewMatrix1<-data.frame(NewMatrix1)
A.K.
----- Original Message -----
From: Rantony <antony.akkara at ge.com>
To: r-help at r-project.org
Cc:
Sent: Thursday, July 12, 2012 1:22 AM
Subject: [R] Add row into a Matrix witout headers from Function
Hi,
Here i have a matrix like this,
OLDMatrix <-
X1? ? ? ? X2? ? ? ? X3
-----? ? ? ------? ? ------
22? ? ? ? ? 24? ? ? ? 23
25? ? ? ? ? 27? ? ? ? 27
10? ? ? ? ? 13? ? ? ? 15
the thing is,
im running two function(SUM,COUNT) to get output in another matrix called
NEWMatrix
NEWMatrix <- c("SUM",colSums(OLDMatrix ))
NEWMatrix? <- c("COUNT",colSums(!is.na(OLDMatrix )))
Actually i need to get output like this,
NEWMatrix <-
SUM? ? ? 57? ? ? 64? ? ? ? 65
COUNT? 3? ? ? ? 3? ? ? ? ? 3
Instead of getting out put like above, new row getting replaced by new row
of vales.
and after executing the function i getting the values with header. How can i
insert row
of vales into NewMatrix without header. ?
Can anyone please help me ?
Thanks & Regards,
-Antony
--
View this message in context: http://r.789695.n4.nabble.com/Add-row-into-a-Matrix-witout-headers-from-Function-tp4636256.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help at r-project.org mailing list
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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120712/fa2970ac/attachment.pl>
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120712/d22803c4/attachment.pl>
Hi Jean,
If we convert the NEWMatrix to dataframe,then headers do appear.
NewMatrix1<-data.frame(NewMatrix)
?NewMatrix1
???????????? X1 X2 X3 X4
SumMatrix?? SUM 57 64 65
CountMat? COUNT? 3? 3? 3
#assigning headers to NULL
?colnames(NewMatrix1)<-NULL
?NewMatrix1
???????????? NA NA NA NA
SumMatrix?? SUM 57 64 65
CountMat? COUNT? 3? 3? 3
names(NewMatrix1)
NULL
I guess then it will be better to store as matrix.
A.K.
----- Original Message -----
From: Jean V Adams <jvadams at usgs.gov>
To: Rantony <antony.akkara at ge.com>
Cc: r-help at r-project.org
Sent: Thursday, July 12, 2012 8:42 AM
Subject: Re: [R] Add row into a Matrix witout headers from Function
Try using the rbind() function to combine the two vectors from colSums()
into a matrix.? Then assign row names and get rid of column names using
the dimnames() function.? For example:
OLDMatrix <- matrix(c(22, 25, 10, 24, 27, 13, 23, 27, 15),
? ? ? ? ncol=3, dimnames = list(NULL, c("X1", "X2", "X3")))
NEWMatrix <- rbind(colSums(OLDMatrix ), colSums(!is.na(OLDMatrix )))
dimnames(NEWMatrix) <- list(c("SUM", "COUNT"), NULL)
OLDMatrix
? ? X1 X2 X3
[1,] 22 24 23
[2,] 25 27 27
[3,] 10 13 15
NEWMatrix
? ? ? [,1] [,2] [,3]
SUM? ? 57? 64? 65
COUNT? ? 3? ? 3? ? 3
Jean
Rantony <antony.akkara at ge.com> wrote on 07/12/2012 12:22:53 AM:
Hi, Here i have a matrix like this, OLDMatrix <- X1? ? ? ? X2? ? ? ? X3 -----? ? ? ------? ? ------ 22? ? ? ? ? 24? ? ? ? 23 25? ? ? ? ? 27? ? ? ? 27 10? ? ? ? ? 13? ? ? ? 15 the thing is, im running two function(SUM,COUNT) to get output in another matrix
called
NEWMatrix
NEWMatrix <- c("SUM",colSums(OLDMatrix ))
NEWMatrix? <- c("COUNT",colSums(!is.na(OLDMatrix )))
Actually i need to get output like this,
NEWMatrix <-
SUM? ? ? 57? ? ? 64? ? ? ? 65
COUNT? 3? ? ? ? 3? ? ? ? ? 3
Instead of getting out put like above, new row getting replaced by new
row
of vales. and after executing the function i getting the values with header. How
can i
insert row of vales into NewMatrix without header. ? Can anyone please help me ? Thanks & Regards, -Antony
??? [[alternative HTML version deleted]] ______________________________________________ R-help at r-project.org mailing list 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.