583 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 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 »

‘Open sourcing’ microsimulation with R

October 23, 2014
By
‘Open sourcing’ microsimulation with R

These are the slides from a presentation today at the European conference of the IMA, held in Maastricht, 23rd to 24th October, 2014. Microsimulation, as its name suggests, is about modelling things at the individual-level. In practice, this usually means estimating the characteristics of people using statistical or econometric techniques. Microsimulation, as represented by the International Microsimulation Association...

Read more »

The World We Live In #2: To Study Or To Work

October 19, 2014
By
The World We Live In #2: To Study Or To Work

I was getting ready for school and about to wear my uniform when I remembered that our principal had told us not to wear uniforms. So I decided to wear my favorite pink dress (Malala Yousafzai) After reading the diary of a Pakistani schoolgirl and Malala’s history, there is no doubt of being in front

Read more »

dplyr 0.3

October 13, 2014
By
dplyr 0.3

I’m very pleased to announce that dplyr 0.3 is now available from CRAN. Get the latest version by running: install.packages("dplyr") There are four major new features: Four new high-level verbs: distinct(), slice(), rename(), and transmute(). Three new helper functions between, count(), and data_frame(). More flexible join specifications. Support for row-based set operations. There are two

Read more »