1475 search results for "Excel"

Computed columns for dataframes

May 8, 2013
By
Computed columns for dataframes

Everyone loves to aggregate data. Everyone loves to create new columns based on other columns. Everyone hates to do the same thing twice. In my continuing work on multilevel view of loss reserving, I reached a point where I realized that I needed a robust mechanism to aggregate computed columns. SQL server and (I’m assuming)

Read more »

Gambler’s Run With Shiny

May 8, 2013
By
Gambler’s Run With Shiny

I finally had an opportunity to play with Shiny, and I am very impressed. I have created a Github Project so head over there for the source code. There are a number of ways to distribute Shiny apps. If you are running R (and mostly likely you are if you are reading this), you can download and...

Read more »

Incomplete Data by Design: Bringing Machine Learning to Marketing Research

May 6, 2013
By
Incomplete Data by Design: Bringing Machine Learning to Marketing Research

Survey research deals with the problem of question wording by always asking the same question.  Thus, the Gallup Daily Tracking is filled with examples of moving averages for the exact same question asked precisely the same way every day. &nb...

Read more »

Google Analytics + R = FUN!

May 5, 2013
By
Google Analytics + R = FUN!

The scope of this post it to show how simple it is to get data out of the Google Analytics and create your own reports (that you hope that they can be semi-automated at least) and you favourite statistical graphs (those that GA is currently missing). As you already know R is a favourite tool ...read more

Read more »

Google Analytics + R = FUN!

May 5, 2013
By
Google Analytics + R = FUN!

The scope of this post it to show how simple it is to get data out of the Google Analytics and create your own reports (that you hope that they can be semi-automated at least) and you favourite statistical graphs (those that GA is currently missing). As you already know R is a favourite tool

Read more »

Quandl Package – 5,000,000 free datasets at the tip of your fingers!

May 5, 2013
By
Quandl Package – 5,000,000 free datasets at the tip of your fingers!

# Yes, you read that correctly and no Quandl (http://www.quandl.com/) did not pay me anything.# Quandl is a new database management tool which seeks to become the place to find datasets.  They boast of having over 5x10^6 data sets available t...

Read more »

R for dummies

May 1, 2013
By
R for dummies

I already mentioned R for dummies a while ago on the ‘Og and never got around to read it from cover to back. Now that I am reduced to a dummy state with too much free time!, I can produce a full review of the book. R for dummies was written by two Belgian statistics

Read more »

Volatility Regimes: Part 1

Volatility Regimes: Part 1

This is a ‘do over’ of a project I started while at my former employer in the fall of 2012. I presented part 1 of this framework at the FX Invest West Coast conference on September 11, 2012. I have made some changes and expanded the analysis since then. Part 2 is complete and will follow this post in...

Read more »

Integrating Documentation and Calculation

April 30, 2013
By

Integrating Documentation and Calculation Integrating Documentation and Calculation This post is a first in that I've authored it using RStudio. I would guess most people who work in computational finance or quantitative risk are at least familiar with R. Unfortunately R as...

Read more »

The Financial Crisis on Tape Part II

April 26, 2013
By
The Financial Crisis on Tape Part II

EDIT: I am aware of some browsers failing to load the github code below. I will try to improve this as soon as possible. Until then it may work better on www.joesdatadiner.com than at http://www.r-bloggers.com/. Finally all the code is availa...

Read more »