r

I would like to bulk insert a csv file into a MySQL 5.5 table that I create with the sqlSave() command in the RODBC package. I use sqlSave() to…

I intend to use "foreach" to uitlize all the cores in my CPU. The catch is i need to send a sql query inside the loop. The script is working fine…

First of all, this may need to be moved to superuser. I couldn't decide which venue was better. I am trying to write an R script that will run at…

I currently have a dataset which has two columns that I'd like to compare. In one column, I have a string that I'd like to search for (let's call it…

R relative newbie here. I wanted to either run a dbApply or apply a custom rJava function to a particular column (say the len_diff column, on all…

I am trying to insert a data.frame in the MySQL database using RODBC. The command I am using is the following:…

I am using R function ftpUpload, while when I upload the file to the website that I found the old one in the website cannot be overwritten.…

I am working with large datasets (10s of millions of records, at times, 100s of millions), and want to use a database program that links well with…

I have a access file on server which my colleagues will update it regularly and sometimes I need to analyze the data by the following method:…

I am using regular expression in R with the following code: > temp <- c("Herniorrhaphy, left inguinal", "Herniorrhaphy, right inguinal") >…

Hello, I have data in R that can look like this: USDZAR Curncy R157 Govt SPX Index In other words, one word, in this case a Bloomberg security…

I am looking for an elegant way of returning back references using regular expressions in R. Le me explain: Let's say I want to find strings that…

Does anyone know how to achieve that? I am assuming that RJDBC would help; but from my (likely naive) understanding, a bit of tweaking is necessary…

So " xx yy 11 22 33 " will become "xxyy112233". How can I achieve this?

Lets say I have the following string vector: x <- c("this!", "is!", "not my name[!]!", "Understrand[!] Mate!", "Because!I[!] said so!") I need a…

Hello. My question is the following : I have a file "table.sql" corresponding to one table. I want to use it in R and I want to use RSQLite. Is it…

I am trying to connect to R using RODBC. However, when I run ch <- odbcConnect("rails_dev", uid="skline", pwd="d0gsleep") I get this error: In…

I've installed R2.13 and MySQL's workbench, server and client. But when I tried accessing MySQL via R from the following codes: require(RMySQL) it…

I've been playing around with the R interface to the redis database , as well as the doRedis parallel backend for foreach . I have a couple of…

I have a python/R script, that uses both Python and R to compute a figure. The actual figure is generated by R and it can be stored as a PNG image.…