Uncategorized
How to do joins and merges in SQL and their R equivalents.
Year: 2018
See
Simple commands in SQL and their R equivalents.
See
I’ve been taking a look at SQL lately and how it relates to R. SQL is a programming language to manipulate data in databases. Its syntax is different from R. It resembles standard English with clauses more so than R does. In this post I’m going to look at some simple SQL commands and their … Read More “Five Common SQL Commands and their R equivalents” »
See
Recap In the last post we got to the stage where we had the data for each club’s league positions since 1958/59 in a Google sheet. The next step is to visualise this data in a Shiny app. Shiny lets you create visualisations that your users can interact with, and they have slightly different code … Read More “My First Shiny App Part II: The Shiny code itself” »
Site
Happy New Year to all my readers! Blog stats My last post took the blog through past 4,000 page views for 2017, up 41 per cent on 2016. I only started R for Journalists in October 2016, so it’s not an entirely fair comparison for a full year of 2017. However, I put this website … Read More “2017 Blog Stats” »