867 search results for "SQL"

Identifying Position Change Groupings in Rank Ordered Lists

December 9, 2014
By
Identifying Position Change Groupings in Rank Ordered Lists

The title says it all, doesn’t it?! Take the following example – it happens to show race positions by driver for each lap of a particular F1 grand prix, but it could be the evolution over time of any rank-based population. The question I had in mind was – how can I identify positions that

Read more »

dplyr – some more reflections

December 4, 2014
By

Yesterday, I published a post here on DataScience.LA with a simple/basic benchmark for dplyr. It...

Read more »

The World We Live In #3: Breastfeeding

December 1, 2014
By
The World We Live In #3: Breastfeeding

Facts are stubborn, but statistics are more pliable (Mark Twain) According to World Health Organization, exclusive breastfeeding is recommended up to 6 months of age, with continued breastfeeding along with appropriate complementary foods up to two years of age or beyond. Thus, the defining characteristic of continued breastfeeding is that the infant between 6 months and … Continue reading...

Read more »

Storing Forecasts in a Database

November 29, 2014
By

In my last post I mentioned that I started using RSQLite to store computed results. No rocket science here, but my feeling is that this might be useful to others, hence, this post. This can be done using any database, but I will use (R)SQLite as an illustration. Let’s assume we are running a long

Read more »

R, an Integrated Statistical Programming Environment and GIS

November 27, 2014
By
R, an Integrated Statistical Programming Environment and GIS

This article was originally published in Geoinformatics magazine. R is well known as a powerful, extensible and relatively fast statistical programming language and open software project with a command line interface (CLI). What is less well known is that R also has cutting edge spatial packages that allow it to behave as a fully featured Geographical Information System...

Read more »

Synchronization for R with the flock Package

November 20, 2014
By

Have you tried synchronizing R processes? I did and it wasn’t straightforward. In fact, I ended up creating a new package – flock. One of the improvements I did not too long ago to my R back-testing infrastructure was to start using a database to store the results. This way I can compute all interesting

Read more »

The ensurer package (validation inside pipes)

November 19, 2014
By
The ensurer package (validation inside pipes)

Guest post by Stefan Holst Milton Bache on the ensurer package. If you use R in a production environment, you have most likely experienced that some circumstances change in ways that will make your R scripts run into trouble. Many things can go wrong; package updates, external data sources, daylight savings time, etc. There is a general

Read more »

analyze the national incident-based reporting system (nibrs) with r and monetdb

November 11, 2014
By

in 2012, more than one quarter of the united states population lived in the jurisdiction of a police department that submitted details about every crime to a central repository maintained by the fbi.  a production of the uniform crime reports (ucr) program, the national incident-based reporting system (nibrs) compiles statistics from police agencies in thirty five states...

Read more »

The reddit Front Page is Not a Meritocracy

November 6, 2014
By
The reddit Front Page is Not a Meritocracy

I was pleasantly surprised when somebody shared my traveling salesman animation to reddit and the post made it all the way to reddit's default front page (i.e. the top 25). The gif racked up over 1.3 million pageviews on Imgur, a testament to reddit's traffic-generating prowess. Before the post made it to the front page, though, it was...

Read more »

Wrangling F1 Data With R – F1DataJunkie Book

October 30, 2014
By
Wrangling F1 Data With R – F1DataJunkie Book

Earlier this year I started trying to pull together some of my #f1datajunkie R-related ramblings together in a book form. The project stalled, but to try to reboot it I’ve started publishing it as a living book over on Leanpub. Several of the chapters are incomplete – with TO DO items sketched in, others are

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)