Working with the OECD - ICIO database¶
The OECD Inter-Country Input-Output tables (ICIO) are available on the OECD webpage.
The parsing function >parse_oecd< works for both, the 2016 and 2018 release.
The tables can either be downloaded manually (using the csv format), or the pymrio OECD automatic downloader can be used.
For example, to get the 2011 table of the 2018 release do:
[1]:
import pymrio
[2]:
from pathlib import Path
[3]:
oecd_storage = Path("/tmp/mrios/OECD")
[4]:
meta_2018_download = pymrio.download_oecd(storage_folder=oecd_storage, years=[2011])
OECD provides the data compressed in zip files. The pymrio oecd parser works with both, the compressed and unpacked version.
Parsing¶
To parse a single year of the database, either specify a path and year:
[5]:
oecd_path_year = pymrio.parse_oecd(path=oecd_storage, year=2011)
Or directly specify a file to parse:
[6]:
oecd_file = pymrio.parse_oecd(path=oecd_storage / "ICIO2018_2011.zip")
[7]:
oecd_path_year == oecd_file
[7]:
True
Note: The original OECD ICIO tables provide some disaggregation of the Mexican and Chinese tables for the interindustry flows. The pymrio parser automatically aggregates these into Chinese And Mexican totals. Thus, the MX1, MX2, .. and CN1, CN2, … entries are aggregated into MEX and CHN.
Currently, the parser only includes the value added and taxes data given in original file as satellite accounts. These are accessable in the extension “factor_inputs”:
[8]:
oecd_file.factor_inputs.F.head()
[8]:
region | ARG | ... | ZAF | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sector | 01T03 | 05T06 | 07T08 | 09 | 10T12 | 13T15 | 16 | 17T18 | 19 | 20T21 | ... | 61 | 62T63 | 64T66 | 68 | 69T82 | 84 | 85 | 86T88 | 90T96 | 97T98 |
inputtype | |||||||||||||||||||||
AUS_TAXSUB | 0.121714 | 0.017712 | 0.017512 | 0.017816 | 0.001661 | 0.095973 | 0.007718 | 0.034678 | 0.128502 | 0.162166 | ... | 0.402171 | 0.674091 | 0.100344 | 0.626509 | 1.373728 | 1.610570 | 0.246573 | 0.634604 | 0.333580 | 0.0 |
AUT_TAXSUB | 0.073775 | 0.033071 | 0.013816 | 0.005258 | 0.078889 | 0.038198 | 0.010675 | 0.025981 | 0.015319 | 0.083526 | ... | 0.079267 | 0.042284 | 0.022676 | 0.061500 | 0.165165 | 0.420449 | 0.042098 | 0.449250 | 0.072340 | 0.0 |
BEL_TAXSUB | 0.185901 | 0.062070 | 0.024458 | 0.011260 | 0.148690 | 0.094059 | 0.012182 | 0.057137 | 0.061476 | 0.196174 | ... | 0.117514 | 0.092787 | 0.078851 | 0.145796 | 0.394643 | 0.535211 | 0.088572 | 0.357782 | 0.092843 | 0.0 |
CAN_TAXSUB | 1.190519 | 0.289064 | 0.230554 | 0.056490 | 0.455820 | 0.150127 | 0.035587 | 0.076343 | 0.871824 | 0.537732 | ... | 0.111660 | 0.064595 | 0.022136 | 0.065346 | 0.174113 | 0.272304 | 0.037256 | 0.102510 | 0.086703 | 0.0 |
CHL_TAXSUB | 0.800514 | 0.253973 | 0.176948 | 0.044563 | 1.024921 | 1.232006 | 0.102607 | 0.321750 | 0.381983 | 0.583021 | ... | 0.006196 | 0.006398 | 0.003776 | 0.019049 | 0.029477 | 0.029843 | 0.013084 | 0.022314 | 0.009911 | 0.0 |
5 rows × 2340 columns
Handling of the data happens similar to the other databases, see for example “Exploring EXIOBASE”.