Displaying 20 results from an estimated 1000 matches similar to: "export from R to MySQL"
2004 Mar 23
3
how to modify variables of another frame (but not global)
Hello!
Maybe "frame" is not the right term in this context.
I explain my problem by example code:
fun2 <- function(objName, add) {
## the object "objName" should be increased by "add",
## but the evaluation should be done in the calling function (here:
fun1)
## ...... what's the right code??
}
fun1 <- function() {
x <- 1
fun2("x",
2004 Sep 29
2
problems with ESS & R ...
Hi!
I have R 1.9.1, Mac OS X 10.3.5, GNU Emacs 21.2.1 and ESS 5.2.3.
I installed today the ESS by not changing ess-site.el, but creating
.emacs in $home with the single line:
$ cat ~/.emacs
(load "/usr/local/lib/ess-5.2.3/lisp/ess-site")
If I start now emacs and then R (with M-x R) then I get:
> options(STERM='iESS', editor='emacsclient')
but using fix() oder
2002 Feb 22
1
Summary: read.table on Mac OS X, CARBON vs. DARWIN
Thanks a lot, James!!
The problem is fixed. On the version 1.4.0 Mac/darwin (the latest
available version for this system) the function read.table (which is
called from read.delim etc., too) has the bug you explained.
Inserting the row
nlines <- nlines+1
after
lines <- c(lines, line)
removes this bug.
M.
On Friday, February 22, 2002, at 02:33 PM, james.holtman at convergys.com
2006 Dec 21
4
where is the source code of bca.ci?
i was searching for the source of bca.ci, a function of the package
boot. I tried
require(boot, keep.source=TRUE)
but again the source was not viewable. How should i do?
Best regards
Meinhard Ploner
----------------
PS
> version
_
platform i386-apple-darwin8.8.1
arch i386
os darwin8.8.1
system i386, darwin8.8.1
status
major 2
2002 Feb 22
3
storing large data.frame's
I am new on R, so I have a maybe naive question:
if I have many large data.frames and I use only one or two per session,
what's the best way?
If all are stored in the actual .Rdata, the system gets slow.
On the other hand, I wouldn't like to make a separate package for the
data.
Should I save it with save() and then remove it with rm() ?
Could I reload it then?
Thanks for suggestions
2003 May 21
2
overlapping a plot with an external image
It's possible to overlap an external image (jpg or pdf)
with a plot generated with R?
Specifying the image as the background
of the plot might not be possible...
any idea?
thanks
Meinhard Ploner
2004 Jul 08
1
building packages with NAMESPACE
hi!
I tried to build a very simple package with NAMESPACE file,
such that datasets are loaded only dynamically.
> a2 <- function(x=a1) x+4
> a1 <- 1:10
> package.skeleton("aaa", list=c("a1", "a2"))
Then I modified the help files and added the file NAMESPACE with these
2 lines:
useDynLib(aaa)
export(a1, a2)
Then "R CMD BUILD aaa" works
2006 Aug 19
1
problem with Rcmd check and fortran95, makefile
Hi all,
I have Win XP and R 2.3.1 on my notebook. I would like to write a package which includes some Fortran 95 code. Interestingly, if I compile and link the simple file test90.f90 directly with
g95 -c test90.f90
g95 -shared -o test90.dll test90.o
then PE Viewer ( a dll viewer) shows me the right functions in the export table, hence I can use the dll in R. But as it should become part of a
2004 Aug 16
3
plot.table on R 1.9.1
Hello!
What is wrong on my system?
I have downloaded today R 1.9.1 on my PC with Windows.
plot.table isn't available in package <base> and neither in package <graphics> (as suggested after ?plot.table).
Kind regards
Meinhard Ploner
[[alternative HTML version deleted]]
2003 Sep 18
2
Place a graphic into an R-plot
I have a graphic image in a file (say a *.jpeg or *.png file) and want to
put it into a plot. I have segmented the plot area by means of the layout
function and successfully plotted my data in the appropriate segments. I
cannot find how to put my graphic image onto the same plot. Searching the
archives has shed little light on my challenge.
Many thanks in anticipation.
Gordon
> version
2004 Sep 24
2
emacs, Mac OS X, R
Hi!
Since August I am using emacs on my Macintosh to edit the R objects. I
have installed R 1.9.1, Mac OS X 10.3.5 and GNU Emacs 21.2.1. However
there are some issues I haven't resolved:
a) switch the caps lock key to the meta key (and when this is not
possible, switch the alt/option key to the meta). The switch should
work only within emacs!
b) having different colors for the code,
2007 Oct 08
1
data.frame's and [2, c(T, F)] in R 2.6.0
In R prior to 2.6.0 with matrizes as well as with data.frames it is
possible to do:
a[2, c(TRUE, FALSE)]
In R 2.6.0 the mixed indexing works only for matrizes. Is this the
intention, a bug, or did I get something wrong?
Best regards
Meinhard
Meinhard Ploner
Althingstrasse 15
39031 Bruneck
P.IVA 0234 058 0212
Tel. +39 340 8937861
www.data-ploner.com
[[alternative HTML version
2003 Mar 13
2
RODBC and Excel in Widows
Hello, I have some problems with RODBC and Excel in Win98
I am using R 1.6.2 and just upgraded RODBC to the last version on CRAN.
I have an Excel file with columns Number, Name, Sex, Age, FEV1 on Sheet
1 and Number, Age, FEV1, Name, Sex on Sheet 2.
Now I open the channel to the file
> chan1 <- odbcConnectExcel("c:/testOdbc.xls")
> tables(chan1)
and the list appears with the 2
2005 Oct 20
1
strange behaviour of memory management
Hi all!
My system: R 2.1.1, Mac OS X 10.4.2.
I have a very memory-consuming job for R, consisting of a function
calling some other functions, working often with matrices of size
100.000 x 300. If I call the job directly after starting R the job
takes overall 40min, however only 7min of process time. I assume the
large difference is through memory-handling which doesn't count as
2004 Jul 09
0
packages & data-sets & name spaces
> From: Prof Brian Ripley <ripley at stats.ox.ac.uk>
> Date: June 17, 2004 12:15:01 PM CEST
> To: Meinhard Ploner <meinhardploner at gmx.net>
> Cc: r-help at stat.math.ethz.ch
> Subject: Re: [R] packages & data-sets
>
> On Thu, 17 Jun 2004, Meinhard Ploner wrote:
>
>> It's possible to create a package with functions and data,
>> from which
2001 Nov 09
1
R for Mac OS X
It seems that R 1.3.1 is not very stable for Mac OS X.
I installed it some days ago and had about 10-20 crashes
in the last days.
In S-Plus I never had these problems (or seldom), but
I worked on Win NT.
Who can help?
Meinhard
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send
2004 Jun 17
1
packages & data-sets
It's possible to create a package with functions and data,
from which the use
library(pkg-name)
"attaches" not only the functions, but also the data?
I want avoid to use
data(dataset, package="name")
because this makes a global copy of the data-set ...
Anyone could help me?
Meinhard
2004 May 24
1
RMySQL problem
Hi,
I'm using R 1.9.0 with RMySQL 0.5-4 and MySQL 3.23.55 on a suse 8.2 box.
I have a simulation study and (as usual for newbies in simulation, I
guess) I have a lot of data that I want to store in MySQL. I want to
write an R script that reads data from RData files and writes it to a
MySQL database.
I read some R documents (R Data Import/Export and DSC papers) but I'm
finding
2001 Dec 10
2
Corrupt .RData
I'm using R 1.3.1 on a Windows NT 4.0 machine. As you might
guess my machine crashes on me from time to time :-| So far,
forcing a reboot via the Taskmanager has worked reasonably
well: any open R session would enquire politely whether to
save, and do so if requested.
This time, it has not worked out. I get a 'Fatal Error:
unable to restore saved data in .RData' message and
R
2002 Dec 18
1
A little problem handling logicals in RMySQL under R1.6.1
There is a little problem in handling logicals in RMySQL:
# here is the MySQL connection
> con
<MySQLConnection:(1816,0)>
# here is the data frame
> print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE)))
x y
1 TRUE FALSE
2 FALSE TRUE
# as promised, the two data frame columns are identified as logicals and
# the field types are set to tinyint
> field.types <-