Re: [R] perception of graphical data

Hi, You may want to check chapter 4 (Graphical Perception) in W. S. Cleveland (1985?) The Elements of Graphing Data and the references he includes. Regards, -- David On 8/24/07, Yeh, Richard C [EMAIL PROTECTED] wrote: Hello, I apologize that this is off-topic. I am seeking information on

Re: [R] R MySQL Configuration

the author David James, but his email address was non-responsive): Documentation at http://cran.r-project.org/doc/packages/RMySQL.pdf on page 3 indicates that for windows machines the only place that the my.cnf file will be looked for is the root (C:\) directory. Is this read correct? When launching

Re: [R] connecting to DB2 database

Hi, On 6/14/07, Prof Brian Ripley [EMAIL PROTECTED] wrote: On Thu, 14 Jun 2007, Aydemir, Zava (FID) wrote: i am trying to connect to a DB2 server using the DBI library. The DBI *package* does not allow you to connect to anything by itself. For that you need a driver package, currently

Re: [R] setClass with a slot of RODBC

Hi, A couple of thoughts: (1) The channel RODBC is an S3 object, thus there's no proper S4 class associated with it. From ?setOldClass: Description: Register an old-style (a.k.a. `S3') class as a formally defined class. The 'Classes' argument is the character vector used as the

Re: [R] Problems compiling RMySQL

Hi, The error is coming from the FIND command (and in upper case, hmm). I'd suggest making sure you are using the right find. HTH -- David On 6/2/07, Paulino Perez Rodriguez [EMAIL PROTECTED] wrote: Hello, I am trying to compile/Install RMySQL_0.6-0 in R-2.4.1/2.5.0 under Windows XP MCE, I

Re: [R] RMySQL DBI question

Hi, It would be helpful to have a small reproducible example. Do you see the same error if you run R --save whatever.R from the shell prompt? Regards, -- David On 5/31/07, Waverley [EMAIL PROTECTED] wrote: Dear colleague, I have two data frame which I tried to use dbWriteTable function

[R] [R-pkgs] RMySQL 0.5-11 uploaded to CRAN

Hello, I've uploaded version 0.5-11 of RMySQL into CRAN, and it should be available soon. From the NEWS file: Version 0.5-11 * Fixed a bug that would crash R with a failed mysql_real_connect(). * dbApply() is now working again (but still experimentally). * Re-formatted the C code. [0.5-9

Re: [R] RMySQL...Can't initialize driver???

Stephane CRUVEILLER wrote: Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v5.0.22) is running on my local machine but I can't initialize MYSQL driver:

Re: [R] RMySQL...Can't initialize driver???

This looks very suspicious. The function mysqlInitDriver is pretty straight forward (see below), but the error you're reporting apparently has something to do with S4 dispatching: mysqlInitDriver function (max.con = 16, fetch.default.rec = 500, force.reload = FALSE) { if

Re: [R] R, RMysql, and MySQL 5 Decimal Type Support

Hi, MySQL data type 246 is the new (as of version 5.0?) fixed precision DECIMAL type, which doesn't map to any existing R type. In most cases, I believe, it is imported as an R character vector, and you can just coerce it to numeric, i.e., to floating point precision. Next version of RMySQL

Re: [R] RMySQL's column limit

Hi, Mark Van De Vyver wrote: Dear R-users, First, thank you to the developers for the very useful R-library RMySQL. While using this library a recieved an error message: RS-DBI driver: (could not run statement: Too many columns) The statement that generated the error was:

Re: [R] \r with RSQLite

That is a bug, namely, the default end of line on the windows version should be \r\n instead of \n. The workaround is to specify eol=\r\n in dbWriteTable(), e.g., dbWriteTable(con, DF, df, eol = \r\n) dbReadTable(con, DF) Hope this helps, -- David PS The object .Platform includes

Re: [R] Disconnect all MySQL connections

[EMAIL PROTECTED] wrote: Hi I've got the error cannot allocate a new connection -- maximum of 16 connections already opened after I tried to create a new connection to a database. However, the reason ist, that i did not disconnect previous connections I don't know the name of this

Re: [R] prepared query with RODBC ?

Perhaps this thread should be continued in the r-sig-db list? Laurent Gautier wrote: Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking

Re: [R] RMySQL install

Michaell Taylor wrote: I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 bit on a dual dual core machine (that is, two dual core processors). Seems like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite right yet. There are a few mentions

[R] [R-pkgs] RSQLite

Version 0.4-1 of the RSQLite package has been uploaded to CRAN. RSQLite embeds the SQLite engine in R (see http://www.sqlite.org) Changes include: * Fixed problems exporting/importing NA's * An new experimental dbWriteTable() method to create SQLite tables from simple files (delimited

[R] aggregate and ordered factors, feature?

Hi, aggregate() does not preserve the order of levels for ordered factors, e.g., levs - c(Low, Med, Hi) d - data.frame(x = 1:30, fac = ordered(rep(levs, 10), levels = levs)) out - aggregate(d[,x], by = list(fac=d$f), FUN = mean) cat(Original ordered levels:, levels(d$fac), \n)

Re: [R] export from R to MySQL

Prof Brian Ripley wrote: On Mon, 12 Dec 2005, Sean Davis wrote: On 12/12/05 9:21 AM, bogdan romocea [EMAIL PROTECTED] wrote: Sean Davis wrote: but you will have to create the table by hand There's no need for manual steps. To take advantage of MySQL's extremely fast 'load

Re: [R] RSQLite problems

Hi, Thanks for reporting the two problems. I'm attaching a simple update to two functions that will allow you to specify a different separator, e.g., using your example: dbWriteTable(con, barley, barley, overwrite = TRUE, sep = ;) This workaround still relies in dumping the data.frame into

[R] Tip: I() can designate constants in a regression

Just thought I would share a tip I learned: The function I() is useful for specifying constants to formulas and regressions. It will prevent nls (for example) from trying to treat the variable inside I() as something it needs to estimate. An example is below. -David P.S. This may be

[R] Interpolating / smoothing missing time series data

The purpose of this email is to ask for pre-built procedures or techniques for smoothing and interpolating missing time series data. I've made some headway on my problem in my spare time. I started with an irregular time series with lots of missing data. It even had duplicated data.

Re: [R] Crash with seasonal ARIMA

Actually, I think period = 365 * 24 = 8760 is really what I need. That crashes arima as well. I am using period = 365, which makes sense me to me. Is this wrong? [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing

[R] Creating factors from continuous variables

What is the quickest way to create many categorical variables (factors) from continuous variables? This is the approach that I have used: # create sample data N - 20 x - runif(N,0,1) # setup ranges to define categories x.a - (x = 0.0) (x 0.4) x.b - (x = 0.4) (x 0.5) x.c - (x = 0.5) (x

[R] zoo, zooreg, ISOdatetime

I create a zooreg object that runs from Jan-1-2002 0:00 to Jun-1-2005 0:00... regts.start = ISOdatetime(2002, 1, 1, hour=0, min=0, sec=0, tz=) regts.end = ISOdatetime(2005, 6, 1, hour=0, min=0, sec=0, tz=) regts.zoo - zooreg( NA, regts.start, regts.end, deltat=3600 ) Upon inspection:

[R] ARIMA (seasonal) backcasting interpolation

Thanks for everyone's help with zoo -- I think I've got my data set ready. (The data consists of surface weather temperatures, from 2002 to 2005, one observation per hour. Some values are missing... i.e. NA) I have three goals: GOAL #1:Get the data in proper time series form, preserving

[R] Irregular Time Series: zoo its: Pros Cons

Hello, I'm working with irregular time series data. What do you all think about the strengths and weaknesses of the zoo and its packages? I've installed and skimmed the documentation on both packages. I was hoping to get a little guidance from the user community before proceeding

Re: [R] Lattice: how to get default ylim?

Hi, Within your panel function you can use current.viewport() to recover the active grid viewport and get xlim/ylim (in addition to other very useful information). Then you can use grid.text (plus any other grid.* function), e.g., require(grid) my.panel - function(...) {

Re: [R] Lattice: how to get default ylim?

Deepayan Sarkar wrote: On Thursday 19 May 2005 8:00 am, David James wrote: Hi, Within your panel function you can use current.viewport() to recover the active grid viewport and get xlim/ylim (in addition to other very useful information). Then you can use grid.text (plus any other

Re: [R] How can I change SQLite cache size for R session?

Hi, charles loboz wrote: How can I change SQLite cache size for R session? SQLite cache size can be set by a pragma, for the duration of the session - or by default. .pragma cache_size .pragma default_cache_size my questions are about RSQLite, version 0.4, running on Windows:

Re: [R] RMySQL question

simone gabbriellini wrote: Dear List, I have this little problem: I work with adiacency matrix like: data me you me0 1 you 1 0 I store those matrix in a mysql database actually I use RMySQL with: res-dbSendQuery(connection, SELECT * FROM table)

Re: [R] mysql retrive question

simone gabbriellini wrote: hello R-Users, I have this simple but not for me question: I do: res-dbSendQuery(con, SELECT * FROM tabellaProva) myDataFrame-fetch(res) myDataMatrix-as.matrix(myDataFrame[,-1]) namerows(myDataMatrix)-as.character(myDataFrame[,1]) and I have:

Re: [R] RMySQL for R 2.0.1

Fredrik Lundgren wrote: Dear List, RMySQL is old and wouldn't install on R 2.0.1. How should the source be rewritten to be accepted by R 2.0.1. With thanks Fredrik Lundgren __ R-help@stat.math.ethz.ch mailing list

Re: [R] Compressed communication with DB using RMySQL?

Uri wrote: Dear All, I have a setup where R pulls entries from a MySQL db server. I wanted to know whether the R interface can pull encrypted / compressed data from MySQLD. MySQL supports compressed communication on the server side, but I couldn't find any references to such options on the

Re: [R] RMySQL_0.5.5 / SUSE9.2

Hi, I'm not sure where is/are your mistake(s). But you could try finding whether you installed the MySQL shared libraries (as of 4.1.8 there are separate RPMs for these), and/or whether you need to add to your LD_LIBRARY_PATH the directory where these reside. Regards, -- David christian

Re: [R] Searching for a string in RSQLite

Single quotes in a string are escaped by putting two single quotes in a row. E.g., state - mess: '' ( Regards, -- David Duncan Murdoch wrote: I'd like to search for a particular string in an SQLite database using RSQLite, but I'm running into problems constructing the query properly,

Re: [R] RSQLite query error

Mikkel Grum wrote: Dear R-helpers, I ran the following little test on RSQLite and got the data below from the query. Unless I've made some mistake, the results of both the where and order by statements have problems: This is due to the fact that SQLite as of version 2.8 is typeless and

Re: [R] RMySQL and Blob

-Original Message- From: David James [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:06 AM To: LI,JONATHAN (A-Labs,ex1) Cc: David James Subject: Re: [R] RMySQL and Blob [EMAIL PROTECTED] wrote: Hi David, The application I have in mind is for images. In my case

Re: [R] RMySQL and Blob

Hi Jonathan, Currently RMySQL doesn't handle blob objects. The mechanics of inserting and extracting blob objects by itself is not too hard, but issues such as how should blobs be made available to R, how to prevent buffers overflows, how to prevent huge blobs from exhausting the available

Re: [R] ROracle and vector elements

Hi Laura, Sorry for the delay, but I was away and I'm finally catching up... I do have a windows binary at http://stat.bell-labs.com/RS-DBI/download/ but note that you need to have the Oracle's client software. Hope this helps, -- David Laura Holt wrote: Hi there! Is ROracle available

Re: [R] R client connection OLAP cube (SQL Analysis Services / PivotTable Service)

Dear Olivier, I believe your best bet may be to connect to the database through some kind of R-COM connection (either Thomas Baier and Erich Neuwirth's R-(D)COM in CRAN or Duncan Temple Lang's at http://www.omegahat.org/RDCOMClient). For instance, the ADO MD (ActiveX Data Objects

Re: [R] RMySQL question

Prepared statements are not yet in the production 4.0 release of MySQL, only in the development or alpha version 4.1. I hope to add prepared statements and data.frame bindings by the time 4.1 becomes the production release. The API for working with prepared statements and bindings from R will be

Re: [R] useR! 2004 program online

Marc, I agree with you 100% -- they've done a superb job! Unfortunately you sent the email to the wrong David:-) -- David A. James Statistics Research, Room 2C-253Phone: (908) 582-3082 Bell Labs, Lucent Technologies Fax:(908) 582-3340 Murray Hill, NJ

Re: [R] Inserting Date Field into Oracle table using ROracle

: (ORA-01861: literal does not match format string ) Thanks for your help in advance, Swami ([EMAIL PROTECTED]) - Correspondence with David James --- Dear David, Thanks for your kind reply. I did what you suggested, coerced d

Re: [R] boxplot notches

Prof Brian Ripley wrote: On Mon, 1 Mar 2004, Martin Maechler wrote: TL == Thomas Lumley [EMAIL PROTECTED] on Mon, 1 Mar 2004 09:54:48 -0800 (PST) writes: TL On Mon, 1 Mar 2004, Christoph Scherber wrote: Dear list members, Can anyone tell me how the

Re: [R] D(COM) with Excel

Hi Joel, You may want to take a look at the RDCOM implementation at http://www.omegahat.org/RDCOMServer. We've had very good experience with it. -- David Joel Pitt wrote: Hi there, I'm currently trying to use R in an automated macro with Excel, and to this effect I've been using the

Re: [R] R and Sybase

AFAIK the only way to connect to Sybase from R is with the RODBC package, so you need to have an ODBC driver for Sybase -- either one provided by Sybase or the FreeTDS ODBC driver from www.freetds.org. Regards, -- David Peter McMahan wrote: Hi, I'm trying to get R connected to Sybase on a

Re: [R] How to start RMySQL

Jeff Lee wrote: I am a newbie in R and want to use MySQL database. Here is what I have and done. R 1.8.0 mysql 4.0.16 Both running in Windows XP. I download the RMySQL.zip from the internet and used the Packages installer in the RGui to install RMySQL. I also installed DBI

Re: [R] RMySQL valid field names

Luis, Thanks for your thoughtful comments. Indeed you've uncovered a bug/problem in that there's no way for users to control the allow.keywords= argument in calls to dbWriteTable() -- this needs to be fixed. Regarding the default value for allow.keywords, I'm not sure it is wise to set it to

[R] Re: [RMySQL] unable to establish connection since R-1.8.0 upgrade

Hi Laurent, The issue is a very simple one to correct --- you only need to re-install RMySQL with the R version you're currently using. The issue is that the internal representation of objects in the methods package changed in 1.8.0, and thus packages that use S4 classes and methods and save

Re: [R] Patches for DBI/RMySQL valueClass problem?

, Barnet Wagman David James wrote: However, there is a problem in the released version of R 1.8.0 that affects the DBI and other packages (has something to do with methods that use the valueClass argument in the setGeneric/setMethod functions). In this case one needs to use the R-patched

Re: [R] installing DBI_0.1-6.tar.gz

Hi, I've never seen R core dumping during a package installation, if indeed the 1857 Segmentation Fault message applies to R. Could you give us more details (OS, etc.)? Also, have you had problems with any other packages or is this the only one you're having problems with, etc.? Regards, --

[R] RMySQL crashing R

Hi, There have been a number of reports of RMySQL crashing R when attempting to connect to a MySQL server using dbConnect(). The problem appears to be in some binary versions of the MySQL client library. Known instances include (1) Red Hat MySQL binary RPM client library 3.23.32, but

Re: [R] Sending emails from R under Windows

David Khabie-Zeitoune wrote: Hi Does anyone know of any R routines to send emails from R, under Windows? I thought about writing such a facility using the R(D)COM package to drive e.g. MS Outlook, but I don't want to reinvent the wheel. I have found a function Sys.mail in the library

Re: [R] line length limitation in ROracle

Hi, The message is junk - paste(sample(letters, size=5000, replace=T), collapse=) rs - dbSendQuery(con, junk) Error in oraPrepareStatement(con, statement, bind = NULL) : RS-DBI driver: (too long a statement -- it must has less than 4000 chars) so I wouldn't call it a bug --

[R] Interest Calculator for Lawyers

://www.ThorpeForms.com/lib/mrktAds.php?ad=iwiz022003 Join the thousands of attorneys that already use our legal software! Thank you for your time. Sincerely, David James Thorpe, Esq. Offices of David Thorpe Legal Software * To be removed from this mailing list please visit http

Re: [R] RMySQL Install Problem

Hi, Could you tell us what version of MySQL you're running? -- David Fred Gerson wrote: Hey all, I asked my server administrator to install the RMySQL package for me however he was unable to and received the below errors. I searched the archives for some of the words in the error mesage

Re: [R] RMySQL Install Problem

-- David Thanks a lot, Fred On Mon, 17 Mar 2003, David James wrote: Hi, Could you tell us what version of MySQL you're running? -- David Fred Gerson wrote: Hey all, I asked my server administrator to install the RMySQL package for me however he was unable

Re: [R] A little problem handling logicals in RMySQL under R1.6.1

Hi Christian, Thanks a lot for the bug report and the fix. I ended up modifying your fix only very slightly: for(i in seq(along = value)){ if(is(value[[i]], logical)) value[[i]] - as(value[[i]], integer) } [the idiom class(x) - foo, when using