579 search results for "sql"

Making R’s paste act more like CONCAT

October 31, 2011
By

While vector-friendly, R's paste function has a few behaviors I don't particularly like. One is using a space as the default separator:> adjectives> paste(adjectives,"er")> paste(adjectives,"er") "lean er" "fast er" "strong er" #d'oh> paste(adjectives,"er",sep="") "leaner" "faster" "stronger"Empty vectors get an undeserved first class treatment: > paste(indelPositions,"i",sep="") "i"> indelPositions> paste(indelPositions,"i",sep="") "5i"...

Read more »

Learning R: Project 1, Part 2

October 30, 2011
By
Learning R: Project 1, Part 2

So it's been a week since I started down this path.  I worked most of this out over last weekend, went to a conference, had hectic week at work, and then realized I lost my work.  Gah.I'll be posting my general thoughts on R later.  Most...

Read more »

R Cookbook with examples

October 27, 2011
By
R Cookbook with examples

An R Cookbook can be found at http://code.ca-net.org/R%20Cookbook. It is a short web document presenting dozens of examples on - Accessing Database with packages RSQLite, RMySQL, RdbiPgSQL and RODBC; - Reading and Writing Data; - Date/Time variable; - Graphics; - … Continue reading →

Read more »

NYT on Big Data and R

October 24, 2011
By

In the New York Times' "Bits" blog today, Quentin Hardy offers recollections on Big Data talks at the recent Web 2.0 Summit. He begins with a definition of Big Data: Big Data is really about ... the benefits we will gain by cleverly sifting through it to find and exploit new patterns and relationships. You see it now in...

Read more »

Identifying Records in Data Frame A That Are Not Contained In Data Frame B – A Comparison

October 12, 2011
By
Identifying Records in Data Frame A That Are Not Contained In Data Frame B – A Comparison

Yesterday I launched my first question at Stackoverflow and apparently did a lot of things wrong as I managed to get my question closed wihtin hours http://stackoverflow.com/questions/7728462/identify-records-in-data-frame-a-not-contained-in-data-frame-b I had collected 9 different solutions to the problem and made the mistake to put it all within the original question space. So people complained and told me … Continue reading...

Read more »

New R-generated Video: Has StackOverflow Posting Behavior Changed Over Time?

October 5, 2011
By
New R-generated Video:  Has StackOverflow Posting Behavior Changed Over Time?

Sparks have been flying between my favorite data analysis language and my favorite programmer's Q & A site since long ago: R flirted with StackOverflow on September 10, 2008, 5 days before StackOverflow was even open to the public. R still hesitates to leave its original suitor, the loud and lively R-help mailing list, where

Read more »

Oracle’s Big Data Appliance to include R

October 3, 2011
By

At the Oracle OpenWorld conference in San Francisco today, Oracle announced the new Oracle Big Data Appliance, "a new engineered system that includes an open source distribution of Apache™ Hadoop™, Oracle NoSQL Database, Oracle Data Integrator Application Adapter for Hadoop, Oracle Loader for Hadoop, and an open source distribution of R." Oracle's foray into the Hadoop and NoSQL spaces...

Read more »

OLS beta VS. Robust beta

October 3, 2011
By
OLS beta VS. Robust beta

In financial context, is suppose to reflect the relation between a stock and the general market. A broad based index such as the S&P 500 is often taken as proxy for the general market. The , without getting into too … Continue reading →

Read more »

Monitoring Productivity II – the Others

September 30, 2011
By
Monitoring Productivity II – the Others

In previous Monitoring Productivity Experiment post I looked into the hours I spent in computer, now will look into the hours Others spend in computer, which is far more interesting :) To find things like what day people spend more time on computer, ho...

Read more »

Hipster programming languages

September 26, 2011
By
Hipster programming languages

If you look at the programming languages that are popular these days, a few patterns emerge. I'm not talking about languages that have the most hits on the job sites. I'm talking about what the cool kids are coding in - the folks that hang out on hacke...

Read more »