816 search results for "SQL"

Adobe Sitecatalyst API and R: integrate reports with the SAINT classification file

February 26, 2015
By
Adobe Sitecatalyst API and R: integrate reports with the SAINT classification file

From original post @ http://analyticsblog.mecglobal.it/

Read more »

The United States In Two Words

February 20, 2015
By
The United States In Two Words

Sweet home Alabama, Where the skies are so blue; Sweet home Alabama, Lord, I’m coming home to you (Sweet home Alabama, Lynyrd Skynyrd) This is the second post I write to show the abilities of twitteR package and also the second post I write for KDnuggets. In this case my goal is to have an insight of … Continue reading...

Read more »

Part 1: Introduction

February 14, 2015
By

Introducing shinyData (v0.1.1)

February 13, 2015
By
Introducing shinyData (v0.1.1)

shinyData is an easy to use tool for interactive data analysis, visualization and presentation. It leverages the power of R and its vast collection of packages to allow users to efficiently perform common data tasks, such as slicing and dicing, aggregation, visualization and more (usually referred to as “business intelligence”). Almost no knowledge of R … Continue reading...

Read more »

Eight New Ideas From Data Visualization Experts

February 12, 2015
By
Eight New Ideas From Data Visualization Experts

This post summarizes and visualizes eight key ideas we’ve heard from data visualization experts. Check out our first Case Study to learn more about using Plotly Enterprise on-premise, on your servers. To get started on free online graphing like in this post, check out our tutorials. Make Interactive Graphs Pictures of graphs in PowerPoints, dashboards, and emails can...

Read more »

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 »

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)