similar to: Help with R and MySQL

(Apologies the previous version was sent as rich text) Hello, I'm new to R, but I've read the intro to R and successfully connected it to an instance of mysql. I'm trying to perform multiple linear regression, but I'm having trouble using the lm function. To start, I have read in a simply y matrix of values(dependent variable) and x matrix of independent variables. It says both

Sorry for the somewhat nondescript subject line, but I have two questions: 1. What is a really good book on R for a nonprogrammer? 2. How do I open more than one R Graphics: Device 2(ACTIVE). That what is the R command that I can use to keep more than one plot open. I am running a script from a book on Chemometrics that results in more than one graph during the execution, but

Hello all, Is there an easy way to get the human-readable opcode mnemonic (e.g., "MOV32ri64", "CMP32ri8", "JLE_1") for a MachineInstr? I am writing a backend analysis pass for security research, where the idea is for a researcher to examine the output of my pass and identify instructions from it for use in an attack. Right now I'm representing unique

I am trying to add a Samba 2.0.7 box to an existing domain. The Samba box will not be a domain controller; it's just going to be a nondescript member of the domain. The primary domain controller is running Windows 2000, but is also configured to emulate an NT4 PDC. Our system administrators did their side of things, and told me that user "domain\liblit" now has permission to add

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

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no such file" error, but all the files do exist, RMySQL.so and

R-help list, I ported some R code from MS Windows PC to sun-solaris. Both do queries on the same MySQL database. PC version of R is 1.6.1 and solaris version is 1.6.0. I use RMySQL_0.5-0 (on solaris) and RODBC 1.0-1 on PC to connect to MySQL. The PC version took about 65 mins. to run wheras the Solaris (SunOS 5.7) version took 375 mins. (> 6 hrs). R and RMySQL are resident on the same host

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

Dear List, I have this little problem: I work with adiacency matrix like: data me you me 0 1 you 1 0 I store those matrix in a mysql database actually I use RMySQL with: res<-dbSendQuery(connection, "SELECT * FROM table") myDataFrame<-fetch(res) to retrive the table, and I have data me you 1 io 0 1 2 tu 1 0 I would like the first column to be seen

Hi, I've run into a bit of a problem with using the RMySQL library. I've been attempting to create a temporary table in a MySQL database and then perform a SELECT with a WHEREs clause on the table. In effect perform a SELECT with a subSELECT. The problem is that it never seems to be able to find the table after I create it. I've been using the dbSendQuery method to create the table

Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter

I am trying to use R interfaced with MySQL. Present goal is that R should calculate the 85% quantile of AvgSpeed for each LinieID. Looking through documentation of the RMySQL Package, I guessed that dbApply would do the trick due to this example ## compute quanitiles for each network agent con <- dbConnect(MySQL(), group="vitalAnalysis") res <- dbSendQuery(con,

It seems that the dbReadTable() method provided by RMySQL could not get rid of the headers, neither the index column... So 1. Can I use read.table() method to get a table of MySQL database? >From the help document the argument of 'file' of read.table() method could be a connection... 2. How can I obtain a matrix from the database table contains all elements except the headers and the

I've seen several examples that use extensions such as; s-BUSY s-NOANSWER etc... It's more or less evident what they do, but I've searched for some FORMAL documentation everywhere and have found nothing. Do they work for anything else than "s-"? (I think I've seen other examples, but can't find them now) Are they standard in any way? What are the allowed values

Hi, I would like to access a local mysql database. In python using the sqlite3 library it is quite straightforward. I just have to pass the path to the sqlite-file; sqlite3.connect('.../xy.sqlite') Is there something similar in R (or specifically in the RMySQL package)? It seems like I have to use the MySQL function in the RMySQL package in order to ... "initializes a MySQL

Dear R community, I tried to optimized my R code by using Rprof. In my R code I'm using MySQL database connections intensively. After a bunch of queries R fails with the following error message: Error in .Call("RS_MySQL_newConnection", drvId, con.params, groups, PACKAGE = .MySQLPkgName) : RS-DBI driver: (could not connect mylogin@mydatabase on dbname "myDB"

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30

Hello, I would like to retrieve data stored in MySQL database, so I installed RMySQL package. I can successfully connect with the my database using the following code > dvr<-dbDriver("MySQL") > con2<-dbConnect(dvr,group="exbardiv") > mysqlDescribeConnection(con2) <MySQLConnection:(972,0)> User: mmorag Host: localhost Dbname: exbardiv

Hello everyone, I have a problem when I execute queries using R 2.3.1 and MySql server 5.0. What I do: I load data in different csv files (every file represents a particular temporal step of a simulation) using Mysql query "load data" with RMySQL command DbSendQuery (but the same problem there is also using DbWritetable). Then I use a function where I have a lot of queries that interact

Hi, I have a question reading using RMySQL trying to load one R vector into a table column. To be more specifically, the table is there populated. Now I add a new column and want to populate this. Can some colleagues on this list teach me how to do this? I know how to write one R object/table into MYSQL table using dbWriteTable. But in this situation, I just want to do one column. Thanks