686 search results for "SQL"

Efficiency of Importing Large CSV Files in R

February 10, 2014
By
Efficiency of Importing Large CSV Files in R

Read more »

How dplyr replaced my most common R idioms

Having written a lot of R code over the last few years, I've developed a set of constructs for my most common tasks. Like an idiom in a natural language (e.g. "break a leg"), I automatically grasp their meaning without having to think about it. Because they allow me to become more and more productive »more

Read more »

In case you missed it: January 2014 roundup

February 5, 2014
By

In case you missed them, here are some articles from January of particular interest to R users: Princeton’s Germán Rodríguez has published a useful “Introduction to R” guide, with a focus on linear and logistic regression. The rxDForest function in the RevoScaleR package fits random forests of histogram-binning trees. A tutorial on using the xts package to analyze and...

Read more »

Use Case: Spatial R & Google Earth for Terrain Analyses

February 5, 2014
By
Use Case: Spatial R & Google Earth for Terrain Analyses

I'd like to share code that uses spatial R and Google Earth for terrain analyses. In this example I took SRTM data at 1" resolution from http://www.viewfinderpanoramas.org/dem3.html#alps read it into R did a little processing and finally wrapped it up ...

Read more »

Caching API calls offline

February 2, 2014
By

I've recently heard the idea of "offline first" via especially Hood.ie. We of course don't do web development, but primarily build R interfaces to data on the web. Internet availablility is increasinghly ubiqutous, but there still are times and places where you don't have internet, but need to get work done. In the R packages we write there...

Read more »

“Show me the way to the next whiskey bar” (The Doors – Alabama Song) – Interactive Location Recommendation using Tableau

February 2, 2014
By
“Show me the way to the next whiskey bar” (The Doors – Alabama Song) – Interactive Location Recommendation using Tableau

Since I started using Tableau I’m quite fascinated about the capabilities of this piece of software. Before Christmas I was looking how I could build an interactive visualization that helps me to explore the relationships between different objects in a form that shows which objects are very close to each other according to some similarity measure or vice versa....

Read more »

Introducing the ecoengine package

January 30, 2014
By
Introducing the ecoengine package

Natural history museums have long been valuable repositories of data on species diversity. These data have been critical for fostering and shaping the development of fields such as biogeography and systematics. The importance of these data repositories is becoming increasingly important, especially in the context of climate change, where a strong understanding of how species responded to past...

Read more »

Data corruption in R 3.0.2 when using read.csv

January 29, 2014
By

Introduction It may be old news to some, but I just recently discovered that the automatic type inference system that R uses when parsing CSV files assumes that data sets will never contain 64-bit integer values. Specially, if an integer value read from a CSV file is too large to fit in a 32-bit integer

Read more »

BLATting the internet: the most frequent gene?

January 23, 2014
By
BLATting the internet: the most frequent gene?

I enjoyed this story from the OpenHelix blog today, describing a Microsoft Research project to mine DNA sequences from web pages and map them to UCSC genome builds. Laura DeMare asks: what was the most-hit gene? Most hit gene? APOE? MT @GenomeBrowser We BLATed the Internet! DNA sequences from 40 billion webpages mapped to hg19

Read more »

Database Reflection using dplyr

January 22, 2014
By
Database Reflection using dplyr

At work I write a ton of SQL, and I do most of my querying using R.  The workflow goes: Create a string with the SQL in R Plug the string into fetchQuery (see my previous post) This solution works relatively well, but i’m a bit unhappy writing strings rather than using function calls. I

Read more »