[R] Excel file Import - to Matrix format

[arun]

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 <sridiyer at gmail.com>
To: r-help at 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 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.