Skip to content
Prev 138213 / 398506 Next

R data Export to Excel

Here is my R Code

x<-1:20000
y<-2:141
data.matrix<-data.matrix(data[,y])#create data.matrix
variableprobe<-apply(data.matrix[x,],1,var)
variableprobe #output variance across probesets 
hist(variableprobe) #displaying histogram of variableprobe
write.table(cbind(data[1],
Variance=apply(data[,y],1,var)),file='c://variance.csv')
#export as a .csv file. 

Output in Excel
all in 1 column.

ProbeID "Variance"
1 "224588_at" 21.5825745738848

How do i separate them so that i can have three columns

     ProbeID      Variance
1   224588_at   21.582.....

thanks,
Kei