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.schuermann at gmx.net> To: arun <smartpink111 at 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 <ruimaximo at gmail.com> To: r-help at 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 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. ______________________________________________ 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.