Hi,
New to R. Need a bit of help. Thanks I am trying to import data from Excel file. The package I am trying to use requires data in Matrix format. Excel -> R Matrix with the constraint that the very first column in Excel file should became the names for rows of the matrix. Example. Data has 1000 rows and 11 columns. 1st column is the names of Genes 10 coulmns of numerical data. I need to read this into R. it should be a 1000 (row) X 10 Column (Matrix) 1st column of Excel file becomes name of the rows. I am experimenting with reading as data frame (as I am unable to find any info on reading into matrix) split the data frame, etc. Thanks truly appreciate your help. What I need: |
Hello,
Try this: You can use the read.table with sep="," if it is comma separated to read the file. test1<-read.table(text=" 0.141 0.242 0.342 0.224 0.342 0.334 0.652 0.682 0.182 ",sep="",header=FALSE) #Read data test1 # V1 V2 V3 #1 0.141 0.242 0.342 #2 0.224 0.342 0.334 #3 0.652 0.682 0.182 #Convert to matrix as it is that you wanted test2<-as.matrix(test1) colnames(test2)<-NULL genelist<-c("Fkh2","Swi5","Sic1") rownames(test2)<-genelist test2 # [,1] [,2] [,3] #Fkh2 0.141 0.242 0.342 #Swi5 0.224 0.342 0.334 #Sic1 0.652 0.682 0.182 #2nd case: As in your example, test1<-read.table(text=" IMAGE:152 0.141 0.242 0.342 IMAGE:262 0.224 0.342 0.334 IMAGE:342 0.652 0.682 0.182 ",sep="",header=FALSE) test2<-as.matrix(test1[-1]) colnames(test2)<-NULL genelist<-c("Fkh2","Swi5","Sic1") rownames(test2)<-genelist test2 # [,1] [,2] [,3] #Fkh2 0.141 0.242 0.342 #Swi5 0.224 0.342 0.334 #Sic1 0.652 0.682 0.182 A.K. ----- Original Message ----- From: biostat1 <[hidden email]> To: [hidden email] Cc: Sent: Saturday, July 21, 2012 7:29 PM Subject: [R] Excel file Import - to Matrix format Hi, New to R. Need a bit of help. Thanks I am trying to import data from Excel file. The package I am trying to use requires data in Matrix format. Excel -> R Matrix with the constraint that the very first column in Excel file should became the names for rows of the matrix. Example. Data has 1000 rows and 11 columns. 1st column is the names of Genes 10 coulmns of numerical data. I need to read this into R. it should be a 1000 (row) X 10 Column (Matrix) 1st column of Excel file becomes name of the rows. I am experimenting with reading as data frame (as I am unable to find any info on reading into matrix) split the data frame, etc. Thanks truly appreciate your help. What I need: http://r.789695.n4.nabble.com/file/n4637332/thisWorks2.png http://r.789695.n4.nabble.com/file/n4637332/doesNotWork1.png -- View this message in context: http://r.789695.n4.nabble.com/Excel-file-Import-to-Matrix-format-tp4637332.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ [hidden email] 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. ______________________________________________ [hidden email] 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. |
Use read.table() with the row.names= argument set to the column number that
represents the row.names (presumably 1) and then convert the data.frame to a matrix: A <- read.table(file="fname.csv", row.names=1) B <- as.matrix(A) If you are using Windows, you can open Excel, copy the data, Copy and then change "fname.csv" to "clipboard-128" and R will read the data from the Windows clipboard. ---------------------------------------------- David L Carlson Associate Professor of Anthropology Texas A&M University College Station, TX 77843-4352 > -----Original Message----- > From: [hidden email] [mailto:r-help-bounces@r- > project.org] On Behalf Of arun > Sent: Saturday, July 21, 2012 8:16 PM > To: biostat1 > Cc: R help > Subject: Re: [R] Excel file Import - to Matrix format > > Hello, > > Try this: > > You can use the read.table with sep="," if it is comma separated to > read the file. > > test1<-read.table(text=" > 0.141 0.242 0.342 > 0.224 0.342 0.334 > 0.652 0.682 0.182 > ",sep="",header=FALSE) > #Read data > test1 > # V1 V2 V3 > #1 0.141 0.242 0.342 > #2 0.224 0.342 0.334 > #3 0.652 0.682 0.182 > > > #Convert to matrix as it is that you wanted > test2<-as.matrix(test1) > colnames(test2)<-NULL > genelist<-c("Fkh2","Swi5","Sic1") > rownames(test2)<-genelist > test2 > # [,1] [,2] [,3] > #Fkh2 0.141 0.242 0.342 > #Swi5 0.224 0.342 0.334 > #Sic1 0.652 0.682 0.182 > > #2nd case: As in your example, > test1<-read.table(text=" > IMAGE:152 0.141 0.242 0.342 > IMAGE:262 0.224 0.342 0.334 > IMAGE:342 0.652 0.682 0.182 > ",sep="",header=FALSE) > > test2<-as.matrix(test1[-1]) > colnames(test2)<-NULL > genelist<-c("Fkh2","Swi5","Sic1") > rownames(test2)<-genelist > test2 > # [,1] [,2] [,3] > #Fkh2 0.141 0.242 0.342 > #Swi5 0.224 0.342 0.334 > #Sic1 0.652 0.682 0.182 > > A.K. > > > ----- Original Message ----- > From: biostat1 <[hidden email]> > To: [hidden email] > Cc: > Sent: Saturday, July 21, 2012 7:29 PM > Subject: [R] Excel file Import - to Matrix format > > Hi, > > New to R. Need a bit of help. Thanks > > I am trying to import data from Excel file. The package I am trying to > use > requires data in Matrix format. > > Excel -> R Matrix with the constraint that the very first column in > Excel > file should became the names for rows of the matrix. > > Example. Data has 1000 rows and 11 columns. > 1st column is the names of Genes > 10 coulmns of numerical data. > > I need to read this into R. > it should be a 1000 (row) X 10 Column (Matrix) > 1st column of Excel file becomes name of the rows. > > I am experimenting with reading as data frame (as I am unable to > find any info on reading into matrix) split the data frame, etc. > > Thanks truly appreciate your help. > > What I need: http://r.789695.n4.nabble.com/file/n4637332/thisWorks2.png > > http://r.789695.n4.nabble.com/file/n4637332/doesNotWork1.png > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Excel-file- > Import-to-Matrix-format-tp4637332.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > [hidden email] 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. > > > ______________________________________________ > [hidden email] 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. ______________________________________________ [hidden email] 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. |
Free forum by Nabble | Edit this page |