568 search results for "SQL"

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 »

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 »

R tops KDNuggets data analysis software poll for 4th consecutive year

August 29, 2014
By
R tops KDNuggets data analysis software poll for 4th consecutive year

KDNuggests asked its readers the question "What programming/statistics languages you used for an analytics / data mining / data science work in 2014?" and one again, R was the #1 response. (R was also the #1 response in similar polls in 2013, 2012 and 2011.) The top 5 selections of the 719 respondents were: R (352 respondents) SAS (262)...

Read more »

Critical Data (free) Hackathon in London (Sept 6-7, 2014)

August 11, 2014
By

We would like to invite you to participate in our forthcoming Critical Data Marathon a FREE event taking place in London on 6-7 September 2014. The event is collaboratively organised between researchers at Massachusetts Institute of Technology (MIT), University College London, King’s College London, and Imperial College London.The data marathon will bring together frontline healthcare providers (nurses, pharmacists, doctors) with data scientists to...

Read more »

Social Media Mining and Bioinformatics (with R)

August 5, 2014
By
Social Media Mining and Bioinformatics (with R)

In June and July, I receive copies of two books, Social Media Mining with R, by Nathan Danneman and Richard Heimann Bioinformatics with R Cookbook, by Paurush Praveen Sinha For the first one, two recent interesting books deal with the same topic. Reza Zafarani, Mohammad Ali Abbasi and Huan Liu published last year Social Media Mining: An Introduction. Actually, the book can...

Read more »

jpmml and R (Free Webinar)

July 28, 2014
By
jpmml and R (Free Webinar)

This free, global webinar will provide an introduction to jpmml, the world’s leading open-source PMML scoring engine currently being utilized by companies such as Airbnb to rapidly deploy predictive models into production. Webinar Format: – What is PMML? – Building … Continue reading →

Read more »

Competitive balance and home court advantage in the NBA

July 6, 2014
By
Competitive balance and home court advantage in the NBA

Two years ago, the entire NBA season went into lockout because of mostly financial reasons. However, one central point was also about keeping a competitive balance within the NBA, so that large and small-market teams alike would have a chance to compete for a championship. THis brings us to the obvious question “Is there competitive

Read more »

How To: 20 Minute Guide to Get Started with PivotalR

July 1, 2014
By
How To: 20 Minute Guide to Get Started with PivotalR

In this article, Pivotal engineer and predictive analytics expert Hai Qian explains how someone new to R can get started performing statistical analysis on data stores in Greenplum Database, Pivotal HD and PostgreSQL in just 20 minutes using PivotalR. First, there is some background on R’s popularity, then the articles dives into important topics such as installation, data loading,...

Read more »