591 search results for "sql"

Rosetta language popularity

March 13, 2010
By

Rosetta Code is a community wiki which presents how to solve various programming tasks by different programming languages. Thus, it serves as a dictionary between programming languages, but also as cookbook of programming recipes for a specific language.One unsolved (until today) programming task for R was to rank languages by popularity. I worked on it using the...

Read more »

InformationWeek on Urlocker

March 5, 2010
By

InformationWeek published today a profile of Zack Urlocker, the former MySQL executive who recently joined REvolution's board: Former MySQL staffer Zack Urlocker is going to try to do for predictive analytics what he once did for relational database systems: bring open source code to a user population that hasn't necessarily had access to the technology before. REvolution Computing of...

Read more »

Mexico’s Economy

February 22, 2010
By
Mexico’s Economy

Yesterday the INEGI released the GDP figures for 2009, and since it was an annus horribilis for Mexico, I thought I'd put up a couple of charts. Looking through the Banco de Información Económica I found two series of historical seasonally adjusted GDP data available: GDP in 1993 pesos going from 1980 to 2007 GDP in 2003 pesos going...

Read more »

Mexico’s Economy

February 22, 2010
By
Mexico’s Economy

Yesterday the INEGI released the GDP figures for 2009, and since it was an annus horribilis for Mexico, I thought I'd put up a couple of charts. Looking through the Banco de Información Económica I found two series of historical seasonally adjusted GDP data available:GDP in 1993 pesos going from 1980 to 2007 GDP in 2003 pesos going...

Read more »

Package Update Roundup: Dec 2009 – Jan 2010

February 9, 2010
By

A special double edition of the Package Update Roundup this month! This is a list of new or updated packages that were released for R in December and January, as announced on the r-packages mailing list. To include other updates on this list, please email David Smith. For a complete list of all updates on CRAN, see the CRANberries...

Read more »

In case you missed it: January roundup

February 2, 2010
By

In case you missed them, here are some articles from last month of particular interest to R users. This post linked to slides and video from a 30-minute "Introduction to R" talk I gave on January 28, with links to many useful R resources. This post brought news that R's creators Robert Gentleman and Ross Ihaka have jointly won...

Read more »

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 »