1126 search results for "sql"

SQLite as an alternative to shapefiles, and some GPS fun in R

May 24, 2010
By

Finally made it out to Folsom Lake for a fine day of sailing and GPS track collecting. Once I was back in the lab, I downloaded the track data with gpsbabel, and was ready to import the data into GRASS. # import GPX from GPS: gpsbabel -t -i...

Read more »

MySQL alum Zack Urlocker join’s REvolution’s board

March 2, 2010
By

As you might have heard from this morning's press release, we've just welcomed a new member to REvolution's board of directors: Zack Urlocker. Zack has an impeccable open-source pedigree: until recently, he was responsible for engineering and marketing at MySQL, the wildly successful open-source database company recently acquired by Oracle (via its acquisition of Sun). Zack is also a...

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 »

SQL group by in R

December 27, 2009
By
SQL group by in R

The R statistical computing environment is awesome, but weird. How to do database operations in R is a common source of questions. The other day I was looking for an equivalent to SQL group by for R data frames. You need this to compute summary statist...

Read more »

RPostgreSQL 0.1-6

October 19, 2009
By

A quick bug fix released of RPostgreSQL was uploaded to CRAN earlier today; it updates last week's 0.1-5 release. An editing error left one of the helper functions broken. I also updated a few of the test scripts to also allow for optional environmen...

Read more »

RPostgreSQL 0.1-5

October 13, 2009
By

A new version of RPostgreSQL just went out to CRAN and should propagate via the mirrors over the next few days. This is a maintenance and bug fix release that addresses four of the seven issue at the Google Code page. Two more are really enhancemen...

Read more »

Parsing GEO SOFT files with Python and Sqlite

July 17, 2009
By
Parsing GEO SOFT files with Python and Sqlite

NCBI's GEO database of gene expression data is a great resource, but its records are very open ended. This lack of rigidity was perhaps necessary to accommodate the variety of measurement technologies, but makes getting data out a little tricky. But, a...

Read more »

open-source campaign finance analysis with R and MySQL

June 18, 2009
By
open-source campaign finance analysis with R and MySQL

Introduction In Part 1 of this tutorial we introduced the fechell library by extracting all itemized contributions from individuals made to the Obama For America campaign in 2007 and 2008. In Part 2 of the tutorial we will summarize that data set by importing it into a MySQL database and aggregating contributions by week and

Read more »

Choosing an SQL Engine for Analytics

March 9, 2009
By
Choosing an SQL Engine for Analytics

I’ve been struggling for a while on which database to use for my working data. I used to use MS Access quite a lot. The problems with MS Access include but are not limited to: 2 GB file size limit, at least historically Versions change with each edition of MS Office Sort of tough to write SQL scripts Very

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)