565 search results for "sql"

Hierarchical Visualizations in R and the Javascript InfoVis Toolkit

July 12, 2010
By
Hierarchical Visualizations in R and the Javascript InfoVis Toolkit

I love R.  It is really a great language and platform for statistical work and graphing.  But every technology has its limits - and other tools can be meet different needs.  So in this post, I will start with R and move on to the JavaScr...

Read more »

R and Oracle HR Part II – Plotting a single variable

July 9, 2010
By
R and Oracle HR Part II – Plotting a single variable

If you have not done so already, make sure you have R and Oracle setup as described in the previous article.  If so, you should be able to create a connection from R and list the tables that are available in the HR schema.library('RODBC')ch <-o...

Read more »

R and Oracle HR Part I – Set Up and Connect

July 8, 2010
By
R and Oracle HR Part I – Set Up and Connect

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...

Read more »

New versions of plyr, ggplot2 released

July 6, 2010
By

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...

Read more »

New versions for ggplot2 (0.8.8) and plyr (1.0) were released today

July 6, 2010
By
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...

Read more »

Analyze Gold Demand and Investments using R

June 29, 2010
By
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 ...

Read more »

Analyzing competitive nordic skiing with R

June 22, 2010
By
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...

Read more »

PostGIS in Action Book Review

June 8, 2010
By
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, ...

Read more »

Data preparation for Social Network Analysis using R and Gephi

June 2, 2010
By
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...

Read more »

MLB Baseball Pitching Matchups ~ grabbing pitcher and/or batter codes by specify game date using R XML

June 1, 2010
By
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

Read more »