602 search results for "sql"

Reading huge files into R

February 19, 2012
By

SAS is much touted for its ability to read in huge datasets, and rightly so. However, that ability comes at a cost: for smaller datasets, since files remain on the disk rather than in memory (as is the case with Stata and R), it is potentially less fa...

Read more »

Elegant & fast data manipulation with data.table

February 12, 2012
By
Elegant & fast data manipulation with data.table

Just learned about the R data.table package (ht @recology_) makes R data frames into ultra-fast, SQL-like objects. One thing we get is some very nice and powerful syntax. Consider some simple data of replicate time series: To apply a function to each set of replicates, instead of We can use: Note that we could have

Read more »

R for Quants, Part I.A

February 12, 2012
By
R for Quants, Part I.A

I’m teaching an R workshop for the Baruch MFE program. This is the first installment of the workshop and focuses on …Continue reading »

Read more »

Oracle’s strange understanding of R users

February 8, 2012
By

After reading David Smith’s tweet on the price of Oracle R Enterprise (actually free, but it requires Oracle Data Mining at $23K/core as pointed out by Joshua Ulrich.) I went to Oracle’s site to see what was all about. Oracle … Continue reading →

Read more »

Coming R meetings in Paris

February 4, 2012
By
Coming R meetings in Paris

If you live in Paris and are interested in R, there will be two meetings for you this week. First a Semin-R session, organized at the Muséum National d’Histoire Naturelle on Tuesday 7 Feb (too bad, the Museum is closed on Tuesdays). Presentations will be about colors, phylogenies and maps, while I will speak about

Read more »

R meets HANA

February 2, 2012
By
R meets HANA

If you read my last blog called HANA meets R you will remember that we read data from HANA into R directly, without having to download an .csv file, but using ODBC. This time, we're going to read data from HANA as well, but after do some nice tricks on R, we're going to post back the...

Read more »

HANA meets R

February 2, 2012
By
HANA meets R

In my previous HANA and R blogs, I have been forced to create .csv files from HANA and read them on R...an easy but also boring procedure...specially if your R report is supposed to be run on a regular basis...having to create an .csv file every time you need to run your report it's not a nice thing...After...

Read more »

Two courses in R programming by Ken Rice and Thomas Lumley

February 2, 2012
By

Ken Rice and Thomas Lumley will give a course on advanced R programming in two locations this summer. 1. In Edinburgh, June 13-15 (the week before the International Conference in Quantitative Genetics). See http://www.eisg2012.org.uk/ 2. In Seattle, July 23-25, as part of the Summer Institute in Statistical Genetics. See http://www.biostat.washington.edu/suminst/sisg/general The course is about 60% lecture and 40% lab session (BYO R),...

Read more »

Say it in R with "by", "apply" and friends

January 28, 2012
By
Say it in R with "by", "apply" and friends

Iris versicolor (Source: Wikipedia)R is a language, as Luis Apiolaza pointed out in his recent post. This is absolutely true, and learning a programming language is not much different from learning a foreign language. It takes time and a lot of pr...

Read more »

Quick Introduction to ggplot2

January 17, 2012
By
Quick Introduction to ggplot2

For a much better looking version of this post (where code is actually readable!), see this Github repository, which also contains some of the example datasets I use and a literate programming version of this tutorial. Introduction This is a bare-bones introduction to ggplot2, a visualization package in R. It assumes no knowledge of R

Read more »