Monthly Archives: November 2012

We NEED more data

November 22, 2012
By
We NEED more data

Email One of the historic difficulties of doing research on urban energy systems has been the limited availability of data at sufficiently detailed spatial resolutions. Without this data, you might end up relying on aggregate information about the built environment, building occupants, and local geography that doesn't apply to the specifics of a particular neighbourhood

Read more »

Washington Gave Thanks To R:

November 22, 2012
By
Washington Gave Thanks To R:

The folks over at is.R() brought along an "adorable Turkey". I guess we'll thank them for their gift - and pardon the Turkey. Personally I thank them for a bucket of hints and tricks I freely used and will continue to do so.Tal brought us a great ...

Read more »

Connecting R to an Oracle database with RJDBC

November 22, 2012
By

In many circumstances, you might want to connect R directly to a database to store and retrieve data.  If the source database is an Oracle database, you have a number of options: ROracle RODBC RJDBC   Using ROracle should theoretically… Read more ›

Read more »

Controlling heatmap colors with ggplot2

November 22, 2012
By
Controlling heatmap colors with ggplot2

One of the most popular posts on this blog is the very first one, solving the issue of mapping certain ranges of values to particular colors in heatmaps. Given the abundance of ggplot2 usage in R plotting, I thought I’d … Continue reading →

Read more »

Happy Thanksgiving from is.R()!

November 22, 2012
By
Happy Thanksgiving from is.R()!

Today’s post is mostly to wish everyone a Happy Thanksgiving. We will be taking the rest of the week off, and will return on Monday. Below is some code to reproduce the adorable Turkey above; enjoy! https://gist.github.com/4122464

Read more »

Extending Commodity time series

November 21, 2012
By
Extending Commodity time series

I want to follow up with Extending Gold time series post by showing how we can extend Commodity time series. Most Commodity ETFs began trading in 2006, please see the List of Commodity ETFs page. I will use DBC – PowerShares DB Commodity Fund, one on the most liquid Commodity ETFs as my proxy for

Read more »

What’s the difference between POSIXct and POSIXlt?

November 21, 2012
By

POSIXct is the signed number of seconds since “the epoch”. For example it was1351298112 UTC (GMT)when I wrote this. (1351298112 UTC = Sat Oct 27, 2:35 am GMT = Fri Oct 26, 8:35 pm EST = Fri Oct 26, 5:35 pm PST = 2:35 pm HST) POSIXlt is one of many text | character | string formats such as:May 17, 2017 17/5/2017 17-5-17 05:24:39

Read more »

Data types, part 3: Factors!

November 21, 2012
By
Data types, part 3: Factors!

In this third part of the data types series, I'll go an important class that I skipped over so far: factors.Factors are categorical variables that are super useful in summary statistics, plots, and regressions. They basically act like dummy variables t...

Read more »

Upcoming Webinar: Real-time, big-data analytics

November 21, 2012
By

A quick heads-up that I'll be presenting another brand-new webinar on Thursday next week (November 29). In Real-time Big Data Analytics: From Deployment to Production, I'll review the process of making predictive models work in real-live operational environments. I'll also tackle those ubiquitous buzz-words "real-time" and "big data", and the fact that they can mean very different things in...

Read more »

IPython vs RStudio+knitr

November 21, 2012
By
IPython vs RStudio+knitr

At a meeting last night with some collaborators at the Vélobstacles project, I was excitedly told about the magic of IPython and it’s notebook functionality for reproducible research. This sounds familiar, I thought to myself. Using a literate programming approach to integrate computation with the communication of methodology and results has been at the core

Read more »