Archives
Categories
Monthly Archives: August 2009
Querying Databases in R
One of the first things you’ll want to do in R is set it up to talk to databases. The easiest way to do this is using ODBC, via package RODBC. To get the package, run > install.packages(RODBC) Once you … Continue reading
Posted in Data Munging, R, R Tip
Tagged data frame, greenplum, mysql, postgres, R and Databases, R Tips
Leave a comment
MySQL, Batch Imports, and Rails
I really love Rails, but it’s not the most performant code in the world. Though it doesn’t often arise in CRUD programming, if you do any sort of stats, ML, or data analytics, you’ll frequently find yourself wanting to import … Continue reading
R Dates – Recovering and Converting From Integers
One problem with R is that dates (class Date) are internally stored as integer numbers of days elapsed since 1 January 1970 and R sometimes loses the dateness of the variables and thinks of it only as an integer. So … Continue reading
Shading Pieces of an R Plot
This is post #11 in a running series about plotting in R. I often want to shade pieces of an R plot, in order to visually draw out some piece, such as weekends or recessions. Let’s look at how to … Continue reading
Matt Riley Rides the Zip Line at Scribd
We are trying to speed the zip line up so we attached what is basically a 300 foot rubber band — a tan, 4mm, Thera Band Roll to two columns and shot Matt down the zip line. He flew! Unfortunately, … Continue reading
Examining Data Frames — head and tail
head and tail, for those familiar with the unix command line, are two very handy utilities for looking at data frames. Along with str, which displays the structure of a data frame, they help you look at your data: > … Continue reading
