[R] export test results to csv
ivan.calandra at uni-hamburg.de
Fri Feb 5 11:43:16 CET 2010
Thanks to all for your help.
So to answer all questions:
- "test" is indeed a list. With my real data:
List of 3
$ output : num [1:15, 1:6] 1 2 3 4 5 6 7 8 9 10 ...
..- attr(*, "dimnames")=List of 2
.. ..$ : NULL
.. ..$ : chr [1:6] "con.num" "psihat" "p.value" "p.crit" ...
$ con : num [1:6, 1:15] 1 -1 0 0 0 0 1 0 -1 0 ...
$ num.sig: int 0
- I want to export it to a csv file to save the results in a file that I
will be able to edit. What I mean here is that for publications, I
usually have the results from the statistic tests in a table. That is
why I think that a csv file is the best option for me. However, I'm open
to other suggestions! There might be better ways to save/store the results.
- So what I do now is:
> write.csv(test[], file="pbmcp.csv", append=F, quote=F, row.names=F)
> write.csv(test[], file="pbmcp.csv", append=T, quote=F, row.names=T)
> write.csv(test[], file="pbmcp.csv", append=T, quote=F, row.names=F)
I have then two other questions:
- I would like the name of each element of the list to appear too. How
should I do it? I can do:
> write.csv(names(test)[], file="pbmcp.csv", append=T, quote=F,
But there might be an easier way.
- It is not so complicated to run these lines, but I thought there might
be a simpler and more compact way to do it.
Thanks in advance for your help
Le 2/5/2010 07:57, Rubén Roa a écrit :
> Or try
> write.csv(test, file="pbmcp.csv", append=F, quote=F, row.names=F, na='NA')
> Dr. Rubén Roa-Ureta
> AZTI - Tecnalia / Marine Research Unit
> Txatxarramendi Ugartea z/g
> 48395 Sukarrieta (Bizkaia)
> -----Mensaje original-----
> De: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] En nombre de Jim Lemon
> Enviado el: viernes, 05 de febrero de 2010 0:03
> Para: ivan.calandra at uni-hamburg.de
> CC: r-help at r-project.org
> Asunto: Re: [R] export test results to csv
> On 02/05/2010 03:44 AM, Ivan Calandra wrote:
>> Hi everybody!
>> I would like to export the results of a test statistic in a *.csv
>> file, but get an error.
>> The code is below.
>> The data are attached as .txt with tab as separator. I tried to get a
>> sample dataset, but for some reason it didn't work, so please excuse
>> the length of the file. I also attached a txt with the output
>> (copy/paste) in case that helps.
>> > library(WRS)
>> > ssfamed<- read.table(file=file.choose(), header=T, sep="\t")>
>> ssfa_Asfc<- fac2list(ssfa[,7], ssfa) #store into list mode> test
>> <- pbmcp(ssfa_Asfc, alpha=0.05, nboot=2000, bhop=F) #it takes about 5
>> seconds to run> write.csv(test, file="pbmcp.csv", append=F, quote=F,
>> row.names=F) Error in data.frame(output = c(1, 2, 3, 4, 5, 6, 7, 8, 9,
>> 10, 11, 12, :
>> arguments imply differing number of rows: 15, 6, 1
>> I guess it is because of the formatting of the "test" object and I
>> should reorganize it, but I actually have no idea how to do it.
>> Tips would be greatly appreciated!
> Hi Ivan,
> My guess is that you want to import this into a spreadsheet, the name of which I will not mention. If so, have a look at the delim.table function in the prettyR package.
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help