867 search results for "SQL"

Code as Magic, and the Vernacular of Data Wrangling Verbs

February 11, 2015
By
Code as Magic, and the Vernacular of Data Wrangling Verbs

It’s been some time now since I drafted most of my early unit contributions to the TM351 Data management and analysis course. Part of the point (for me) in drafting that material was to find out what sorts of thing we actually wanted to say and help identify the sorts of abstractions we wanted to

Read more »

Autocommit with ceODBC is slow

February 10, 2015
By
Autocommit with ceODBC is slow

You already know that a SQL INSERT is faster with bulk loading than inserting a record at a time, but what about the effect of autocommit on performance? While this is probably not specific to ceODBC, using autocommit is astonishingly slow. Here is how slow. First, the Python code to run the benchmark:import ceODBCimport datetimeimport osimport timeconnection_string="driver=sql...

Read more »

Introducing stackr: An R package for querying the Stack Exchange API

February 3, 2015
By
Introducing stackr: An R package for querying the Stack Exchange API

There’s no end of interesting data analyses that can be performed with Stack Overflow and the Stack Exchange network of Q&A sites. Earlier this week I posted a Shiny app that visualizes the personalized prediction data from their machine learning system, Providence. I’ve also looked at whether high-reputation users were decreasing their answering activity over time,...

Read more »

A data.table R tutorial by DataCamp: intro to DT[i, j, by]

February 3, 2015
By
A data.table R tutorial by DataCamp:  intro to DT[i, j, by]

This data.table R tutorial explains the basics of the DT command which is core to the data.table package. If you want to learn more on the data.table package, DataCamp provides an interactive R course on the data.table package. The course has more than 35 interactive R exercises – all taking place in the comfort of The post

Read more »

Should you teach Python or R for data science?

February 2, 2015
By

Last week, I published a post titled Lessons learned from teaching an 11-week data science course, detailing my experiences and recommendations from teaching General Assembly's 66-hour introductory data science course. In the comments, I received the ...

Read more »

Bringing a Revolution to Microsoft

January 28, 2015
By

By Mark Sellors – Senior IT Consultant, UK. In a move that further validates the entire R community, our good friends and colleagues at Revolution Analytics announced their acquisition by Microsoft on Friday. In the short term, Revolution are expecting … Continue reading →

Read more »

rClr 0.7-3 released

January 27, 2015
By
rClr 0.7-3 released

Version 0.7-3 of rClr (source code also on GitHub), a package to access arbitrary .NET code seamlessly in-process, has just been released. The package was first introduced a year and a half ago in another blog post, and you can skim through that prior ...

Read more »

Google Analytics Dashboards with R & Shiny

January 27, 2015
By
Google Analytics Dashboards with R & Shiny

One of the key activities of any web or digital analyst is to design and create dashboards. The main objective of a web analytics dashboard is to display the current status of your key web metrics and arrange them on a single view, so that information ...

Read more »

Why you should learn R first for data science

January 26, 2015
By
Why you should learn R first for data science

Over and over, when talking with people who are starting to learn data science, there’s a frustration that comes up: I don’t know which programming language to start with.” And it’s not just programming languages, it’s also software systems like Tableau, SPSS, etc. There is an ever widening range of tools and programming languages and The post

Read more »

How to reliably access network resources in R

January 21, 2015
By
How to reliably access network resources in R

It’s frustrating when an application unexpectedly dies due to a network timeout or unavailability of a network resource. Veterans of …Continue reading →

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)