[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