Hi Rainer, Thanks for notifying me. You are right. Sorry, I was working with library(reshape) instead of reshape2. So, I guess the cast() will not work if we load only reshape2. A.K.
----- Original Message ----- From: Rainer Schuermann <rainer.schuerm...@gmx.net> To: arun <smartpink...@yahoo.com> Cc: Sent: Thursday, October 18, 2012 1:33 PM Subject: Re: [R] Help with I think you need to use dat2<-dcast(dat1,V1~V2) ^ At least on my machine, cast wouldn't do it. Rgds, Rainer > sessionInfo() > R version 2.15.1 (2012-06-22) Platform: x86_64-pc-linux-gnu (64-bit) locale: [1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C [3] LC_TIME=en_US.UTF-8 LC_COLLATE=en_US.UTF-8 [5] LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8 [7] LC_PAPER=C LC_NAME=C [9] LC_ADDRESS=C LC_TELEPHONE=C [11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] reshape2_1.2.1 loaded via a namespace (and not attached): [1] plyr_1.7.1 stringr_0.6.1 tools_2.15.1 > On Thursday 18 October 2012 09:37:20 arun wrote: > Hi, > You can also try this: > dat1<-read.table(text=" > 1 1 3 > 1 2 54 > 1 3 11 > 1 4 17 > 2 1 5 > 2 4 78 > 2 5 20 > ",sep="",header=FALSE) > library(reshape2) > dat2<-cast(dat1,V1~V2) > dat2<-dat2[,-1] > dat2[is.na(dat2)]<-0 > dat3<-as.matrix(dat2) > dat3 > # [,1] [,2] [,3] [,4] [,5] > #[1,] 3 54 11 17 0 > #[2,] 5 0 0 78 20 > A.K. > > > > > ----- Original Message ----- > From: Rui Esteves <ruimax...@gmail.com> > To: r-help@r-project.org > Cc: > Sent: Thursday, October 18, 2012 8:44 AM > Subject: [R] Help with > > Hi, > > I downloaded a dataset from UCI repositories named Bag of Words: > http://archive.ics.uci.edu/ml/machine-learning-databases/bag-of-words/readme.txt > > > The dataset is in a text file with the following structure: > --- > > docID1 wordID1 count > docID1 wordID2 count > docID1 wordID3 count > docID1 wordID4 count > ... > docID2 wordID2 count > docID2 wordID5 count > docID2 wordID6 count > --- > > Where docIDx is an integer that identifies the document x; wordIDy is > an integer that identifies the word y ; and count is an integer with > the number of times that the wordIDy appears in the docIDx. > > > Example: > > --- > > 1 1 3 > 1 2 54 > 1 3 11 > 1 4 17 > 2 1 5 > 2 4 78 > 2 5 20 > --- > > I would like to import the file into a matrix (not sparse) where: > > the wordIDy would correspond to the column [,y] > > the docIDx would correspond to the row [x,] > > the value in [x,y] would be the count of wordIDy in the docIDx > > So, for the previous example it would be like: > > > [,1][,2][,3][,4][,5] > > [1,] 3 54 11 17 0 > > [2,] 5 0 0 78 20 > > > I don1t have a clue about how to do this. > > Can someone please help me? > > Thank you > > Rui > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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. > > > ______________________________________________ > R-help@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. ______________________________________________ R-help@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.
