591 search results for "sql"

WordPress WordCloud with R

August 3, 2011
By
WordPress WordCloud with R

These days one can frequently read about wordclouds created with R, initiated by the release of the wordcloud package by Ian Fellows on July 23rd. So here I am to put in my two cents. I thought about creating a wordcloud of a complete blog history, so I build a script that connects to a

Read more »

Merging Two Different Datasets Containing a Common Column With R and R-Studio

August 2, 2011
By
Merging Two Different Datasets Containing a Common Column With R and R-Studio

Another way for the database challenged (such as myself!) for merging two datasets that share at least one common column… This recipe using the cross-platform stats analysis package, R. I use R via the R-Studio client, which provides an IDE wrapper around the R environment. So for example, here’s how to merge a couple of

Read more »

Your Data is Never the Right Shape

July 31, 2011
By
Your Data is Never the Right Shape

One of the recurring frustrations in data analytics is that your data is never in the right shape. Worst case: you are not aware of this and every step you attempt is more expensive, less reliable and less informative than you would want. Best case: you notice this and have the tools to reshape your Related posts:

Read more »

Shorting Mebane Faber

July 19, 2011
By
Shorting Mebane Faber

Although I do not personally know Mebane Faber, I know enough that I do not want to short him. However, I thought it would be insightful to see how the short side of his “A Quantitative Approach To Tactical Asset Allocation” might look.  Once ...

Read more »

Drawdown Control Can Also Determine Ending Wealth

July 11, 2011
By
Drawdown Control Can Also Determine Ending Wealth

As an extension to yesterday’s post Just Arriving is Not Enough, I wanted to show how minimizing drawdown is a much better technique to help control comfort and potentially increase ending wealth.  CHTTX was one of the best performers of the fou...

Read more »

Learning SAS

July 3, 2011
By
Learning SAS

I want to learn the heavy-weight of Statistical softwares - SAS. It seems like the default choice for high-end statistics and I want to understand why.I'm working in the healthcare practice in our firm and want to analyze claims and credit data (Teraby...

Read more »

RObjectTables are AWESOME

June 26, 2011
By

Why isn't everyone using the RObjectTables package? This is the best thing ever! Here's the basic idea of RObjectTables: An environment is an object where you can lookup names and associate them with values. And in particular its where you look up variables used in an expression. But there's no reason you can't take any other object that associates names...

Read more »

NHL Statistics – Goals scored by age

June 26, 2011
By
NHL Statistics – Goals scored by age

NHL Statistics, part 1 Goals scored by age Data Twirling blog gave instructions to how to get NHL statistics data from the website and I saw an opportunity to learn R and statistics with help of data I know and … Continue reading →

Read more »

sab-R-metrics: Merging Data Sets

June 22, 2011
By

I am finally back from Greece and recovered from jet lag. Fortunately, I did not get tear gassed while in Athens, though there were riot police everywhere the whole time we visited. Today, I'm going to start getting my feet wet again with a shorter s...

Read more »

The ‘Big Analytics’ Revolution Starts with R: Webinar June 14

June 7, 2011
By

On Tuesday next week I'll be teaming up with Revolution Analytics' Mike Minelli to give a 30-minute webinar to introduce executives to R, Big Data, and applications of advanced analytics. If there's someone in your company who needs to know about the impact of R on getting value out of data, they can register here. Here's the agenda: The...

Read more »