Windows clipboard.

> -----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.