714 search results for "SQL"

F1Stats – Visually Comparing Qualifying and Grid Positions with Race Classification

January 30, 2013
By
F1Stats – Visually Comparing Qualifying and Grid Positions with Race Classification

Following the roundabout tour of F1Stats – A Prequel to Getting Started With Rank Correlations, here’s a walk through of my attempt to replicate the first part of A Tale of Two

Read more »

Another Benchmark for Joining Two Data Frames

January 29, 2013
By
Another Benchmark for Joining Two Data Frames

In my post yesterday comparing efficiency in joining two data frames, I overlooked the computing cost used to convert data.frames to data.tables / ff data objects. Today, I did the test again with the consideration of library loading and data conversion. After the replication of 10 times in rbenchmark package, the joining method with data.table

Read more »

Disruptive Data Science – Transforming Your Company into a Data Science-Driven Enterprise

January 29, 2013
By
Disruptive Data Science – Transforming Your Company into a Data Science-Driven Enterprise

Big Data is the latest technology wave impacting C-Level executives across all areas of business, but amid the hype, there remains confusion about what it all means. The name emphasizes the exponential growth of data volumes worldwide (collectively, 5 Exabytes/ day in the latest estimate I saw from IDC), but more nuanced definitions of Big Data incorporate the following...

Read more »

Efficiency in Joining Two Data Frames

January 28, 2013
By
Efficiency in Joining Two Data Frames

In R, there are multiple ways to merge 2 data frames. However, there could be a huge disparity in terms of efficiency. Therefore, it is worthwhile to test the performance among different methods and choose the correct approach in the real-world work. For smaller data frames with 1,000 rows, all six methods shown below seem

Read more »

SPARQL with R in less than 5 minutes

January 23, 2013
By
SPARQL with R in less than 5 minutes

In this article we’ll get up and running on the Semantic Web in less than 5 minutes using SPARQL with R. We’ll begin with a brief introduction to the Semantic Web then cover some simple steps for downloading and analyzing government data via a SPARQL query with the SPARQL R package. What is the Semantic The post SPARQL...

Read more »

SPARQL with R in less than 5 minutes

January 23, 2013
By
SPARQL with R in less than 5 minutes

In this article we’ll get up and running on the Semantic Web in less than 5 minutes using SPARQL with R. We’ll begin with a brief introduction to the Semantic Web then cover some simple steps for downloading and analyzing government data via a SPARQL query with the SPARQL R package. What is the Semantic Web? To newcomers, the...

Read more »

SPARQL with R in less than 5 minutes

January 23, 2013
By
SPARQL with R in less than 5 minutes

In this article we’ll get up and running on the Semantic Web in less than 5 minutes using SPARQL with R. We’ll begin with a brief introduction to the Semantic Web then cover some simple steps for downloading and analyzing government data via a SPARQL query with the SPARQL R package. What is the Semantic Web? To newcomers, the...

Read more »

In case you missed it: December 2012 Roundup

January 17, 2013
By

In case you missed them, here are some articles from December of particular interest to R users. The blog is.R ran an excellent series of R tips and applications in December, with posts including working with Stata files, working with graphs and networks, and text analysis. Kohske Takahashi provides R scripts to create a collection of optical illusions. Highlights...

Read more »

The Social Network Ranking is Wrong

January 14, 2013
By
The Social Network Ranking is Wrong

Call me old-fashioned, but I never saw the movie The Social Network until last year (at a private screening). In case you also missed it, it's the Hollywood version of how Facebook.com came into being. Quite apart from any artistic criticisms, I have a genuine psychological problem with movies like TSN. I keep getting caught up...

Read more »

analyze the health and retirement study (hrs) with r

January 14, 2013
By

the hrs is the one and only longitudinal survey of american seniors.  with a panel starting its third decade, the current pool of respondents includes older folks who have been interviewed every two years as far back as 1992.  unlike cross-se...

Read more »