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: r-help-boun...@r-project.org [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 <sridi...@gmail.com> > To: r-help@r-project.org > 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. > > ______________________________________________ > 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.