1348 search results for "excel"

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 »

Using R — Callling C code with Rcpp

November 12, 2012
By

This entry is part 12 of 12 in the series Using RIn two previous posts we described how R can call C code with .C() and the more complex yet more robust option of calling C code with .Call().  Here …   read more ...

Read more »

R Tips for Quantitative Trading

November 10, 2012
By

The article below is an updated version of an article I wrote  for R-Bloggers in August 2010. As a first post I thought it was a good idea to introduce one of the best tool out there for quantitative  trading: R R is a free software environment for statistical computing and graphics. It compiles and

Read more »