There has been recent interest in the attention that Oracle has been giving to R. This has been related to the use of Oracle Data Mining which is a paid option to Oracle. This is the first in a series of posts that can be run using the Orac...
380 search results for "SQL"
New versions of plyr, ggplot2 released
Hadley Wickham has announced that new versions of his popular grammar-of-graphics charting package ggplot2 and his general-purpose data reshaping tool plyr for R are now available. plyr boasts several new features, most notably a new join function which should simplify what can sometimes be a difficult process in R: merging two data sets. A simplified SQL-like terminology should make...
New versions for ggplot2 (0.8.8) and plyr (1.0) were released today
As prolific as the CRAN website is of packages, there are several packages to R that succeeds in standing out for their wide spread use (and quality), Hadley Wickhams ggplot2 and plyr are two such packages. And today (through twitter) Hadley has updates the rest of us with the news: just released new versions of plyr and ggplot2. source...
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...
Analyze Gold Demand and Investments using R
After the recent foray into stock analysis using quantmod, I thought it worthwhile to mention that the library can be used to analyze a wide variety of investments, including precious metals. It is also worthwhile to mention that there are other ...
Analyzing competitive nordic skiing with R
Here's another great example of R being used to analyze sports data. Statistician and skier Joran Elias has started a project to analyze and visualize international cross country ski racing results, and he publishes his analysis at the blog Statistical Skier. All of the analyses are done using R (and for data, SQLite via the RSQLite package). As much...
PostGIS in Action Book Review
I was recently asked to review a soon to be published book on PostGIS, a spatial extension to the very popular Postgresql relational database. I was very excited about receiving an early copy of this book, as the authors have provided countless tips, ...
Connecting Revolution R to MySQL on Windows
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...
Data preparation for Social Network Analysis using R and Gephi
I want to share my experience in generating the data for social network analysis using R and analyzing it using Gephi... WHICH DATA STRUCTURE TO USE FOR LARGE GRAPHS?I quickly realized that using edge lists and adjacency matrix gets difficult as the g...
MLB Baseball Pitching Matchups ~ grabbing pitcher and/or batter codes by specify game date using R XML
MLB Gameday stores its game data in XML format, with the players denoted in ID numbers. To find out who is who, the codes are stored in pitchers.xml or batters.xml of each game. My DownloadPitchFX.R script can download the ID numbers, but it doesn’t look to see who the ID is because of the extra 
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
