If you are asking how to convert to multiple columns in Excel, look at the "text to column" option in I think the data tab.
On Sun, Mar 2, 2008 at 9:59 PM, Keizer_71 <[EMAIL PROTECTED]> wrote: > > 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 > > > -- > 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 Nabble.com. > > ______________________________________________ > R-help@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. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem you are trying to solve? ______________________________________________ R-help@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.
