search for: 224588_at

Hello, Thanks everyone for helping me with the previous queries. step 1: Here is the orginal data: short sample ProbeID Sample_1_D Sample_1_C Sample_2_D Sample_2_C 1 224588_at 2.425509867 11.34031409 11.46868531 11.75741478 step 2: i calculate the variance of the sample using this R code x<-1:20000 y<-2:141 data.matrix<-data.matrix(data[,y])#create data.matrix variableprobe<-apply(data.matrix[x,],1,var) step 3: however, when i type in variableprobe,...

...r) 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 -- View this message in context: http://www.nabble.com/R-data-Export-to-Excel-tp15796903p15796903.html Sent from the R help mailing list archive at...

...obe<-apply(data.matrix[x,],1,var) variableprobe #output variance across probesets hist(variableprobe) #displaying histogram of variableprobe write.xls(cbind(data[1], Variance=apply(data[,y],1,var)),file='c://variance.csv') #export as a .csv file. Output: ProbeID Variance 224588_at 21.58257457 ############################################################################## #############filter out low variance and Select 10,000 probesets############## data.sub = data.matrix[order(variableprobe,decreasing=TRUE),][1:10000,] dim(data.sub) write.table(data.sub, file = "c://...