similar to: Creating a data table (frame?) from a SQL Statement?

Displaying 20 results from an estimated 1347 matches similar to: "Creating a data table (frame?) from a SQL Statement?"

2017 Oct 24
1
Creating a data table (frame?) from a SQL Statement?
Hello, I'm new to R so this is probably a simple question for somebody. I have an RScript that reads a CSV on the disk using read.table(...). It then does a boxM test using that data. However, I'm now trying to load the same data via an SQL command, but I can't seem to get the data structure defined so R will like it -- using the included "iris" dataset. I've tried
2017 Oct 30
1
Pass Parameters to RScript?
I do not program in Java but it seems a Java program can make system calls which would be equivalent to running from the command line, but done from within a Java program. Not sure whether that would meet your needs and if not why not. Just a suggestion. Check out http://www.java-samples.com/showtutorial.php?tutorialid=8 On Mon, Oct 30, 2017 at 5:10 PM, Morkus <morkus at
2017 Oct 30
2
Pass Parameters to RScript?
Thanks Eric, I saw that page, too, but it states: "This post describes how to pass external arguments to R when calling a Rscript with a command line." Not what I'm trying to do. Thanks for your reply. Sent from [ProtonMail](https://protonmail.com), Swiss-based encrypted email. > -------- Original Message -------- > Subject: Re: [R] Pass Parameters to RScript?
2017 Oct 30
1
Pass Parameters to RScript?
I did a simple search and got hits immediately, e.g. https://www.r-bloggers.com/passing-arguments-to-an-r-script-from-command-lines/ On Mon, Oct 30, 2017 at 2:30 PM, Morkus via R-help <r-help at r-project.org> wrote: > Is it possible to pass parameters to an R Script, say, from Java or other > language? > > I did some searches, but came up blank. > >
2017 Nov 13
1
Where to get support for Rserve?
?maintainer ## i.e. maintainer("rserve") Also, please search. A web search on simply "rserve" brought up what appeared to be many relevant hits. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Mon, Nov
2010 Feb 03
1
Calculating subsets "on the fly" with ddply
Hi, [I sent this to the plyr mailing list (late) last night, but it seems to be lost in the moderation queue, so here''s a shot to the broadeR community] Apologies in advance for being more verbose than necessary, but I''m not even sure how to ask this question in the context of plyr, so ... here goes. As meaningless as this might be to do with the `iris` data, the spirit of it
2008 Oct 12
0
OT: irises
Attention conservation notice: a digression on Fisher''s iris data, related only tangentially to R. The package announcement for hwriter points to a webpage created with the package, http://www.ebi.ac.uk/~gpau/hwriter/ based on the Fisher/Anderson iris data, including pictures. Unfortunately, the pictures are not of the right species (two appear to be tall
2010 Jun 09
5
question about "mean"
Hi there: I have a question about generating mean value of a data.frame. Take iris data for example, if I have a data.frame looking like the following: --------------------- Sepal.Length Sepal.Width Petal.Length Petal.Width Species 1 5.1 3.5 1.4 0.2 setosa 2 4.9 3.0 1.4 0.2
1999 Oct 25
1
trouble reading in datasets
Dear All, I was trying to follow some of the examples in Venables and Ripley "Modern applied ... with S-plus" I have downloaded a copy of the iris data set and loaded into R. : however I cannot use the apply command (from p47): > apply (iris, 2 ,mean) Error in sum(..., na.rm = na.rm) : invalid "mode" of argument > apply (iris, c(2) ,mean) Error in sum(..., na.rm =
2012 May 05
2
what is Non-numeric argument to mathematical function in prediction ?
Hi, I tried to use naivebayes in package ''e1071''. when I use following parameter, only one predictor, there is an error. > m <- naiveBayes(iris[,1], iris[,5]) > table(predict(m, iris[,1]), iris[,5]) Error in log(sapply(attribs, function(v) { : Non-numeric argument to mathematical function However, when I use two predictors, there is not error any more. > m
2005 Feb 08
1
Toying with neural networks
Hello all, Ive been playing with nnet (package ''nnet'') and Ive come across this problem. nnet doesnt seems to like to have more than 1000 weights. If I do: > data(iris) > names(iris)[5] <- "species" > net <- nnet(species ~ ., data=iris, size=124, maxit=10) # weights: 995 initial value 309.342009 iter 10 value 21.668435 final value 21.668435 stopped
2005 Jul 06
1
Help: Mahalanobis distances between ''Species'' from iris
Dear R list, I''m trying to calculate Mahalanobis distances for ''Species'' of ''iris'' data as obtained below: Squared Distance to Species From Species: Setosa Versicolor Virginica Setosa 0 89.86419 179.38471 Versicolor 89.86419 0 17.20107 Virginica 179.38471 17.20107 0 This distances above were
2011 Feb 09
3
Insert variable in RMySQL-Statement
Dear list, I''m working with a MySQL-Table and would like to extract selected ids that are stored in a vector: Ids <- c(1,2,3) How do I insert this variable in a for loop like this: For (a in values) { Temp <- dbGetQuery(con, "select * from db Where id = <ID>";) } My problem is to split the select-statement and insert the current id. How can I handle this
2017 Oct 16
1
ROC curve for each fold in one plot
Hi all, I have tried a 5 fold cross validation using caret package with random forest method on iris dataset as example. Then I need ROC curve for each fold: > set.seed(1) > train_control <- trainControl(method="cv", number=5,savePredictions = TRUE,classProbs = TRUE) > output <- train(Species~., data=iris, trControl=train_control, method="rf") >
2017 Nov 13
2
Where to get support for Rserve?
Hello, I'm using Rserve with Java and although it works OK for 50 or 60 requests, eventually Rserve simply stops responding and I have to force-quit and restart Rserve. During this time the JVM is fine and Tomcat (app server) is fine, too. The basic Java code does this: -------------------------------------------- 1. Create an R Connection 2. Execute an R Script via Rserve "eval"
2013 Jul 22
2
union of a list of logical values
Dear all, How can I obtain the union of a list of logical values? Consider the following: x <- head(iris) x[,c(2,4)] <- NA x[c(2,4),] <- NA # > x # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 NA 1.4 NA setosa # 2 NA NA NA NA <NA> # 3 4.7 NA 1.3
2017 Sep 15
1
Regarding Principal Component Analysis result Interpretation
First, see the example at https://isezen.github.io/PCA/ > On 15 Sep 2017, at 13:43, Shylashree U.R <shylashivashree at gmail.com> wrote: > > Dear Sir/Madam, > > I am trying to do PCA analysis with "iris" dataset and trying to interpret > the result. Dataset contains 150 obs of 5 variables > > Sepal.Length Sepal.Width Petal.Length
2004 Jun 24
0
tree model with at most one split point per variable
I would like to create a tree model with at most one split point per variable using tree, rpart or other routine. Its OK if a variable enters at more than one node but if it does then all splits for that variable should be at the same point. The idea is that I want to be able to summarize the data as binary factors with the chosen split points. I don''t want to have three level or more
2017 Oct 30
1
Pass Parameters to RScript?
Is it possible to pass parameters to an R Script, say, from Java or other language? I did some searches, but came up blank. Thanks very much in advance, Sent from [ProtonMail](https://protonmail.com), Swiss-based encrypted email. [[alternative HTML version deleted]]
2017 Sep 15
2
Regarding Principal Component Analysis result Interpretation
Dear Sir/Madam, I am trying to do PCA analysis with "iris" dataset and trying to interpret the result. Dataset contains 150 obs of 5 variables Sepal.Length Sepal.Width Petal.Length Petal.Width Species 1 5.1 3.5 1.4 0.2 setosa 2 4.9 3.0 1.4 0.2