1329 search results for "Excel"

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 »

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 »

Creating an R package in Windows

November 21, 2012
By
Creating an R package in Windows

A nice package can be both beautiful and functional. The image is CC by MIAD Communication Design. Inspired by Read more »

A quick function for editing CSV files in R

November 19, 2012
By

I’ve been hunting for a lightweight CSV editor for OSX so I could to make fixes to data files and not need to fire up Excel. While you can edit a CSV file in any text editor, it’s a pain to navigate the files without a spreadsheet-like interface. Unfortunately there doesn’t seem to be a good,...

Read more »

R and SQLite: Part 1

November 18, 2012
By

Creating SQLite databases from R

Hjust and Vjust

November 16, 2012
By
Hjust and Vjust

So, when you’re setting the position of text in ggplot, you may have to use the hjust and vjust commands. Depending on your demands, and if you don’t understand what they’re doing, they might seem hard to use. I found one script that...

Read more »

Bottom-up creation of data-driven capabilities: automate your work

November 15, 2012
By

My previous post on how to transform an organization into a more data-driven version of itself made a pretty big assumption that often doesn’t hold true. I assumed that people in the organization wanted their company or agency to become more data-driven. I think almost everyone says they want that if asked. I even think

Read more »

Big Data ETL and Big Data Analysis

November 14, 2012
By
Big Data ETL and Big Data Analysis

I was at Strata New York 2012 last month. Great conference! Thanks O'Reilly media for assembling the industry leaders and running it well.I understand it was too crowded for some of my out-of-town friends. Stepping out to the streets of mid-town Manhat...

Read more »

My first R GUI

November 13, 2012
By
My first R GUI

This post is a huge jump from the last two - this is not for beginners!! But if you've ever considered building a GUI in R, looked at some of the online documentation, gotten scared, and decided not to, read this!!! Ok here goes. Dorian Auto GUI Setup: I built this for a school project. The basic problem setup is from...

Read more »

analyze the consumer expenditure survey (ce) with r

November 13, 2012
By

the consumer expenditure survey (ce) is the primo data source to understand how americans spend money.  participating households keep a running diary about every little purchase over the year.  those diaries are then summed up into precise expenditure categories.  how else are you gonna know that the average american household spent $34 (±2) on bacon, $826 (±17) on cellular...

Read more »