https://jacobfilipp.com/hammer/

Skip to the content

  * #8 (no title)
  * Contact Me
  * Writing
  * Index
  * Wishlist

Search for: [                    ] [Search]
 
Jacob Filipp

Project Hammer

September 8, 2024 / admin
PROJECT HAMMER

Last updated on:

September 9, 2024

Project Goal

Project Hammer aims to drive more competition and reduce collusion in
the Canadian grocery sector.

To get this done, we will:
1. Compile a database of historical grocery prices from top grocers'
websites.
2. Make the database available in a format that is suitable for
academic analysis and for legal action.
3. Inform changemakers of the existence of this dataset (and make it
reasonably easy for them to use).

I Need Your Help

I can't do this alone. This project can only succeed with a community
of people around it - people like you, who bring their own skills and
perspectives to the challenge.

Reach out to me (email "jacob" at this website) if:

  * You can do economic analysis of pricing data, and especially the
    interaction/correlation of multiple streams of prices across time
  * You are skilled with data processing and normalization
  * You'd play with the data for 1 day and tell me of all the bugs/
    issues/opportunities you found
  * You are doing similar pricing work in other countries / you've
    been inspired by Mario Zechner's work
  * You are a data-oriented politician, aide, activist, journalist or
    lawyer who's interested in improving Canada's hyper-concentrated
    grocery sector

[2024-09-08_22-12-44-1024x508]Source: Competition Bureau Retail
Grocery Market Study Report, June 27, 2023

Canadian Grocery Price Data

SQLite file with data from June 10, 2024 to September 8, 2024:

> Download price data (188mb zipped)

Contains prices from 7 Canadian grocery websites. I recommend that
you open it with the free DB Browser application and play with the
"raw" table / export to .csv.

Price Visualizations from the Dataset

Full interactive page for the below visualization

Full interactive page for the below

Analysis Ideas

  * Visualize the price of making a standard sandwich at each of the
    grocers (200g white bread + 20g ham + 20g lettuce...)
  * Nov. 1 to Feb. 5 price freeze on certain products:
    Metro stated that "It is an industry practice to have a price
    freeze from Nov. 1 to Feb. 5 for all private label and national
    brand grocery products, and this will be the case in all Metro
    outlets."
  * When a product goes on "sale", how long has it been since the
    previous sale? (if something is constantly on sale, then that's
    just its regular price)
  * When something's on "sale", did the price get jacked up
    artificially just ahead of the sale, only to lower it back down
    to normal?
  * How are different grocers responding to each other's price moves?
      + Is someone always leading price movements?
      + Is someone always reactive?
      + Do prices move exactly in tandem?
  * Which grocer is generally the cheapest across all comparable
    product families?

Categories: Writing

Post navigation

Manners and Customs of Women

Freshest posts:

  * Project Hammer
  * Manners and Customs of Women
  * A DAB O' THE PEN
  * Cat
  * Mobile-Friendly Image Maps

Copyright (c) 2024 Jacob Filipp

Theme by Anders Noren -- Up |