583 search results for "sql"

In case you missed it: December roundup

January 12, 2010
By

In case you missed them, here are some articles from last month of particular interest to R users. This post looked at a climate change controversy involving the weather in Darwin, Australia and a review of the source data using R. This post showed how to access global weather data from the US National Centers for Environment Prediction using...

Read more »

Pivot tables in R

January 9, 2010
By
Pivot tables in R

A common data-munging operation is to compute cross tabulations of measurements by categories. SQL Server and Excel have a nice feature called pivot tables for this purpose. Here we'll figure out how to do pivot operations in R.Let's imagine an experim...

Read more »

Learning R via Python…or the other way around (with video!)

January 8, 2010
By

Last night I was one of five speakers at the NYC R Statistical Programming Meetup. The topic last night was dubbed the R Rosetta Stone, and the intent was to show how R as a language translated into several other analytical platforms and programming languages. Other speakers covered MATLAB, SAS, SQL/Postges and Clojure/Incanter—I

Read more »

Samples per series/dataset in the NCBI GEO database

January 7, 2010
By
Samples per series/dataset in the NCBI GEO database

Andrew asks: I want to get an NCBI GEO report showing the number of samples per series or data set. Short of downloading all of GEO, anyone know how to do this? Is there a table of just metadata hidden somewhere? At work, we joke that GEO is the only database where data goes in,

Read more »

Announcing r-ORM: A Pure R Object-Relational Mapper

January 5, 2010
By

My apologies for the long break between posts. Before the end of this week I’ll return to my series of posts on image processing in R. In the intervening time, I’ve finished a piece of code that I’d like to officially release to the public. The code in question is a very minimal object-relational mapper

Read more »

got R? get social science for R!

December 19, 2009
By

Drew Conway has a great list of 10 must-have R packages for social scientists. If you’re a social scientist (or really, any kind of scientist) who doesn’t use R, now is a great time to dive in and learn; there are tons of tutorials and guides out there (my favorite is Quick-R, which is incredibly

Read more »

Joining data frames in R

December 17, 2009
By
Joining data frames in R

Want to join two R data frames on a common key? Here's one way do a SQL database style join operation in R.We start with a data frame describing probes on a microarray. The key is the probe_id and the rest of the information describes the location on t...

Read more »

Must-Have R Packages for Social Scientists

December 11, 2009
By
Must-Have R Packages for Social Scientists

After recently having to think critically about the value of various R packages for social science research, I realized that others might find value in a post on “must-have” R packages for social scientists. After the immensely popular post on this topic for Python packages a follow-up seemed appropraite. If you conduct social

Read more »

How R is disrupting a billion-dollar market

December 4, 2009
By

Zack Urlocker, the EVP for Products at MySQL before it was acquired by Sun (and now an executive at Sun) has written an article at InfoWorld suggesting that the recent rash of articles looking at how IBM's acquisition of SPSS is affecting the BI market dominated by SAS are downplaying the real agent of change in the space: R....

Read more »

Loading Big (ish) Data into R

November 24, 2009
By
Loading Big (ish) Data into R

So for the rest of this conversation big data == 2 Gigs. Done. Don’t give me any of this ‘that’s not big, THIS is big’ shit. There now, on with the cool stuff: This week on twitter Vince Buffalo asked about loading a 2 gig comma separated file (csv) into R (OK, he asked about tab

Read more »