Dear R users,
I have a matrix like
A X 1
B Y 2
C Z 3
I want to reshape this matrix into this format
X Y Z
A 1
B 2
C 3
Thanks in advance for your help.
Dinesh
--
Dinesh Kumar Barupal
Junior Specialist
Metabolomics Fiehn Lab
UCD Genome Center
451 East Health Science Drive
GBSF Builidng
University of California
DAVIS
95616
http://fiehnlab.ucdavis.edu/staff/kumar
[[alternative HTML version deleted]]
On Thu, Nov 6, 2008 at 8:53 AM, dinesh kumar <barupal at gmail.com> wrote:> Dear R users, > > I have a matrix like > > A X 1 > B Y 2 > C Z 3 > > I want to reshape this matrix into this format > > X Y Z > A 1 > B 2 > C 3 >is this what you want?> matrix(diag(c(1,2,3)),nrow=3,ncol=3,dimnames=list(c("A","B","C"),c("X","Y","Z")))X Y Z A 1 0 0 B 0 2 0 C 0 0 3
Dear Dinesh, Have a look at ?cast for the reshape package> dataset <- data.frame(Col1 = LETTERS[1:3], Col2 sort(rev(LETTERS)[1:3]), value = 1:3) > datasetCol1 Col2 value 1 A X 1 2 B Y 2 3 C Z 3> library(reshape) > cast(Col1 ~ Col2, data = dataset, fill = 0)Col1 X Y Z 1 A 1 0 0 2 B 0 2 0 3 C 0 0 3 HTH, Thierry ------------------------------------------------------------------------ ---- ir. Thierry Onkelinx Instituut voor natuur- en bosonderzoek / Research Institute for Nature and Forest Cel biometrie, methodologie en kwaliteitszorg / Section biometrics, methodology and quality assurance Gaverstraat 4 9500 Geraardsbergen Belgium tel. + 32 54/436 185 Thierry.Onkelinx op inbo.be www.inbo.be To call in the statistician after the experiment is done may be no more than asking him to perform a post-mortem examination: he may be able to say what the experiment died of. ~ Sir Ronald Aylmer Fisher The plural of anecdote is not data. ~ Roger Brinner The combination of some data and an aching desire for an answer does not ensure that a reasonable answer can be extracted from a given body of data. ~ John Tukey -----Oorspronkelijk bericht----- Van: r-help-bounces op r-project.org [mailto:r-help-bounces op r-project.org] Namens dinesh kumar Verzonden: donderdag 6 november 2008 1:53 Aan: r-help op r-project.org Onderwerp: [R] Reshape a matrix Dear R users, I have a matrix like A X 1 B Y 2 C Z 3 I want to reshape this matrix into this format X Y Z A 1 B 2 C 3 Thanks in advance for your help. Dinesh -- Dinesh Kumar Barupal Junior Specialist Metabolomics Fiehn Lab UCD Genome Center 451 East Health Science Drive GBSF Builidng University of California DAVIS 95616 http://fiehnlab.ucdavis.edu/staff/kumar [[alternative HTML version deleted]] ______________________________________________ R-help op 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. Dit bericht en eventuele bijlagen geven enkel de visie van de schrijver weer en binden het INBO onder geen enkel beding, zolang dit bericht niet bevestigd is door een geldig ondertekend document. The views expressed in this message and any annex are purely those of the writer and may not be regarded as stating an official position of INBO, as long as the message is not confirmed by a duly signed document.
Assuming you mean data frame and not matrix and depending on whether the empty spaces are intended to represent NA or 0 we have:> DF <- data.frame(V1 = LETTERS[1:3], V2 = LETTERS[24:26], V3 = 1:3) > tapply(DF[[3]], DF[1:2], c)V2 V1 X Y Z A 1 NA NA B NA 2 NA C NA NA 3> xtabs(V3 ~ V1 + V2, DF)V2 V1 X Y Z A 1 0 0 B 0 2 0 C 0 0 3 On Wed, Nov 5, 2008 at 7:53 PM, dinesh kumar <barupal at gmail.com> wrote:> Dear R users, > > I have a matrix like > > A X 1 > B Y 2 > C Z 3 > > I want to reshape this matrix into this format > > X Y Z > A 1 > B 2 > C 3 > > > > Thanks in advance for your help. > > > Dinesh > > -- > Dinesh Kumar Barupal > Junior Specialist > Metabolomics Fiehn Lab > UCD Genome Center > 451 East Health Science Drive > GBSF Builidng > University of California > DAVIS > 95616 > http://fiehnlab.ucdavis.edu/staff/kumar > > [[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. >