similar to: Delete Comment Lines from SQL String as a Vector

I received this error Error in randomForest.default(m, y, ...) : Can not handle categorical predictors with more than 32 categories. using below code library(randomForest) library(MASS) memory.limit(size=12999) x <- read.csv("D:/train_store_title_view.csv", header=TRUE) x <- na.omit(x) set.seed(131) sales.rf <- randomForest(sales ~ ., data=x, mtry=3, importance=TRUE) My

Hi, In my application I want to have the sysdate + 5 minutes. I know that the sysdate is in the variable ${DATTIME} But now I want to now how I get the sysdate + 5 minutes into a variable? Doe's anybody knows the answer? Kind Regards Arjan Kroon -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello all. I am trying to use WINE to make a windoze-only development environment (very rudimentar, command line cross-compiler and stuff) under Linux, because GNU make is far superior from the M$'s 'nmake'. Anyway, I have some trouble with expirating licenses and stuff, and the solution is to revert the system date back to some valid thing and then compile. Since I am now running

I've installed R-2.9.2 (64 bit), unixODBC-2.2.14-p2 (64 bit) and RODBC_1.2-5 (64 bit) on a 64 bit Redhat Linux server (Red Hat Enterprise Linux Server release 5.4 (Tikanga), x86_64) release 2.6.18-164.2.1.el5. I've tested the ODBC drive via isql and the test was success: [yzhang@ROracleTest ~]$ isql -v DRTST yzhang test +---------------------------------------+ | Connected!

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package The red highlighted text below is the error I'm getting trying to when invoking a sqlQuery > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows,

We''re using migrations to manage a SQL Server project and have been running into a number of issues with db_schema_dump/migrations. Can anyone confirm that these are actual issues with the SQL Server adapter and not issues with me :) 1) Fields are not properly setup with proper null settings (:null => true / false). I''m wondering if we need to update the def columns method

I am trying to get R to run on a Red Hat 8 system, I am running R version 1.6.2 with Tcl/Tk version 8.3.5 installed. When I try to test R from the data_sets directory I get the error message; Error in firstlib(which.lib.loc, package) : Tcl/Tk support is not available on this system Error in fileBrowser(textToShow = "Choose one CDF file" , nSelect = 1, : tcl/tk library not available

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,

Hi there, given a numeric vector, I can select numbers within a specific range. However presently, I have something related but different problem. Suppose I have a numeric vector. Now take an arbitrary number. Goal to to chose a specific subset with a given length, from that given vector, so that those chosen numbers are centered around that given constant. Here is one example: ### My original

Dear list, When I try to use lines.formula with subset and another argument I get an error. e.g. x<-1:5 y<-c(1,3,NA,2,5) plot(y~x, type="n") # set up frame lines(y~x, subset=!is.na(y)) # works OK lines(y~x, type="o", col="blue") # works OK # but lines(y~x, subset=!is.na(y), col="red") # gives an error: Error in if (length(x) == l) x[s] else x :

I''m working with a legacy Oracle db which has trunc(SYSDATE) and TO_DATE(''...'',''...'') as default values for some date columns. The oracle driver craps out with these default values or sets them to the default Jan 1, 2000 date. The culprit appears to be the cast_to_time method in oracle_adapter.rb. Any pointers on how to change the driver to

On 6 December 2018 at 15:59, Ralf Stubner wrote: | On 06.12.18 15:19, Joris Meys wrote: | > I know this R CMD build ignores these files and folders by default, but R | > CMD INSTALL doesn't apparently. | | to me this is not apparent. I just tried "R CMD INSTALL ." in a package | directory with a .git directory. This went without any problems. What do | you observe? Seconded.

I have not devoted time to setting up ROracle since binaries are not available and it seems to require some effort to compile (see http://cran.r-project.org/web/packages/ROracle/index.html). On the other hand, RODBC worked more or less magically once I set up the data sources. What is your success using ROracle and why would it be preferable to RODBC ? -Avram On Thursday, September 11,

Full_Name: Christian Hoffmann Version: 2.4.0 OS: Win 2000 Submission from: (NULL) (193.134.202.252) Database queries using the combination DBI + ROracle are handicapped by quirks in the pipeline between the textual representation of the query and the database engine Oracle. Comments and linefeed at start are interfering: dbGetQuery(conn, query): works: dbGetQuery(conn, "select *

Dear all, quite a few package tools depend on R CMD INSTALL today for rapid testing of a package, eg: - devtools::install() - BiocCheck::BiocCheck() I've noticed that at least BiocCheck() doesn't ignore version control folders like .git. Trying to find out why this was, lead me to R CMD INSTALL. I know this R CMD build ignores these files and folders by default, but R CMD INSTALL

Given this data frame (a simplified, essential reproducible example) A<-c(8,7,10,1,5) A_flag<-c(10,0,1,0,2) B<-c(5,6,2,1,0) B_flag<-c(12,9,0,5,0) mydf<-data.frame(A, A_flag, B, B_flag) # this is my initial df mydf I want to get to this final situation i<-which(mydf$A_flag==0) mydf$A[i]<-NA ii<-which(mydf$B_flag==0) mydf$B[ii]<-NA

Hi all, Can anyone explain why the following use of the subset() function produces a different outcome than the use of the "[" extractor? The subset() function as used in density(subset(mydf, ht >= 150.0 & wt <= 150.0, select = c(age))) appears to me from documentation to be equivalent to density(mydf[mydf$ht >= 150.0 & mydf$wt <= 150.0, "age"])

Hello! I have a data frame with dates. I need to create a new "month" that starts on the 20th of each month - because I'll need to aggregate my data later by that "shifted" month. I wrote the code below and it works. However, I was wondering if there is some ready-made function in some package - that makes it easier/more elegant? Thanks a lot! # Example data:

Dear all, given I have data in a data.frame which indicate the number of people in a specific year at a specific age: n <- 10 mydf <- data.frame(yr=sample(1:10, size=n, replace=FALSE), age=sample(1:12, size=n, replace=FALSE), no=sample(1:10, size=n, replace=FALSE)) Now I would like to make a matrix with (in this simple example) 10 columns (for the