586 search results for "SQL"

Stata or R

February 10, 2011
By
Stata or R

Recently I came across a complex model written in Access with complex SQL queries all over the place. The engineer who was maintaining it and I did some analysis and agreed that the model was using SQL in an unnatural way (things SQL isn't good at) - c...

Read more »

Merging Multiple Data Frames in R

January 23, 2011
By
Merging Multiple Data Frames in R

Earlier I had a problem that required merging 3 years of trade data, with about 12 csv files per year. Merging all of these data sets with pairwise left joins using the R merge statement worked (especially after correcting some errors pointed out by Ha...

Read more »

Posted Question for R Users

January 21, 2011
By
Posted Question for R Users

I recently undertook a project where a colleague had about 12 .csv files that they wanted to merge. Each file had a common (key) variable 'Partner' (which is trading partner) with differing columns (variables) except for the common key variable. Actual...

Read more »

R GUIs, IDEs, and text editors

January 18, 2011
By
R GUIs, IDEs, and text editors

When deciding what program to write your R code in it is important to consider a number of factors so you can keep organized and work efficiently.  I found this article useful for getting started.  Text editors include syntax highlightin...

Read more »

Winners of Mozilla Open Data Competition announced

January 12, 2011
By
Winners of Mozilla Open Data Competition announced

The winners of the Mozilla Open Data Visualization competition "How Do People Use Firefox" have been announced. The competition attracted 32 entries, each visualizing an aspect of data collected in the Mozilla Test Pilot program to reveal insights about how people use the popular open-source browser Firefox. I was honoured to be asked to participate in the judging of...

Read more »

sab-R-metrics: Introduction to R

January 5, 2011
By
sab-R-metrics: Introduction to R

In a recent post, I briefly mentioned that I may turn a majority of the focus of this blog to teaching R commands for use with sabermetric analysis. Only a few days later, Ricky Zanker began a new column at The Hardball Times doing just that. But that's okay. Hopefully both his and mine...

Read more »

sab-R-metrics: Introduction to R

January 5, 2011
By
sab-R-metrics: Introduction to R

In a recent post, I briefly mentioned that I may turn a majority of the focus of this blog to teaching R commands for use with sabermetric analysis. Only a few days later, Ricky Zanker began a new column at The Hardball Times doing just that. But that's okay. Hopefully both his and mine...

Read more »

Where to find good data sets

December 16, 2010
By

O'Reilly Media has been a big advocate of Open Data and believes that is where a lot of computing is going to be headed in the future.  I think they are definitely on to something.  Yet the future could be now.  There is a lot of opportu...

Read more »

Where to find good data sets

December 16, 2010
By

O'Reilly Media has been a big advocate of Open Data and believes that is where a lot of computing is going to be headed in the future.  I think they are definitely on to something.  Yet the future could be now.  There is a lot of opportu...

Read more »

Google AI Challenge: Scores/Rank by Language

December 8, 2010
By
Google AI Challenge: Scores/Rank by Language

A quick follow up to the previous post: about the the scores in the 2010 Google AI competition relative to programming language.  The chart above makes each language visible and discrete - and the scales are the same.library(ggplot2)df<- read.c...

Read more »