566 search results for "sql"

A Story of Life and Death. On CRAN. With Packages.

November 27, 2011
By

The Comprehensive R Archive Network, or CRAN for short, has been a major driver in the success and rapid proliferation of the R statistical language and environment. CRAN currently hosts around 3400 packages, and is growing at a rapid rate. Not too ...

Read more »

Do we need to deal with ‘big data’ in R?

November 22, 2011
By
Do we need to deal with ‘big data’ in R?

David Smith at the Revolutions blog posted a nice presentation on “big data” (oh, how I dislike that term). It is a nice piece of work and the Revolution guys manage to process a large amount of records, starting with … Continue reading →

Read more »

FBS Coaches Avg. Salary

November 18, 2011
By
FBS Coaches Avg. Salary

Of course, a few days before I leave for a much needed vacation, USA Today released their updated NCAA coaching salary database. For sports junkies, there’s an unlimited number of analysis and visualizations that can be done on the data. I took a quick break from packing to condense the data to a csv and

Read more »

Google Scholar (still) sucks

November 13, 2011
By

(This is a follow-up to my previous post on the topic.)I was encouraged by the appearance of two R-based Scholar-scrapers, within a week of each other. One, by Kay Cichini, converts the page URLs into text mode and scrapes from there (There's a slightl...

Read more »

PostGIS Quickie

November 10, 2011
By

Today I needed to cut out a rectangle of geologic data from a state-wide map in an AEA coordinate system, using a bounding box from a UTM zone 10 region, with the output saved in UTM zone 10 coordinates. PostGIS makes this type of operation very simple...

Read more »

In case you missed it: October Roundup

November 10, 2011
By

In case you missed them, here are some articles from October of particular interest to R users. The creator of the ggplot2 package, Hadley Wickham, shares details on some forthcoming big-data graphics functions (based on research sponsored by Revolution Analytics). A list of several dozen free data sources that can easily be imported into R. Bob Muenchen gave a...

Read more »

Blankety Blank

November 8, 2011
By
Blankety Blank

The erstwhile big 4 all blanked their opponents last Saturday and a poster on the Guardian wondered when was the previous occasion of such an occurrence. It’s a pretty simple procedure in SQL using a subquery, but in the spirit of learning R, I thought I would tackle the problem in that language, with the

Read more »

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 »