[R] Handling of tables in R

Romain Francois francoisromain at free.fr
Fri Aug 19 11:37:01 CEST 2005


Le 19.08.2005 11:22, Anne a écrit :

>Save your table in a text file ( see ?write.table ) with the separator
>set to "\t" ; you can then import it into excel
>
>for the nb of digits use 
>  
>
>>options(digits=3)
>>    
>>
>
>see ?options 
>
>  
>
Hello,

And if you run R on windows (just a guess because you didn't tell), the 
saving-to-a-file part is not necessary. use :
R> write.table(your.data.frame, file='clipboard')
and on excel "paste", your data should magically appear on excel ...

Romain

>Anne
>
>
>2005/8/19, Fredrik Thuring <frt at codan.dk>:
>  
>
>>       Hi!
>>
>>       I have a few questions concerning reading of tables from R to
>>other programs. My main question is if it's even possible to read a table
>>created in R (with the functions data.frame     and save) to Excel (or
>>maybe SAS) and if so how does one do this? If I just mark the table in R
>>and copy-paste to Excel the whole table ends up in one single cell, (of
>>course).        My goal is to copy the table to Excel (or SAS) in such a
>>way that a single observation gets placed in a single cell.
>>
>>       If this isn't possible, is there any way to reduce the number of
>>digits in a table in R?
>>
>>       I would be more than happy if there were any one who knows the
>>answer to my questions!
>>
>>       Thanks before hand,
>>       Fredrik Thuring
>>       Research department
>>       Codan Insurance, Copenhagen
>>    
>>


-- 
visit the R Graph Gallery : http://addictedtor.free.fr/graphiques
~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~
~~~~~~      Romain FRANCOIS - http://addictedtor.free.fr         ~~~~~~
~~~~        Etudiant  ISUP - CS3 - Industrie et Services           ~~~~
~~                http://www.isup.cicrp.jussieu.fr/                  ~~
~~~~           Stagiaire INRIA Futurs - Equipe SELECT              ~~~~
~~~~~~   http://www.inria.fr/recherche/equipes/select.fr.html    ~~~~~~
~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~




More information about the R-help mailing list