Yesterday OECD has published results and data from PISA 2015 study (Programme for International Student Assessment). It’s a very cool study – over 500 000 pupils (15-years old) are examined every 3 years. Raw data is publicly available and one can easily access detailed information about pupil’s academic performance and detailed data from ... [Read more...]

[Read more...]

[Read more...]

Solutions to Euler Problem 2 in the R language for statistical computing. This problem asks to sum even numbers in the Fibonacci sequence whose values do not exceed four million. Continue reading → The post Euler Problem 2: Even Fibonacci Numbers appeared first on The Devil is in the Data. [Read more...]

This document describes a proof-of-concept for producing R demonstration videos in a fully-automated manner. The “script” for the video consists of a text file containing code chunks paired with text commentary. The video is produced by running the code while recording a screen capture, using text-to-speech software to record audio ... [Read more...]

This document describes a proof-of-concept for producing R demonstration videos in a fully-automated manner. The “script” for the video consists of a text file containing code chunks paired with text commentary. The video is produced by running the code while … Continue reading → [Read more...]

Microsoft R Server 9.0, Microsoft's R distribution with added big-data, in-database, and integration capabilities, was released today and is now available for download to MSDN subscribers. This latest release is built on Microsoft R Open 3.3.2, and adds new machine-learning capabilities, new ways to integrate R into applications, and additional big-data support ... [Read more...]

A list of resources for learning R in preparation for CS109 this Spring. A wealth of R resources are available, and I'm sure I've missed some really good ones. If you have a favorite tutorial or resource that is not listed here, please email me or ... [Read more...]

by Joseph Rickert November was a prolific month for R developers: 189 new packages landed in CRAN. I have selected more than a quarter of them for this post, but I haven’t listed everything that is worth a look. My November 2016 picks are organized into four categories: Biotech (4 picks), Data (6 ... [Read more...]

How to write Structured Query Language (SQL) code in R. Well there are many packages on CRAN that relate to databases. In the exercises below we cover some of the important data manipulation operations using SQL in R. We will use a ‘sqldf’ package, an R package for running SQL ... [Read more...]

[Read more...]

[Read more...]

Last year I made a blog post about a Secret Santa picker HERE, but to use it required quite a bit of messing around with the code. So this year I decided to improve the whole thing by making it a function rather than a script. The function take two ... [Read more...]

[Read more...]

[Read more...]

Many data analysts in Riyadh (or as much as I have met) still valiantly use Excel and/or SQL to perform analyses. Some engage in SQL gymnastics for the simple operation of pivoting, whilst others wait for purchase of SAS licences, affirming that SAS ... [Read more...]

[Read more...]

Hey R fans! We've just released a new episode of DataCamp's DataChats video series.  In this third episode, we interview Charlotte Wickham. Charlotte is an Assistant Professor in the Department of Statistics at Oregon State University and an avid R... [Read more...]

In this exercise we cover the basics on selecting and extracting data using queries. We add a few other materials into it. This should prepare you for the next exercise: Basic Decision Tree. The purpose of this is to give you the 20 percent of the tools to get 80 percent of ... [Read more...]

[Read more...]