532 search results for "SQL"

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 »

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

January 14, 2010
By

The theme of last week's meetup of the New York R User Group was The R Rosetta Stone and focused on translating between R and other data languages: SAS, Matlab, SQL, Python and Clojure. I really wish I'd been there, because it's a great topic -- one of the best ways to get started with R is to bootstrap...

Read more »