602 search results for "SQL"

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 »

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 »

SAP HANA and R (The way of the widget)

November 3, 2012
By
SAP HANA and R (The way of the widget)

A real developer never stops learning that's a quote I always love to repeat...because it applies to my life...you can know a lot of things but there's always something new to learn, or to re-learn. That's why a couple of days ago I start reading wxPyt...

Read more »

Which functions in plyr do people use?

November 2, 2012
By
Which functions in plyr do people use?

This is the question that Hadley Wickham recently set out to discovering by asking frequent R and plyr users how they use it in an online survey. Once a decent number of people have responded, Hadley quickly went forward and produced a short analysis of the plyr usage survey, and published it in RPubs.  With his permission, I am...

Read more »

Generate stock option prices – How to simulate a Brownian motion

October 29, 2012
By
Generate stock option prices  – How to simulate a Brownian motion

The Brownian motion is certainly the most famous stochastic process (a random variable evolving in the time). It has been the first way to model a stock option price (Louis Bachelier's thesis in 1900).The reason why is easy to understand, a Brownian mo...

Read more »

Vendor news: TIBCO’s proprietary R runtime; Teradata’s appliance integrates R

October 17, 2012
By
Vendor news: TIBCO’s proprietary R runtime; Teradata’s appliance integrates R

In a webinar today previewing Spotfire 5 (scheduled for release this November), TIBCO announced that it will include TERR: The Tibco Enterprise Runtime for R. TERR is a closed-source reimplementation of the R language engine, and not based on the GPL-licensed R project from the R Foundation. Here's the relevant slide from the webinar: By making the TERR engine...

Read more »

analyze the current population survey (cps) annual social and economic supplement (asec) with r

October 10, 2012
By

the annual march cps-asec has been supplying the statistics for the census bureau's report on income, poverty, and health insurance coverage since 1948.  wow.  the us census bureau and the bureau of labor statistics (bls) tag-team on this one...

Read more »

What lens should I buy next ?; Analysing and graphing a Digikam database using R

October 10, 2012
By

I use the Open Source photo management Software Digikam (along with other tools such as Gimp and DarkTable).  I obviously need very little encouragement to combine my geeky hobbies, so I quickly tried to interrogate Digikam with R, which is easy, ...

Read more »

Debugging parameter mismatch across RAC database instances with R, dba_hist, and gv$parameter

October 9, 2012
By
Debugging parameter mismatch across RAC database instances with R, dba_hist, and gv$parameter

Did you find this post useful?  Does your organization need Oracle services?  We can help.   Much of this morning went into investigating strange ADDM reports on a two-node Oracle RAC database.  For some reason, there were statistically improbable differences…Read more ›

Read more »

Tips on accessing data from various sources with R

October 3, 2012
By

Jeffrey Breen (the man behind the Twitter airline sentiment analysis example) recently posted a collection of slides with some great tips for accessing data from R. "Tapping the Data Deluge" includes information on: Using the XLConnect package to read data from Excel spreadsheets Using the foreign package to read SPSS, SAS, Stata and dBase data files Using SQL queries...

Read more »