The top name of the NFL Divisional Round

TL;DR. The charts in this blog mostly use randomly created data, as I don’t have the rights to actual data.

On 1/16/21, in the first game of the NFL Divisional Playoffs, the Green Bay Packers will face the Los Angeles Rams. These teams represent the NFL’s top-ranked defense (Rams) and offense (Packers).

Interestingly the best player on each team is named Aaron. Aaron Rodgers is possibly the best quarterback in football, and he is one of the hot favorites for this year’s Most Valuable Player award. Aaron Donald is one of the best ever to play his position. He is one of three favorites for this year’s Defensive Player of Year. Throw in the Packer’s running back Aaron Jones as well. No matter how this game turns out, one of the Aarons will be highly influential. …


Calculating Total Streaming Content

TL;DR- No, unless you have an evil streaming lair

Image for post
Image for post
Evil Streaming Lair. Photo by Michał Lis on Unsplash

A couple of weeks ago I estimated total available streaming content. It comes out to more than 20 years of continuous content.

I had to make a few assumptions to get to that number. Having come across another resource I thought I’d take another shot at this estimate.

The good people at The Movie Database provided me with an API to download some data to help with this project.

I began with a TV listing. You can get this here, even without an API. The listing is provided in a compressed json.gz file. …


Exploring Fitbit Heart Rate Data

Recently with the reduced workout options available under Covid-19, I have been focusing on doing high-intensity interval training (HIIT). There are different methods of HIIIT workouts. For me, what this means is going flat out, as hard as I can, for about a minute, followed by a rest period, and then repeating the whole sequence 3 or 4 times.

The advantage of HIIT is that you burn calories without burning muscle, and you’re all done with your workout in much less time than a traditional cardio workout. The disadvantage is that you feel like hell during the workout.

Here’s some recent…


Summarizing the growth of Streaming Platforms

There hasn’t been much to get excited about in 2020. One positive thing was the incredible growth of streaming services. Here’s a quick review of streaming services as they stand at the end of the year.

Image for post
Image for post
Photo by Bermix Studio on Unsplash

Research

I began this effort by gathering as much data as possible. The most useful source for research was the streaming companies themselves. Most entertainment companies haven’t had a lot of great news this year, so they are falling over themselves to tell the world about the latest boost in subscription numbers. Quarterly analyst reports are a good place to stay. Another helpful source of information is research companies and industry publications. Variety, Hollywood Reporter, Wall St Journal, Bloomberg, New York Times have all published reports on entertainment-related research studies. …


Correlated Subquery and Common Table Expression (CTE).

In a previous blog, we covered simple subqueries.

This blog will cover a couple more examples of SQL Subquery: The Correlated Subquery and Common Table Expression.

Image for post
Image for post
Correlated | Photo by Lucas George Wendt on Unsplash

Correlated Subquery

A correlated subquery compares values in each row against a table referenced in the main or outer query. It is like a simple subquery in that it has its own SELECT clause and FROM clause. It is different from a simple subquery in that you can’t run it independently. You can’t execute a correlated subquery on its own because it’s dependent on values in the outer query.

How Does it Work?

A correlated subquery is evaluated in loops, once for each row generated by the data set. With a simple subquery, the inner query runs first and executes one time, returning values to be used by the main query. …


Exploring probability in real life.

This week the BBC, The Guardian, and ABC published a story about a suspicious consecutive streak of winning numbers in the South African national lottery.

“South Africa’s lottery probed as 5, 6, 7, 8, 9 and 10 drawn and 20 win.”

Gasp! Horror! The scandal!

Have the good people of South Africa been cheated? Or is it a case of the high probability of low-probability events*?

Image for post
Image for post
Gasp! | photo by mokra on freeimages

The Lottery

The BBC article tells us a little bit about the South African lottery under question.

Twitter. @sa_lottery

You pick 5 balls out of 50 possibilities and then one power ball out of 20.

According to the BBC, there’s a one in…


Getting started with SQL part 3

Introduction

Last time we introduced joining tables in SQL. This time we move on to Subqueries.

What is a subquery

Very simply, it is a query inside of a query. They are useful when you need to carry out a process multiple steps. Often, to get the information you want, you have to do some work on your data before you can begin with the selecting, filtering, or calculating. Subqueries are a popular way of performing this work.

Image for post
Image for post
Photo by Deon Black on Unsplash

Types of Queries

You can use a subquery in many different places of the main query: SELECT, FROM, WHERE.

A subquery can return different data types — a single value or scalar, a row, or a table. The data produced by the subquery determines how the main query may interact with the data. When the main query is complete, the data from any subqueries gets dropped. So the subquery acts like a temporary table. …


Joining Tables

Last time we covered some basic keywords for getting started in SQL. That on its own isn’t much use because what kind of a database only has one table?

In this blog, we are going to make SQL come alive, using multiple tables. We’ll learn about joins and aggregate functions.

Multiple Tables

We use multiple tables because we want to:

  • organize the data into groups that make sense
  • avoid repeating data
  • make changes in only one place, when we update data records
  • have data that is easy to use and fast to process
Image for post
Image for post
Photo by Roman Kraft on Unsplash

JOIN

The way that we connect tables together is by using a JOIN clause. Joins have two parts JOIN and ON. JOIN identifies the table that we want to add additional data from. ON specifies how to join the tables. It matches a column from each table and combines rows where the values in the columns are equal. …


How to use basic commands

If Data Scientist really is the sexiest job in the world, SQL is the decidedly unsexy tool that you’ll use to do most of your work. Based on job descriptions, SQL is even more in demand than other popular programming languages like Python and Java.

TL,DR — go to the summary table of basic commands at the end

Image for post
Image for post
What? by Rhys Kentish on Unsplash

What is SQL

SQL is the most commonly used language for interacting with databases. Why? It is relatively easy to understand and allows us to access data directly where it is stored.

SQL can be pronounced in two different ways. You can say the letters individually “S”, “Q”, “L”, or like the word “Sequel”. Either way is fine, although be warned … you may come across some people that adamantly insist that their pronunciation is the correct one. Even the big tech companies seem to disagree on this: Microsoft and Oracle databases use “Sequel”, while IBM and most open source databases use “S.Q.L” …


Saturday Night Live Monologue

On November 7, 2020, Dave Chappelle hosted SNL for the second time, in the week following the presidential election. This time around, the winner of the election was not declared until Saturday — the fifth day after counting began. This left Chappelle mere hours to rewrite and patch together a monologue relevant for the show and to address extraordinary times we’re living in.

The time crunch made me wonder … what if an algorithm could help? Could we generate an artificial Chappelle?

Would it have the same biting insight?

Would it have the same bluntness and provocative social commentary?

Would it talk to the mood of a nation, and capture the dual feelings of relief and devastation that the country is feeling?

About

Andrew Jamieson

Andrew has an analytics background with over 20 years of experience in various industries, working with world-leading brands.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store