Displaying 20 results from an estimated 300 matches similar to: "dbSendQuery with R variables"
2009 Nov 06
1
issues with SSOAP when wsdl has ComplexTypes
I recently started trying R and SSOAP and was able to successfully try a "hello
world" service. I am now trying to get a more complicated interface to work with
SSOAP and so far failed miserably at that and so need any help I can
get from here.
The service I am attaching is a prototype for a full service that would
take information to identify a data source and a query to run and
return
2006 Mar 22
0
Time table models and querying approach
I doing an app to allow people to search bus time tables by bus stop and
time.
My models are:
Providers -> Services -> Runs -> Stops <- Stations
Key:
"->" denotes a one to many
Providers = Bus companies
Services = the bus number
Runs = Columns on a bus time table
Stops = Cells on a bus time table, basically a time
Stations = Rows on a bus time table
StationA 10:00
2023 Aug 17
1
UEFI syslinux PXE boot issues
On 8/17/23 03:55, AL13N via Syslinux wrote:
> Steve Rikli schreef op 2023-08-16 16:31:
>> On Wed, Aug 16, 2023 at 02:05:33PM +0200, AL13N via Syslinux wrote:
>>> Joakim Tjernlund schreef op 2023-08-16 13:15:
>>> > On Thu, 1970-01-01 at 00:00 +0000, AL13N via Syslinux wrote:
>>> > >
>>> > > I'm used to non-UEFI PXE boot, and I use it
2007 Jul 04
10
A More efficient method?
Dear Rhelpers,
Is there a faster way than below to set a vector based on values from
another vector? I'd like to call a pre-existing function for this, but one
which can also handle an arbitrarily large number of categories. Any ideas?
Cat=c('a','a','a','b','b','b','a','a','b') # Categorical variable
2008 Aug 13
3
Comination of two barcharts and one xyplot
Hi Rhelpers,
I would like to have some help with a plot which is beyond my capabilities. This plot that I am seeking involves an overlay of two different barcharts and one xyplot.
The code that I have used is the following :
#save(df1,file="M:\\KBR\\df1.RData")
load(file="M:\\KBR\\df1.RData")
# df1$Year.ord created to obtain the right order i.e. 2015M < 2015K
2010 Aug 25
2
Removing inter-bar spaces in barchart
Rhelpers:
I'm trying to make a barchart of a 2-group dataset
(barchart(x~y,data=data,groups=z,horizontal=FALSE)). My problem is
that I can't, for the life of me, seem to get rid of the inter-bar
space -- box.ratio set to 10000 doesn't do much. Any ideas? I'd
ideally want zero space between the bars. Thanks!
--j
--
Jonathan A. Greenberg, PhD
Assistant Project Scientist
2010 May 26
2
R and ATLAS
Rhelpers:
I recently installed the 64-bit version of R on my Debian system, and
afterwards was asked if it was compiled using ATLAS. Is there a way
to test to see if R is using ATLAS?
--j
2010 Jan 30
2
Using auto.key with two variable plots
Rhelpers:
Having a problem solving this. I have an xyplot call that looks
like this:
print(xyplot(temp_species_EAM_Pred_Pop$x+temp_species_NULL_Pred_Pop$x~temp_species_EAM_Pred_Pop$Action,main=current_species,
xlab="Action",ylab="Predicted Pop",
xlim=c(xmin,xmax),ylim=c(ymin,ymax),
2002 Feb 20
2
Code for bivariate Poisson regression?
Dear RHelpers,
Does anyone know of any R code to perform bivariate Poisson regression
(including random effects)?
Best wishes
Simon
Simon D.W. Frost, M.A., D.Phil.
Department of Pathology
University of California, San Diego
Antiviral Research Center
(Formerly: UCSD Treatment Center)
150 W. Washington St., Suite 100
San Diego, CA 92103
USA
Tel: +1 619 543 8080 x275
Fax: +1 619 298 0177
Email:
2008 Oct 17
1
missing Rversion.h and Rconfig.h when installing RSQLite under FC8
Hello,
I am having problems installing RSQLite under FC8. The error message
seems to indicate Rversion.h and Rconfig.h are missing. To illustrate
the problem, I have copied below the output shown when I first install R
(binary distribution) and then try to install RSQLite. Because the
problem does not occur when installing RSQLite with R under Windows I
suspect the problem is perhaps due to my
2006 Aug 16
2
adding multiple fitted curves to xyplot graph
Hello RHelpers,
This may already have been answered, but despite days of scouring through the archives I haven't found it.
My goal is to add multiple fitted curves to a plot.
An example data set (a data frame named df in following code) is:
x1 y1 factor1
4 1298.25 0.00000000 1
5 1393.25 0.00000000 1
6 1471.50
2004 Jul 09
1
creating plots by batch
Hello RHelpers!
I'm very ashamed but....
I'm creating quite a lot of plots in a big loop...each times the program ask me :
> Hit <Return> to see next plot:
How do I avoid that?
Many, many thanks as always....
Anne
----------------------------------------------------
Anne Piotet
Tel: +41 79 359 83 32 (mobile)
Email: anne.piotet@m-td.com
2010 May 13
1
Comparing histograms?
Rhelpers:
I'm curious what the appropriate analysis to use for testing the
hypothesis that two histograms are statistically different from one
another? Thanks!
--j
2007 Apr 27
1
add arrows to barchart with groups
Hello Rhelpers,
I am trying to represent the following data (hereafter named donnees) in a barchart with a grouping variable :
site traitement date s res
1 NT 17/10/2005 normal 76.2
1 T 17/10/2005 normal 103.2
1 NT 23/11/2005 tardif 81.6
1 T 23/11/2005 tardif 98
2 NT 15/10/2005 normal 72.71
2 T 15/10/2005 normal 94.47
2 NT 15/11/2005 tardif 79.65
2 T 15/11/2005 tardif 94.7
2009 Mar 02
1
initial gradient and vmmin not finite
Dear Rhelpers
I have the problem with initial values, could you please tell me how to solve it?
Thank you
June
> p = summary(maxLik(fr,start=c(0,0,0,1,0,-25,-0.2)))
Error in maxRoutine(fn = logLik, grad = grad, hess = hess, start = start, :
NA in the initial gradient
> p = summary(maxLik(fr,start=c(0,0,0,1,0,-25,-0.2),method="BFGS"))
Error in optim(start, func, gr =
2006 Nov 02
1
avoiding a loop: "cumsum-like"
Hello Rhelpers,
I need to run the following loop over a large number of data-sets, and was wondering if it could somehow be vectorized. It's more or less a cumulative sum, but slightly more complex.
Here's the code, and an example dataset (called tab in my code) follows.
Thanks in advance for any suggestions!
res<-0
for (i in min(tab$Date):max(tab$Date))
{
if
2023 Aug 17
1
UEFI syslinux PXE boot issues
Steve Rikli schreef op 2023-08-16 16:31:
> On Wed, Aug 16, 2023 at 02:05:33PM +0200, AL13N via Syslinux wrote:
>> Joakim Tjernlund schreef op 2023-08-16 13:15:
>> > On Thu, 1970-01-01 at 00:00 +0000, AL13N via Syslinux wrote:
>> > >
>> > > I'm used to non-UEFI PXE boot, and I use it for my network installer
>> > > since forever ago.
2007 Mar 20
5
abline within data range
Dear R helpers,
I would like to have abline, for a lm model for
example, lying within data range. Do you know how to
get it?
Thank in advance
Nguyen D Nguyen
#CODE
x<- rnorm(200, 35,5)
y<- rnorm(200, 0.87,0.12)
plot(y~x, xlim=c(0,50), pch=17, bty="l")
abline(lm(y~x))
# I would like abline is between min(x) and max(x)
[[alternative HTML version deleted]]
2013 Jul 15
2
Serialize data.frame to database
Dear R-Users,
I need a very fast and reliable database solution so I try to serialize a data.frame (to binary data) and to store this data to an SQLite database.
This is what I tried to do:
library(RSQLite)
con <- dbDriver("SQLite")
db <- dbConnect(con, "test")
dbSendQuery(db, 'CREATE TABLE frames("simID" INT, "data" BLOB)')
data.bin <-
2009 May 06
2
rmysql query help
R HELP,
I am trying to use an R script to connect to a mysql database. I am
having a problem using a variable in the where clause that contains a
"space" in its value.
If I include the variable inside the quotes of the query - i think it is
searching for the name of the variable in the database and not the value
of the variable.
If I put it outside the quotes, then it complains