R data Export to Excel
i think you simply install it in the way you install other R packages.
On Sun, Mar 2, 2008 at 10:40 PM, Christophe Lo <christophe.lo at gmail.com> wrote:
thanks for your response. How do i install it? I try looking at the manual it doesn't seem indicate any installation instruction. I also download a windows version but it doesn't have an exe file. http://cran.r-project.org/web/packages/xlsReadWrite/index.html Newbie, Kei On 3/3/08, Wensui Liu <liuwensui at gmail.com> wrote:
hi, did you try write.xls in xlsReadWrite package? On Sun, Mar 2, 2008 at 9:59 PM, Keizer_71 <christophe.lo at gmail.com> 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:
Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at 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. -- =============================== WenSui Liu ChoicePoint Precision Marketing Phone: 678-893-9457 Email : wensui.liu at choicepoint.com Blog : statcompute.spaces.live.com =============================== -- Christophe Lo (078) 8275 7029 Christophe.Lo at gmail.com
=============================== WenSui Liu ChoicePoint Precision Marketing Phone: 678-893-9457 Email : wensui.liu at choicepoint.com Blog : statcompute.spaces.live.com