561 search results for "sql"

Handling Large CSV Files in R

A follow-up of my previous post Excellent Free CSV Splitter. I asked a question at LinkedIn about how to handle large CSV files in R / Matlab. Specifically, Quotationsuppose I have a large CSV file with over 30 million number of rows, both Matlab / R lacks memory when importing the data. Could you...

Read more »

Save R plot as a BLOB

July 30, 2010
By

I recently posed a question on stackoverflow on whether anyone knew an efficient way to save an R plot to a MySQL database as a BLOB. My plan was to use my personal desktop to perform R routines and save them to a web server, where they could then be accessed and displayed on

Read more »

Pie Charts in ggplot2

July 29, 2010
By
Pie Charts in ggplot2

...and other isomorphic data shape presentations...The Pie Chart has been widely criticized in recent times by statisticians.  Edward Tufte goes as far as to call this the "prevailing orthodoxy."  The reasons generally cited:The rel...

Read more »

Hacker News User Base Changed?

July 26, 2010
By
Hacker News User Base Changed?

There are lots of references on Hacker news to the fact that the "good old days" are gone and that the character of the site has changed since it started.  The visualization above was based on a sample of users that posted on the site in recent ti...

Read more »

Analyze Online R User Conference Data

July 19, 2010
By
Analyze Online R User Conference Data

The R User Conference 2010 will be underway shortly - and what better way to commemorate the event than to  blast out some R code related to the conference?  HTML tables on websites for the past three years list participants an...

Read more »

In case you missed it: June Roundup

July 16, 2010
By

Wow, is it the middle of July already? Anyway, in case you missed them, here are some articles from June of particular interest to R users. We noted that the program for the annual R user conference, useR! 2010, has been announced. (I and the rest of the Revolution team are looking forward to seeing all the R folks...

Read more »

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 »