Articles by stathack

Getting started with twitteR in R

June 13, 2013 | stathack

I have asked by a few people lately to help walk them through using twitter API in R, and I’ve always just directed them to the blog post I wrote last year during the US presidential debates not knowing that Twitter had changed a few things. Having my interest ... [Read more...]

UPDATE Multiple postgreSQL Table Records in Parellel

February 27, 2013 | stathack

Unfortunately the RpostgreSQL package (I’m pretty sure other SQL DBs as well) doesn’t have a provision to UPDATE multiple records (say a whole data.frame) at once or allow placeholders making the UPDATE a one row at a time ordeal, so I built a work around hack to ... [Read more...]

Opening Large CSV Files in R

December 26, 2012 | stathack

Before heading home for the holidays, I had a large data set (1.6 GB with over 1.25 million rows) with columns of text and integers ripped out of the company (Kwelia) Database and put into a .csv file since I was going to be offline a lot over the break. I tried ... [Read more...]

Building a Simple Web App using R

November 13, 2012 | stathack

I’ve been interested in building a web app using R for a while, but never put any time into it until I was informed of the Shiny package.  It looked too easy, so I absolutely had to try it out. First you need to install the package from the ... [Read more...]

Top Facebook Posts During the US Presidential Debate

October 22, 2012 | stathack

The following data was collected during the Presidential Debate on the 22nd of October by tapping into the Facebook social graph API using R. The top three posted links during the debate for each candidate are: Obama- #1 #2 #3 ... [Read more...]

Twitter Analysis of the US Presidential Debate

October 17, 2012 | stathack

The following are word clouds of tweets for each candidate from the October 16, 2012 debate with the bigger words the more often they were used in tweets (click on each word cloud to enlarge): And the net-negative posts for each candidate: Please note that the bigger the word is in the ... [Read more...]

Minute by Minute Twitter Sentiment Timeline from the VP debate

October 12, 2012 | stathack

Click on above graph to enlarge. Background The data for this graph was collected automatically every ~60 seconds of the VP debate on 10/11/2012, with an ending aggregate sample size of 363,163 tweets.  From this dataset duplicate tweets were removed (because of bots), which gave a final dataset of 81,124 remaining unique tweets (52,303-Biden, 28,821... [Read more...]

Presidential Candidate Sentiment Analysis

October 7, 2012 | stathack

After watching the Presidential debates and hearing all the opinions on how the candidates performed, I got the hair brained idea of creating a simple function that would do automate the pulling down of tweets for each candidate, analyze the positivity or negativity of tweets, and then graph them out. ... [Read more...]

Querying a database from within R

August 18, 2012 | stathack

For a while now I have been contemplating pulling data from our postgreSQL db directly from R, but just never actually pulled the trigger until today.  What I found was that it was a lot easier than I ever could have imagined.  My laptop was already on the VPN, so ... [Read more...]

Fun with geocoding and mapping in JGR

July 31, 2012 | stathack

For a recent project I had to do some mapping of addresses, but I didn’t have there lat/lons do use the Deducer and DeducerSpatial packages in R JGR.  After frustrating myself trying to adapt this code from, I found a much easier way of geocoding using ... [Read more...]

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)