573 search results for "SQL"

quantmod makes it easy to watch silver prices crash in R #rstats

May 7, 2011
By
quantmod makes it easy to watch silver prices crash in R #rstats

Jeffrey Ryan's quantmod package makes it simple to download and graph pricing data from a variety of sources. A couple of lines of R is all it takes to see that silver has had a very bad week.

Read more »

Slides: “Accessing Databases from R” #rstats

May 7, 2011
By
Slides: “Accessing Databases from R” #rstats

For the past few meetings of the Greater Boston useR Group, we have been opened with an introductory “useR Vignette” talk on a topic which may be helpful for new R users. This week, I presented an overview of accessing databases from R. Several people have tweeted and blogged nice things about my talk and

Read more »

%EXPORT_TO_R SAS Macro Code

May 6, 2011
By
%EXPORT_TO_R SAS Macro Code

The SAS Analysis blog post 'A macro calls R in SAS for paneled 3d plotting' influenced my macro coding.   The following macro call: %EXPORT_TO_R(DATA = YOURDATA)  exports the SAS data set 'YOURDATA' as .csv and produces the R code for se...

Read more »

Is R an ideal language to teach the fundamentals of programming to beginners?

May 6, 2011
By
Is R an ideal language to teach the fundamentals of programming to beginners?

I’m helping out some colleagues learn programming from having zero experience with it in any shape or form. It’s quite a daunting task in some senses, because, well, it may not be easy! They are researchers, so they’ll need it for processing data and generating output, and perhaps processing BIG DATA at some point too.

Read more »

How to access databases from R

May 5, 2011
By

From his presentation at the Greater Boston useR Group, R user Jeffrey Breen has shared some useful slides detailing how to bring data from relational databases like MySQL and Oracle. In fact, data from just about any relational database is accessible from R by sending an SQL query to the standard ODBC or JDBC interfaces. R packages also offer...

Read more »

Using R for Map-Reduce applications in Hadoop

May 4, 2011
By

Data Scientist Antonio Piccolboni recently published this comparison of the various language and interfaces available for programming Big Data analysis tasks in the map-reduce framework. The interfaces he reviewed included: Java Hadoop (mature and efficient, but verbose and difficult to program) Cascading (brings an SQL-like flavor to Java programming with Hadoop) Pipes/C++ (a C++ interface to programming on Hadoop)...

Read more »

How to load your iPhone location data into R

April 22, 2011
By
How to load your iPhone location data into R

Earlier this week, data scientists Pete Warden and Alasdair Allen reported that iPhones and cell-enabled iPads keep an internal log of the devices location, which is accessible from the backup that iTunes creates when you sync the device. (Update Apr 27: Apple responds that the locations are those of nearby cell towers and wi-fi hotspots, not the device itself.)...

Read more »

Visualizing iPhone location tracking with R and Google Maps

April 22, 2011
By
Visualizing iPhone location tracking with R and Google Maps

Visualize location logs created by the iPhone using R and Google Maps.

Read more »

iPhone geo-tracking database

April 20, 2011
By
iPhone geo-tracking database

So the web lit up a little today with news that iPhones are collecting time-stamped location data, and in a form that isn’t particularly hard to look at (and even with some nice apps to make animated maps of your travels etc): The database is SQLite, and I used R (and the RSQLite package) to

Read more »

Aggregate Function in R: Making your life easier, one mean at a time

April 20, 2011
By
Aggregate Function in R: Making your life easier, one mean at a time

I previously posted about calculating medians using R. I used tapply to do it, but I’ve since found something that feels easier to use (at least to me). ?Download download.txt1 2 3 aggregated_output = aggregate(DV ~ IV1 * IV2, data=data_to_aggregate, FUN=median) aggregated_output The above code saves an aggregated dataset to aggregated_output and gives you the

Read more »