[R-SIG-Mac] 64-bit R-build on Mac OS X 10.4

2007-11-06 Thread Steven McKinney
On Aug 29, 2007, Simon Urbanek wrote (in response to Sayan Pathak): https://stat.ethz.ch/pipermail/r-sig-mac/2007-August/004082.html > My apologies if this is a naive question. I am new to Mac and also > compiling R from source for the first time. Could you please suggest

Re: [R-SIG-Mac] Preparing mySQL queries for R and SNA

2007-11-06 Thread elw
> input in R. I am hoping to do both the stats and SNA portions of my > analysis in R (using the sna package as well). I endeavor to write a > script to handle everything. My process flow is: mySQL >> R >> R(sna) > >> output tables and graphs >> insert into docs. This is indeed a sane work

Re: [R-SIG-Mac] Preparing mySQL queries for R and SNA

2007-11-06 Thread Byron Ellis
You can talk to MySQL directly from R (using the RMySQL and DBI packages) so there's no need to create an intermediate file. My SOP is to query the database wth dbGetQuery and immediately drop the results into an Rda file (just in case). On 11/6/07, Brendan Casey <[EMAIL PROTECTED]> wrote: > Hello

[R-SIG-Mac] Preparing mySQL queries for R and SNA

2007-11-06 Thread Brendan Casey
Hello R list members! I am brand new to R, but very impressed with its potential as a "one stop shop" for stats and sna output with a single input file. Once I get my tech problems with Rcmdr crashing sorted out(!!!). I need to be able to query a mySQL db and export the results for in

Re: [R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

2007-11-06 Thread Markus Gesmann
Graham, I think you are right, it only works for a data.frame. Cheers, Markus Markus Gesmann │Associate Director│Libero Ventures Ltd, One Broadgate, London EC2M 2QS tel: +44 (0)207 826 9080│ dir: +44 (0)207 826 9085│fax: +44 (0)207 826 9090 www.libero.uk.com AUTHORISED AND REGULATED BY THE FI

Re: [R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

2007-11-06 Thread Graham Smith
Yes, I feared that was the case, but thanks for trying. Graham On 06/11/2007, Markus Gesmann <[EMAIL PROTECTED]> wrote: > > Graham, > > I think you are right, it only works for a data.frame. > > Cheers, > > Markus > > Markus Gesmann Associate DirectorLibero Ventures Ltd, One Broadgate, > London

Re: [R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

2007-11-06 Thread Graham Smith
Markus, Thanks, Should this work with something like the results produced by summary(x) or does it only work with data frames. As always I find the help rather terse and impenetrable, but it seems to be aimed exporting data frames rather than analysis output tables - hopefully I have misundersto

Re: [R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

2007-11-06 Thread Markus Gesmann
Dear Graham, I use write.table to copy to the clipboard and paste into Excel on Windows and Mac. Here is an example: mydf=data.frame(x=1:10, y=letters[1:10]) write.table(mydf, file="clipboard", sep="\t", row.names=FALSE) Kind regards, Markus Markus Gesmann │Associate Director│Libero Ventures

[R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

2007-11-06 Thread Graham Smith
In Windows you can use R2HTML to copy R output into the clipboard for pasting into Excel as a formatted table, but this doesn't work on a Mac. Are there any obvious alternative approaches to easily paste formatted output into another application on the Mac. Thanks, Graham [[alternative

[R-SIG-Mac] input data in portuguese (accent problems)

2007-11-06 Thread Tiago R Magalhães
Dear members of the R list, I am a biologist, with some R knowledge, but with a basic question! I want to read a csv file which is in portuguese, hence with accents in the column names and the columns themselves. I have searched in the browse archives and couldn't find a solution. The closest I