
Hi all,

 

I have two question. First, I wonder how to remove a part of the column names in a matrix? I would like to remove the "_ACCX" or "_NAX" part below. Is there a method where the "_" as well as all characters after i can be removed?

 

> dim(exprdata)
[1]  88 512

>

> colnames(exprdata[,c(1:20)])
 [1] "Akita_ACC1" "Akita_ACC2" "Akita_ACC3" "Akita_ACC4" "Alc.0_ACC1" "Alc.0_ACC2" "Alc.0_ACC3"
 [8] "Alc.0_ACC4" "Alc.0_ACC5" "Bl.1_ACC1"  "Bl.1_ACC2"  "Bl.1_ACC3"  "Bl.1_ACC4"  "Bla.1_ACC1"
[15] "Bla.1_ACC2" "Bla.1_ACC3" "Bla.1_ACC4" "Blh.1_ACC1" "Blh.1_ACC2" "Blh.1_ACC3"

 

 

Secondly, I would like to calculate the mean of each column group in the matrix, for instance all columns beginning with "Akita", and save all new columns as a new matrix. 

 

For instance, use:

 

> head(exprdata[,c(1:4)])
            Akita_ACC1 Akita_ACC2 Akita_ACC3 Akita_ACC4
A100005-101   6.668931         NA         NA         NA
A122001-101  10.562564  11.706395  11.608989   8.289093
A128001-101  14.946749   8.112625   8.176438  10.104254
A133001-101   5.186679   6.089870   4.119589   3.168841
A133003-101         NA         NA  19.825480   2.587695
A134001-101   3.259402   4.835642   4.679607   4.490254

 

To get something like:

 

                         Akita
A100005-101   6.668931    

A122001-101   10.54176  

A128001-101  10.10425
A133001-101   3.168841

A133003-101   2.587695 
A134001-101   4.490254

 

 

However, the column groups are of different sizes (3-10 columns) so I guess I'll need a method based on the column names.

 

Anyone who can help me?

 

Best regards,

 

Joel
 		 	   		  
_________________________________________________________________
Nya Windows 7 - Hitta en dator som passar dig! Mer information. 
http://windows.microsoft.com/shop
	[[alternative HTML version deleted]]

