Currently in R, constructing a string containing
values of variables is done using 'paste' and can be
an error-prone and traumatic experience. For example,
when constructing a db query we have to write,
paste(SELECT value FROM table where
date =',cdate,')
we are getting null result
Hi,
In Bioconductor, we have something called copySubstitute, which does
what you want, I believe,
x=select @var1@ from @tab1@
copySubstitute(textConnection(x), symbolValues= list(var1=Race,
tab1=ReallyBigTable), dest=stdout())
yields
select Race from ReallyBigTable
you can read in from
The other thing to use is 'sprintf', which would be fantastic in R if it
imputed types based on the format string.
As it is now, for your query you would do:
sprintf(SELECT %s FROM table WHERE date = '%s', column, 2005-10-12)
[1] SELECT column FROM table WHERE date = '2005-10-12'
Which, in my
I tried to install SciViews in R 2.1.0 (on Windows)
and on all machines I get:
bundle 'SciViews' successfully unpacked and MD5 sums checked
Error in sprintf(gettext(unable to move temp installation '%d' to
'%s'), :
use format %s for character objects
how can I solve this problem?
--
On 07-May-05 James Bullard wrote:
The other thing to use is 'sprintf', which would be fantastic in R if
it imputed types based on the format string.
As it is now, for your query you would do:
sprintf(SELECT %s FROM table WHERE date = '%s', column,
2005-10-12)
[1] SELECT column FROM table
Si segnala di rivolgersi per
tasse e pagamenti a [EMAIL PROTECTED]
di contattare la propria segreteria studenti agli indirizzi:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL
Dear WizaRds,
I am sorry to bother you with a newbie question, but although I tried to solve
my problem using the various .pdf files (Introduction, help pages etc.), I have
come to a complete stop. Please be so kind as to guide me a little bit along my
way of exploring multivariate analysis in
Ich werde ab 04.05.2005 nicht im Büro sein. Ich kehre zurück am
16.05.2005.
Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting
On Sat, 7 May 2005, James Bullard wrote:
The other thing to use is 'sprintf', which would be fantastic in R if it
imputed types based on the format string.
But it does in 2.1.0, the current version.
As it is now, for your query you would do:
sprintf(SELECT %s FROM table WHERE date = '%s', column,
On 5/7/05, charles loboz [EMAIL PROTECTED] wrote:
Currently in R, constructing a string containing
values of variables is done using 'paste' and can be
an error-prone and traumatic experience. For example,
when constructing a db query we have to write,
paste(SELECT value FROM table
On Sat, 7 May 2005, Erich Neuwirth wrote:
I tried to install SciViews in R 2.1.0 (on Windows)
and on all machines I get:
bundle 'SciViews' successfully unpacked and MD5 sums checked
Error in sprintf(gettext(unable to move temp installation '%d' to
'%s'), :
use format %s for character
Dear R colleagues,
I am trying to create a new column in a data frame, which converts values
and NA's from another column into binary format. Essentially I need the
NA's to become 1 and the rest to be 0. The code I wrote is returning the
following error message:
Error in if (mort[i, 4] != NA)
See ?is.na
On 5/7/05, Gillian Rutherford [EMAIL PROTECTED] wrote:
Dear R colleagues,
I am trying to create a new column in a data frame, which converts values
and NA's from another column into binary format. Essentially I need the
NA's to become 1 and the rest to be 0. The code I wrote is
mort[8] - is.na(mort[4])
(If you really want 1/0, add '+ 0' to this expression.)
Testing (in)equality with NA always gives NA. This is discussed in all
good books on S/R, e.g. in MASS (see the FAQ).
On Sat, 7 May 2005, Gillian Rutherford wrote:
Dear R colleagues,
I am trying to create a new
On 07-May-05 Gillian Rutherford wrote:
Dear R colleagues,
I am trying to create a new column in a data frame, which
converts values and NA's from another column into binary format.
Essentially I need the NA's to become 1 and the rest to be 0.
The code I wrote is returning the following
Hi all,
I have just installed OSX Server 10.4 and R comes up with the
incompatible libxml library message reported by Dan Kelley a few
messages ago. Xcode 2 does not ship with Tiger Server. I installed
the X-Windows code. I can report that the version of libxml2.2 that is
installed in this
Is there a fast way to undebug() all functions that are currently
being debugged in all environments?
Thanks.
FS
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
On Sat, 7 May 2005, Fernando Saldanha wrote:
Is there a fast way to undebug() all functions that are currently
being debugged in all environments?
I guess you mean `marked for debugging' and not `currently being executed
under a browser started by being marked for debug'?
Debugging is a property
Thank you for your help.
The library directory contained some very strangely named
subdirectories, file3132 and similarly.
After removing these and vereything related to SciViews
I was able to install SciViews.
Looking back I seem to remember that form time to time
these strange directories appear
On Sat, 7 May 2005, Erich Neuwirth wrote:
Thank you for your help.
The library directory contained some very strangely named
subdirectories, file3132 and similarly.
After removing these and vereything related to SciViews
I was able to install SciViews.
Looking back I seem to remember that form
Coming up to speed on both R and S-Plus. My access to S-Plus will end
soon so I want to get up to speed on R. The big initial difference
seems that R has only the command editor where S-Plus also has a
windows interface.
My preference is to learn the language and the windows interface
doesn't
I would like to perform a bootstrap validation of a backward stepwise
logistic regression analysis, but I am a beginner with R and I am not
sure of how to do it.
Is there anyone that can send me a sample file in tab format (that I
can modify in Excel by pasting my data) and the pertinent R
I would like to vectorize a calculation that is bootstrapped, in the
sense that each step uses the results of the previous steps. For
example:
x - rep(NA, 5)
y - rnorm(5)
for (i in 1:5) {
x[i] - max(y[i], ifelse(i 0, min(x[1:i-1], 0)))
}
(the functions max and min are used just as an
Sorry to reply to my own post, but I have more info. This probably
needs to come to the attention of the Mac R developers.
Xcode 2.0 does not have a more recent libxml2.2.dylib.
The problem only manifests itself when running R 2.1.0 from the command
line, not within the Aqua GUI.
Thanks for
Dear all,
There is an updated version of the eba package for
elimination-by-aspects (EBA) choice models available on CRAN.
It features new functions for extracting and plotting
the residuals, for testing hypotheses on the parameters
(wald.test), and for comparing sub-samples (group.test).
The
From: Jonathan Q.
Coming up to speed on both R and S-Plus. My access to S-Plus will end
soon so I want to get up to speed on R. The big initial difference
seems that R has only the command editor where S-Plus also has a
windows interface.
What exactly do you mean by this? What would you
Giuseppe Biondi Zoccai wrote:
I would like to perform a bootstrap validation of a backward stepwise
logistic regression analysis, but I am a beginner with R and I am not
sure of how to do it.
Is there anyone that can send me a sample file in tab format (that I
can modify in Excel by pasting my
27 matches
Mail list logo