Articles by R on Locke Data Blog

Learn to R blog series – R and RStudio

March 28, 2018 | 0 Comments

Hello everyone, welcome back! This post marks the beginning, hopefully, of your foray into the wonderful world of R and RStudio…and my delve into the odd vlog to go with the blog! I’ve brushed my hair for you, and I don’t do that for just anyone, so ... [Read more...]

Understanding rolling calculations in R

March 6, 2018 | 0 Comments

In R, we often need to get values or perform calculations from information not on the same row. We need to either retrieve specific values or we need to produce some sort of aggregation. This post explores some of the options and explains the weird (to... [Read more...]

Image Recognition and Object Detection

February 27, 2018 | 0 Comments

In this latest blog, I’m responding to a cry for help. Someone got in touch with us recently asking for some advice on image detection algorithms, so let’s see what we can do! They already know what algorithms they want to use, so let’s start with those. ... [Read more...]

Markdown based web analytics? Rectangle your blog

February 21, 2018 | 0 Comments

Locke Data’s great blog is Markdown-based. What this means is that all blog posts exist as Markdown files: you can see all of them here. They then get rendered to html by some sort of magic cough blogdown cough we don’t need to fully understand here. For marketing ... [Read more...]

Connect to Google Sheets in Power BI using R

February 16, 2018 | 0 Comments

Hello again everyone! This latest blog post comes from this youtube video that we published a little while ago. Here’s the step by step instructions for using the ‘googlesheets’ package in R to enable you to get your data from Google Sheets Step 1 - Preparation Create an authentication token ... [Read more...]

How to maraaverickfy a blog post without even reading it

February 12, 2018 | 0 Comments

Steph is currently out of the office, teaching people cool Data Science stuff on a cruise at Tech Outbound. She counts on her team to keep the company’s Twitter account afloat in the meantime, so I had to think of a way to contribute. What about advertising existing content ... [Read more...]

Connecting to SQL Server on shinyapps.io

January 31, 2018 | 0 Comments

If you use SQL Server (or Azure SQL DB) as your data store and you need to connect to the databasse from shinyapps.io, you’re presently stuck with FreeTDS. If you have any control over infrastructure I cannot recommend highly enough the actual ODBC Driver on Linux for ease. ... [Read more...]

Year 2 of Locke Data

January 28, 2018 | 0 Comments

Hey folks, I wanted to give y’all an update about Locke Data one year on from when I started it up. In the past year, I’ve delivered more than 32 days of training, wrote and published 2 books, worked with 3 clients, and generally whimpered at my schedule. It has been ... [Read more...]

Working with PDFs – scraping the PASS budget

December 28, 2017 | 0 Comments

Using tabulizer we’re able to extract information from PDFs so it comes in really handy when people publish data as a PDF! This post takes you through using tabulizer and tidyverse packages to scrape and clean up some budget data from PASS, an association for the Microsoft Data Platform ... [Read more...]

Using blogdown with an existing Hugo site

December 19, 2017 | 0 Comments

If you decide you want to use R in your existing Hugo blog, it’s really easy to convert over. There’s a single command you need to know from blogdown and the rest is working out your deployment process. To create content, use the blogdown Rstudio a... [Read more...]

Data Manipulation in R

December 18, 2017 | 0 Comments

Data Manipulation in R is now generally available on Amazon. All book links will attempt geo-targeting so you end up at the right Amazon. Prices are in USD as most readers are American and the price will be the equivalent in local currency. Data Mani... [Read more...]

Working with R

October 5, 2017 | 0 Comments

I’ve been pretty quiet on the blog front recently. That’s because I overhauled my site, migrating it to Hugo (the foundation of blogdown). Just doing one extra thing on top of my usual workload, I also did another thing. I wrote a book too! I’m a big ... [Read more...]

All my talks in one place (plus a Hugo walkthrough!)

June 17, 2017 | 0 Comments

I mentioned in an earlier post about how I’m revamping my presentation slides process but that I hadn’t tackled the user experience of browsing my slides, which wasted lots of the effort I put in. To tackle this part of it, I’ve made lockedata.uk using Hugo ... [Read more...]

Using purrr with APIs – revamping my code

June 13, 2017 | 0 Comments

I wrote a little while back about using Microsoft Cognitive Services APIs with R to first of all detect the language of pieces of text and then do sentiment analysis on them. I wasn’t too happy with the some of the code as it was very inelegant. I knew ... [Read more...]

Versioning R model objects in SQL Server

May 26, 2017 | 0 Comments

High-level info If you build a model and never update it you’re missing a trick. Behaviours change so your model will tend to perform worse over time. You’ve got to regularly refresh it, whether that’s adjusting the existing model to fit the latest data (recalibration) or building ... [Read more...]

Improving automatic document production with R

May 19, 2017 | 0 Comments

In this post, I describe the latest iteration of my automatic document production with R. It improves upon the methods used in Rtraining, and previous work on this topic can read by going to the auto deploying R documentation tag. I keep banging on about this area because reproducible research / ... [Read more...]

How to go about interpreting regression cofficients

May 12, 2017 | 0 Comments

Following my post about logistic regressions, Ryan got in touch about one bit of building logistic regressions models that I didn’t cover in much detail – interpreting regression coefficients. This post will hopefully help Ryan (and others) out. This was so helpful. Thank you! I'd love to see more about ... [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)