586 search results for "SQL"

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 environment ...

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 »

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 enhancement r...

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 »

Wrangling F1 Data With R – F1DataJunkie Book

October 30, 2014
By
Wrangling F1 Data With R – F1DataJunkie Book

Earlier this year I started trying to pull together some of my #f1datajunkie R-related ramblings together in a book form. The project stalled, but to try to reboot it I’ve started publishing it as a living book over on Leanpub. Several of the chapters are incomplete – with TO DO items sketched in, others are

Read more »

Some R Highlights from the Bay Area Data Science Camp and Unconference

October 30, 2014
By
Some R Highlights from the Bay Area Data Science Camp and Unconference

by Joseph Rickert The San Francisco Bay Area Chapter of the Association of Computing Machinery (ACM) has been holding an annual Data Mining Camp and "unconference" since 2009. This year, to reflect the times, the group held a Data Science Camp and unconference, and we at Revolution Analytics were, once again, very happy to be a sponsor for the...

Read more »