370 search results for "SQL"

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:

  1. GDP in 1993 pesos going from 1980 to 2007
  2. 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:

  1. GDP in 1993 pesos going from 1980 to 2007
  2. 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 »

Coming to R from SQL, Python, SAS, Matlab, or Lisp

January 18, 2010
By

Head over to Revolutions Blog for a list of PDF and powerpoint resources for making the transition to R from other programming or stats languages.  All of these notes come from the New York R meetup. I enjoyed browsing the meetup's files - lots of powerpoints, PDFs, and example R data files for various topics, including several slideshows on...

Read more »

Data munging with SQL and R (Rosetta Stone Talk – 3/3)

January 17, 2010
By

Presentation given by Josh Reich at the NYC R Statistical Meetup on January 7, 2010. The January Meetup was the "R Rosetta Stone," and this talk covers R, SQL and Postgres.

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 »

Coming to R from SQL, Python, SAS, Matlab, or Lisp

January 14, 2010
By

The theme of last week's meetup of the New York R User Group was The R Rosetta Stone and focused on translating between R and other data languages: SAS, Matlab, SQL, Python and Clojure. I really wish I'd been there, because it's a great topic -- one of the best ways to get started with R is to bootstrap...

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 »