What Python can teach us about Beer

Martin Chorley

@martinjc

PyCon UK 2017

code: http://bit.ly/pycon-beer

slides: http://bit.ly/pycon-beer-slides

Shameless Plug!

Each beer checkin is a unique record linking:

  • a beer
  • a user
  • a place
  • a time

Where are we looking at?

7 US cities

New York, Los Angeles, Chicago, Seattle, Denver, Boston, Portland

6 EU cities

London, Dublin, Barcelona, Paris, Amsterdam, Copenhagen
Monitoring from

13th August 2015

to

2nd October 2017

(781 days)

20,870,677 checkins

15,934,461 US checkins

4,936,216 EU checkins

893,971 users

414,305 beers

848,852 venues

30,931 breweries

intermission (no. 10)

Who are we looking at?

When are they drinking beer?

New York

London

Paris

Amsterdam

What beer are they drinking?

The top 5 Beers in the US and EU...*

#1: Guinness - Guinness Draught (4.30%) - Ireland - (89928)

#2: Heineken - Heineken (5.00%) - Netherlands - (60975)

#3: Lagunitas Brewing Company - IPA (6.20%) - United States (CA) - (56768)

#4: Goose Island Beer Co. - Goose IPA (5.90%) - United States (IL) - (54484)

#5: Revolution Brewing Company - Anti-Hero IPA (6.50%) - United States (IL) - (46538)

#6: Anheuser-Busch - Bud Light (4.20%) - United States (MO) - (36783)

* assuming our 13 cities are in any way representative

The top 5 Beers in the EU...*

#1: Heineken - Heineken (5.00%) - Netherlands - (50171)

#2: Guinness - Guinness Draught (4.30%) - Ireland - (45039)

#3: BrewDog - Punk IPA (5.60%) - Scotland - (22451)

#4: Meantime Brewing Company - London Pale Ale (4.30%) - England - (14940)

#5: Grupo Damm - Estrella Damm (5.40%) - Spain - (14763)

The top 5 Beers in the US...*

#1: Lagunitas Brewing Company - IPA (6.20%) - United States (CA) - (48192)

#2: Goose Island Beer Co. - Goose IPA (5.90%) - United States (IL) - (48153)

#3: Revolution Brewing Company - Anti-Hero IPA (6.50%) - United States (IL) - (46521)

#4: Guinness - Guinness Draught (4.30%) - Ireland - (44889)

#5: Anheuser-Busch - Bud Light (4.20%) - United States (MO) - (36284)

The top 5 Beers in Copenhagen

#1: Carlsberg Group - Tuborg Classic (4.60%) - Denmark

#2: Carlsberg Group - Carlsberg (5.00%) - Denmark

#3: Carlsberg Group - Brewmasters Collection India Pale Ale (5.20%) - Denmark

#4: Carlsberg Group - Tuborg GrΓΈn (4.60%) - Denmark

#5: Jacobsen - Brown Ale (6.00%) - Denmark

The top 5 Beers in Denver

#1: Great Divide Brewing Company - Titan IPA (7.10%) - United States (CO)

#2: Odell Brewing Co. - 90 Shilling (5.30%) - United States (CO)

#3: Great Divide Brewing Company - Denver Pale Ale (DPA) (5.40%) - United States (CO)

#4: AC Golden Brewing Co. - Colorado Native Amber Lager (5.50%) - United States (CO)

#5: Russian River Brewing Company - Pliny the Elder (8.00%) - United States (CA)

The top 5 Beers in Seattle

#1: Georgetown Brewing Company - Manny's Pale Ale (5.40%) - United States (WA)

#2: Black Raven Brewing Company - Trickster (6.90%) - United States (WA)

#3: Elysian Brewing - Space Dust IPA (7.20%) - United States (WA)

#4: Mac & Jack's Brewing Company - African Amber (5.60%) - United States (WA)

#5: Fremont Brewing - Interurban IPA (6.20%) - United States (WA)

What strength beer are they drinking?

intermission (no. 20)

What style of beer are they drinking?

Global

What other differences are there?

So what has Python taught us about Beer?

Who?

Just under 900,000 Untappd users

Where?

New York, Los Angeles, Chicago, Seattle, Denver, Boston, Portland, London, Dublin, Barcelona, Paris, Amsterdam, Copenhagen

What?

Higher ABV outside UK & Ireland

Big global brands dominate (Guinness, Heineken)

But more variety at local level

When?

All the time!

Especially Friday lunchtime in London

Why?

intermission (no. 49)

(thanks @JosephRedfern!)

What Python can teach us about Beer

Martin Chorley

@martinjc

code: http://bit.ly/pycon-beer

slides: http://bit.ly/pycon-beer-slides