similar to: Reg : Using RJDBC to read UTF-8 characterrs

Hi R-helpers, i am using the following dataset.This dataset is stored in a mysql database. W(x) pH(y) 10 1 15 1 20 4 5 7.5 3 13 9 5 11.5 13.5 3 16 2 1 9.6 1 I am using RJDBC package to read the data from the database into a dataFrame.The commands used are, jdbcDriver<-JDBC(driverClass="com.mysql.jdbc.Driver",

Hi, Being a novice this is my first usage of R. I am trying to use rpart for building a decision tree in R. And I have the following dataframe Outlook Temp Humidity Windy Class Sunny 75 70 Yes Play Sunny 80 90 Yes Don't Play Sunny 85 85 No Don't Play Sunny 72 95 No Don't Play Sunny 69 70 No Play Overcast 72 90 Yes Play Overcast 83 78 No Play Overcast 64 65 Yes Play Overcast 81 75

Hi, I have a problem with an invalid variable type. My sample dataset is looking like this: > str(factivaTDM.train) 'data.frame': 4 obs. of 14 variables: $ access : num 2 3 2 1 $ billion : num 2 1 2 2 $ compani : num 7 6 1 2 $ data : num 6 2 3 4 $ inc : num 5 3 3 2 $ local : num 3 2 1 1 $

Hi , I am using R 2.11.1 . I need to download few packages for the same for Windows.But in CRAN i see the latest packages for R 2.12.1 only. Can you help me out with the locations where i can find the packages for R 2.11.1 Windows zip? Thanks in advance -- View this message in context: http://r.789695.n4.nabble.com/R-packages-for-R-2-11-1-tp3178633p3178633.html Sent from the R help mailing

Hi, I have seen that R has a implementation of decision trees; however, after I have the tree with the classification: R Quinlan's trivial example of the "golf" decision tree. Outlook Temperature Humidity Windy PlayDontPlay 1 sunny 85 85 false DontPlay 2 sunny 80 90 true DontPlay 3 overcast 83 78 false Play 4 rain 70 96 false Play ... What's next? I mean, what is this

See ?rpart.control. I get: > golf.rp = rpart(Outlook ~ ., golf, control=rpart.control(minsplit=1)) > golf.rp n= 14 node), split, n, loss, yval, (yprob) * denotes terminal node 1) root 14 9 rain (0.2857143 0.3571429 0.3571429) 2) Temperature< 71.5 6 2 rain (0.1666667 0.6666667 0.1666667) 4) Temperature< 64.5 1 0 overcast (1.0000000 0.0000000 0.0000000) * 5)

Newbie question, but I've checked archives etc. Am trying to reproduce in R Quinlan's trivial example of the "golf" decision tree. The data file of 14 examples follows (read in via read.table()): Outlook Temperature Humidity Windy PlayDontPlay 1 sunny 85 85 false DontPlay 2 sunny 80 90 true DontPlay 3 overcast 83 78 false Play 4 rain 70 96 false Play 5 rain 68 80 false Play 6

After installing RJDBC on RedHat Linux and using it successfully with mySQL JDBC driver i am trying to use it with Oracle database. I use the JDBC driver that works fine elsewhere (use it in DBVizualizer). However, when i try to load the driver, drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/home/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`") it gives me

Hi, I'm working with R on Cassandra and need to install RJDBC on my Ubuntu virtual machine. The traditional commands (install.packages(RJDBC, dep=TRUE) and library(RJDBC)) don't work: they throw an error that they can't find the package. I tried installing it using the Rkward GUI, but can't write to any of the pre-set directories because of permissions issues. When I try running

Dear all Backend is Ingres DBMS I use RJDBC with Ingres JDBC driver I have this csv file "","Strategy","par1","m.1997.09.01" "1","ALF",2,0.1244 which I try to load it RJDBC require (RJDBC) drv <- JDBC("com.ingres.jdbc.IngresDriver","/home/ingres/ingresv1/ingres/lib/iijdbc.jar") conn <- dbConnect(drv,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Rjdbc consistently gives me an execution error with postgresql 9.0s JDBC4 driver. It's probably something trivial so am including my code below: library("RJDBC") param <- 249 param2 <- 188129 postgres <- JDBC("org.postgresql.Driver", ".m2/repository/postgresql/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar") con <- dbConnect(postgres,

Hi R-helpers , can you please let me know the methods in which NULL values can be handled in R? Are there any generic commands/functions that can be given in a workspace,so that the NULL values occuring in that workspace (for any datasets that are loaded , any output that is calculated) , are considered in the same way? Thanks in advance. -- View this message in context:

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Hi List, I am reading table from postgres database into R session using RJDBC, table contains 150 columns and 200000 rows. Sample code is as below, which works fine with smaller tables. ######################################################################## db_driver <- mydir$db_driver db_jar_file <- mydir$db_jar_file db_server <- mydir$db_server db_server_lgn <- mydir$db_server_lgn

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv,

I would like to set up a Windows XP environment with R and MySQL. This set-up was recommended by a friend who uses this set up, but I have been unable to get RJDBC to work. I have installed all of the software today (June 2 2008), first deleting and then replacing old versions of software. The error is as follows: Error in .jfindClass(as.character(driverClass)[1]) : class not found This error

I am running a simple SQL SELECT statement that involvs 50k + data points using R and the RJDBC interface. I am facing very slow response times in both the RGUI and the R console. When running this SQL statement directly in a SQL client I have processing times that are a lot lot faster (which means that the SQL statement itself is not the problem). Did any of you compare RJDBC vs RMySQL or is

Dear List, Java Exception error while reading large data in R from DB using RJDBC. I am trying to read large data from DB table(Vectorwise), using RJDBC connection. I have tested the connection with small size data and was able to fetch DB tables using same connection(conn as in my code). Please suggest where am i going wrong or alternate option to solve such issues while reading large DB