562 search results for "SQL"

Connecting to SQL Server from R using RJDBC

September 22, 2010
By
Connecting to SQL Server from R using RJDBC

A few months ago I switched my laptop from Windows to Ubuntu Linux. I had been connecting to my corporate SQL Server database using RODBC on Windows so I attempted to get ODBC connectivity up and running on Ubuntu. ODBC on Ubuntu turned into an exercise in futility. I spent many hours over many days

Read more »

R SQL-ish aggregation

September 10, 2010
By
R SQL-ish aggregation

I came to R from SQL. I’ve heard that packages such as reshape and plyr are quite beautiful, but to me they are somewhat non-intuitive. I’m always looking for SELECT mean(sodium) as mean, variance(sodium) as var FROM texas GROUP BY … Continue reading →

Read more »

Make R speak SQL with sqldf

July 5, 2010
By
Make R speak SQL with sqldf

The R community is unique as programming communities go.  Many users of R come from academia and have a relatively extensive mathematical background.  The R community has developed in relative isolation from some other areas of programming th...

Read more »

Connecting Revolution R to MySQL on Windows

June 4, 2010
By

My colleague Saar Golde was having some troubles connecting Revolution R to MySQL on Windows (64-bit). Turned out the problem was the lack of an environment variable. He documented the instructions for fixing the problem on Windows 7, below. Thanks, Saar! The Problem: A client is about to send me a couple of large MySQL tables, so I needed...

Read more »

MLB Baseball Pitching Matchups ~ manipulating pitch f/x data using the RMySQL package in R

May 31, 2010
By
MLB Baseball Pitching Matchups ~ manipulating pitch f/x data using the RMySQL package in R

After downloading some pitch f/x data using my R script, we can finally have some fun. But because the pitch f/x data is very elaborate, R can easily get overwhelmed by copying the dataset back and forth in memory, as you manipulate the data. So the natural progression is to use relational database systems. Here,

Read more »

Use SQL queries to manipulate data frames in R with sqldf package

May 25, 2010
By

I've covered a few topics in the past including the plyr package, which is kind of like "GROUP BY" for R, and the merge function for merging datasets. I only recently found the sqldf package for R, and it's already one of the most useful packages I've ever installed. The main function in the package is sqldf(), which takes...

Read more »

SQLite as an alternative to shapefiles, and some GPS fun in R

May 24, 2010
By

Finally made it out to Folsom Lake for a fine day of sailing and GPS track collecting. Once I was back in the lab, I downloaded the track data with gpsbabel, and was ready to import the data into GRASS. # import GPX from GPS: gpsbabel -t -i...

Read more »

MySQL alum Zack Urlocker join’s REvolution’s board

March 2, 2010
By

As you might have heard from this morning's press release, we've just welcomed a new member to REvolution's board of directors: Zack Urlocker. Zack has an impeccable open-source pedigree: until recently, he was responsible for engineering and marketing at MySQL, the wildly successful open-source database company recently acquired by Oracle (via its acquisition of Sun). Zack is also a...

Read more »

Coming to R from SQL, Python, SAS, Matlab, or Lisp

January 18, 2010
By

Head over to Revolutions Blog for a list of PDF and powerpoint resources for making the transition to R from other programming or stats languages.  All of these notes come from the New York R meetup. I enjoyed browsing the meetup's files - lots of powerpoints, PDFs, and example R data files for various topics, including several slideshows on...

Read more »

Data munging with SQL and R (Rosetta Stone Talk – 3/3)

January 17, 2010
By

Presentation given by Josh Reich at the NYC R Statistical Meetup on January 7, 2010. The January Meetup was the "R Rosetta Stone," and this talk covers R, SQL and Postgres.

Read more »