565 search results for "SQL"

What to Expect?

January 22, 2010
By
What to Expect?

In 2007, I was introduced to Twitter via the written qualifying exam towards my Ph.D.. At first, I did not know what to do with it. After a good year or so (maybe even sooner) passed, I began to follow some very interesting people that share the same interests as me. It has transformed my academic experience. It is...

Read more »

Connecting to a DB2 database from R

January 16, 2010
By
Connecting to a DB2 database from R

Unlike RMySQL and RSQLite there is no RDB2. However, I found it pretty straightforward connecting to a DB2 database using the JDBC driver and the RJDBC package. For all this to work, DB2 should be setup to use TCPIP, which is not used by default. You need to set the DB2COMM DB2 environment variable to

Read more »

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 »