[R] Odp: Extract summary stats to table

Petr PIKAL petr.pikal at precheza.cz
Tue Oct 5 14:03:56 CEST 2010


Hi

r-help-bounces at r-project.org napsal dne 05.10.2010 13:46:49:

> 
> Dear List,
> 
> I am looking to run a host of models (60) with three methods - lmer,glm 
and lrm.
> 
> Is there a way to output the key stats into a table that i can copy to 
excel?
> 
> I.e for lmer i would want AIC,BIC etc
>     for lrm i would want Brier score, r2, c-value etc
> 
> At present i am running the models from a script and then copying across 
the 
> values into a excel spreadsheet however this is time consuming and i 
imagine 
> their must be a trick?
> 
> I had thought of setting up a data frame and populating it with the 
scores but
> i am not very experienced and am unsure of how to do it?

If you do not wont set up data frame you can use write table to already 
existing file with append=TRUE option

write.table(some.data, "result.xls", sep = "\t", row.names = F, append=T)

where some.data is matrix with one row and desired number of columns.

I presume the output is numeric.

Regards
Petr


> 
> Thanks
> 
> Chris
> 
> ______________________________________________
> 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.



More information about the R-help mailing list