Code & Data

Download the whole dataset including the code, raw data and cleaned data here.

The folder structure is the following:

UKitem_IndicesOrig contains the item_indices published by the ONS
UKPriceIndices1996Q1toLatestOriginal has 2 subfolders: 96to06 contains the historic price indices, and 07tolatest contains the price indices since 2007
COICOP contains the item_id - coicop keys
HistoricWeights contains the historic item weights needed to weigh the items
Formatted data contains the resulting post merging & cleaned data files.
Formatted data / CoicopWeightedtillLatest.csv is the basic merged file
Formatted data / CoicopWeightedtillLatestKCleaned.csv is the merged file post basic cleaning procedures

Upon downloading the files, using RStudio (or equivalent) one can reproduce the merging process by first running:

0_Merger.Rmd -- all necessary libraries are specified at the beginning of the file. All one needs to do is set the working directory to the downloaded folder.

To reproduce the figures in the "Figures" tab, one needs to run:

1_Plots.Rmd -- all necessary libraries are specified at the beginning of the file. All one needs to do is set the working directory to the downloaded folder. The prerequisite is having 'Formatted data / CoicopWeightedtillLatestKCleaned.csv'

To update with the new monthly data release:

place the series published by the ONS here into the item_indices and 07tolatest price_indices folders
Run 0_Merger.Rmd
Run 1_Merger.Rmd

For further details about the data, see the technical manual here.

Other than the files we provide, the historic data is available here.