Skip to content

R for Journalists

Unlock the power of R

  • What Is R?
  • R for Rob
  • GitHub
  • Twitter
  • Etsy
  • Home
  • merge

Tag: merge

SQL and R: Joins and Merges

Posted on April 10, 2018December 22, 2020 By Rob
Uncategorized

How to do joins and merges in SQL and their R equivalents.

Dodgy Road Signs, Traffic Lights and Markings: Part One

Posted on November 2, 2016 By Rob
Dodgy Road Signs, Traffic Lights and Markings: Part One
See

One of the most detailed UK government datasets I’ve ever seen is the STATS19 data from the Department for Transport. This is the collated reports of road accidents in Great Britain in which at least one person was injured or killed. It records all kinds of details, from the basics such as the date, time … Read More “Dodgy Road Signs, Traffic Lights and Markings: Part One” »

Asylum Seekers Are Usually Housed Away from London and the South East (Unless They Are Unaccompanied Children)

Posted on October 27, 2016October 27, 2016 By Rob
See

Walking through what’s left of the heart of the Jungle. The camp ‘Main St’ pic.twitter.com/8tYau41NST

— Gavin Lee (@GavinLeeBBC) October 26, 2016

With the Calais Jungle being broken up and most of the migrants there sent elsewhere in France, it seems a good time to return to the topic of asylum (although there is a difference between asylum and migration).

Read More “Asylum Seekers Are Usually Housed Away from London and the South East (Unless They Are Unaccompanied Children)” »

Londoners Take the Bus Far More Often Than the Rest of England (Adjusted for Population)

Posted on October 24, 2016October 31, 2016 By Rob
Londoners Take the Bus Far More Often Than the Rest of England (Adjusted for Population)
See

The last post came in for some criticism on /r/rstats, in particular from /u/fang_xianfu, who argued it merely showed that London has more people than the rest of the country.

Read More “Londoners Take the Bus Far More Often Than the Rest of England (Adjusted for Population)” »

Recent Posts

  • I’ve moved my blog over to Substack
  • How to plot a large rural area using Ordnance Survey data in R
  • Check the COVID-19 vaccination progress in your area
  • Let R tell you what to watch on Netflix
  • Sentiment analysis of Nineteen-Eighty-Four: how gloomy is George Orwell’s dystopian novel?

Archives

  • April 2022
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • February 2020
  • December 2019
  • November 2019
  • October 2019
  • April 2018
  • March 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016

Categories

  • Geospatial data
  • Landmark Atlas
  • Learn
  • See
  • Seen Elsewhere
  • Site
  • Uncategorized

Copyright © 2025 R for Journalists.

Theme: Oceanly by ScriptsTown

 

Loading Comments...