574 search results for "SQL"

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 »

Factors are not first-class citizens in R

September 23, 2014
By
Factors are not first-class citizens in R

The primary user-facing data types in the R statistical computing environment behave as vectors. That is: one dimensional arrays of scalar values that have a nice operational algebra. There are additional types (lists, data frames, matrices, environments, and so-on) but the most common data types are vectors. In fact vectors are so common in R Related posts:

Read more »

Webinar September 25: Data Science with R

September 19, 2014
By

A quick heads up that if you'd like to get a great introduction to doing data science with the R language, Joe Rickert will be giving a free webinar next Thursday, September 25: Data Science with R. Regular readers of the blog will be familiar with Joe's posts on this topic. A few recent examples include posts on comparing...

Read more »

Princess Jasmine’s Trick

September 12, 2014
By
Princess Jasmine’s Trick

I’m history! No, I’m mythology! Nah, I don’t care what I am; I’m free hee! (Genie, when he is released from the magical oil lamp by Aladdin) A long time ago, in a kingdom far away, lived a beautiful princess named Jasmine. There also lived a very rich and evil wizard named Jafar, who was

Read more »

4 new R jobs (for September 10th 2014) and a new “about us” video

September 10, 2014
By
4 new R jobs (for September 10th 2014) and a new “about us” video

This is the bimonthly R Jobs post (for 2014-09-10), based on the R-bloggers’ sister website: R-users.com. This time, I’d like to start by thanking Jeff Weakley (more on Jeffat the end of this post) for his huge help in producing the following short (1:30 minutes) video about R-users: If you are an employer who is looking to hire people from the R community, please visit this...

Read more »