Recently I used another AWS service to take on repetitive work. The service is AWS SES service. I wanted to send out a email using text from an early Church Father, so that a group of recepients could recieve a quote from St. Mark the Ascetic every day. I built this using AWS simple email service and will post sometime sepeartely about the set up process. The text of St. Mark the ascetic is found on my other site: http://orthodoxriver.
Continue reading

Lately I found myself becoming completely frustrated with the Dropbox and R connection. I used the Dropbox folder on my production server hosted on AWS for months, but something would invariably cause the sync to stop working. I would it very difficult to get the dropbox folders to re-synch. I would waste a lot of time fiddling with it and finally get it working only to find that it would stop working again for some reason out of my control.
Continue reading

During a recent project I had to connect an R instance on a windows virtual machine provided by a client to their MS SQL Server. I have connected to many other data sources in the past, but I have not had to work with windows for a long time. It is much different than the typical setup in Linux. I am forgetting all the ways to do things. Non the less, I came across many sites that walked me through setting up a user DSN and having it manage my connection to the database. However, I still needed to connect R to MS SQL Server. This required my using the RODBC package.
Continue reading

This post grabs the latest unemployment number for each state from FRED and makes a map using statebin. This map uses 5 break points and is a quick and dirty way to visually view the unemployment conditions in the US. # this grabs the end of the file which should have the latest month library(statebins) library(lubridate) base = "http://research.stlouisfed.org/fred2/data/" end = "UR.txt" len <- read.table(paste0(base, "WA", end), skip= 12, header=F, as.
Continue reading

Create word cloud from lyrics of top 30 songs This is a tutorial of how to use the XML package and natural text processing to create word clouds of song lyrics from artist. Step 1: First load the library needed. Make a directory called songs in your current working directory. library(wordcloud) library(tm) library(ctv) library(SnowballC) library(XML) library(RColorBrewer) # install.views("NaturalLanguageProcessing") # install if needed Next set up the artist you would like to build a word cloud from, and place it below in url_m.
Continue reading