-
Notifications
You must be signed in to change notification settings - Fork 3
Input–output overview
This page provides an overview of input–output analysis, establishing notations and conventions used in other pages. It then introduces the ADB MRIO tables and demonstrates how they are converted from Excel to Parquet files (process-mrios.ipynb
) and how key values are extracted (summary-table.ipynb
).
Let there be
where
Output of
where
These relationships are more neatly presented in a table. For the case of three economies
The
Uppercase letters in bold denote matrices while lowercase letters in bold denote vectors. These may further be collected into larger matrices and vectors: all
where
Gross exports are the total sales of an economy-sector to another economy. To get an expression for this, the
Visualizing this using the three-economy, two-sector example,
The exports vector is defined as
It is also useful to construct an exports matrix
where
The technical coefficient
Solving for
where the
The equations
The first line says that
In most analyses, value-added rather than output is the preferred metric. Define the vector
This expression gives the value-added generated in economy
Even more specific flows may be derived by defining input use structures for domestic intermediates
Moreover, since
Plugging this into the above and solving for
The matrix
Note that
This results in the sum of four terms:
Breaking this down by sector involves grouping these terms under either sector 1 and 2. There are two ways to do this:
Sector 1 | Sector 2 | |
---|---|---|
Option 1 |
|
|
Option 2 |
|
|
The first approach groups sectors by the origin of value-added. The second approach groups sectors by what
More elaborate decompositions allow for more approaches. For example, consider
The Asian Development Bank (ADB) Multiregional Input–Output (MRIO) Database is a time series of intercountry input–output tables. Originally an extended version of the World Input–Output Database, 2013 release, it is now maintained and updated yearly by a dedicated team in ADB. Information on cross-sectoral linkages are provided for 72 countries and economies plus a residual “Rest of the world” entity. Each country is divided into 35 sectors, based on Table A2 of Timmer, et al. (2015). There are five final demand categories: household final consumption expenditure (FCE), non-profit institutions serving households FCE, government FCE, gross fixed capital formation, and changes in inventories. A schematic representation of each MRIO table is given below.
Officially published national supply–use tables (SUTs) and/or input–output tables (IOTs) serve as benchmarks in the construction of the ADB MRIO. In each national SUT or IOT, sectoral and product classifications are harmonized to follow the 35 sectors, and whenever necessary, SUTs are transformed into IOTs following the industry technology transformation assumption discussed in European Commission (2008). Published estimates of gross output, gross value added, taxes less subsidies on products, imports, and exports sourced from national statistical agencies and central bank databases are used as control totals. The structure of imports and exports are based on bilateral trade data extracted from the United Nations COMTRADE Database and government trade and balance of payments statistics. Once the national IOTs are integrated into the MRIO, accounts for the sectors of “Rest of the world” are manually and systematically adjusted to ensure consistency with economy–sector totals in the MRIO.
Loading the raw Excel file of the MRIO using Pandas results in an unwieldy table:
The notebook process-mrios.ipynb
converts this to a machine-readable format:
The cleaned tables are then saved as space-efficient Parquet files in data/interim/
.
The notebook summary-table.ipynb
extracts the following key values for each country-sector from the cleaned MRIO tables:
-
x
: total output -
zuse
: intermediate use -
va
: value added -
zsales
: intermediate sales -
y
: final sales -
ez
: exports of intermediates -
ey
: exports of final goods -
e
: total exports
The tables are first queried using DuckDB's SQL functionality.
import pandas
import duckdb
mrio = duckdb.sql(
f"""
SELECT * EXCLUDE(C0)
FROM read_parquet('../data/interim/{inputfolder}/{file}')
"""
).df()
mrio = mrio.values
Vectors and matrices of interest are then extracted. The custom function zeroout()
is described in detail here.
import numpy as np
from functions import zeroout
x = mrio[-1][:(G*N)]
Z = mrio[:(G*N)][:, :(G*N)]
zuse = np.sum(Z, axis=0)
zsales = np.sum(Z, axis=1)
va = np.sum(mrio[-7:-1][:, :(G*N)], axis=0)
Y_big = mrio[:(G*N)][:, (G*N):-1]
Y = Y_big @ np.kron(np.eye(G), np.ones((f, 1)))
Zd = zeroout(Z @ np.kron(np.eye(G), np.ones((N, 1))), inverse=True)
Yd = zeroout(Y, inverse=True)
y = np.sum(Y, axis=1)
ez = np.sum(Zd, axis=1)
ey = np.sum(Yd, axis=1)
The output from this notebook is saved as summary.csv
in data/final/
.
The MRIO identified 62 countries and economies and a residual Rest of the World entity. In 2022, it was expanded to separately identify an additional 10 countries (numbers 63-72 below).
MRIO code | Name | MRIO code | Name | ||
---|---|---|---|---|---|
1 | AUS | Australia | 38 | SVK | Slovak Republic |
2 | AUT | Austria | 39 | SVN | Slovenia |
3 | BEL | Belgium | 40 | SWE | Sweden |
4 | BGR | Bulgaria | 41 | TUR | Turkey |
5 | BRA | Brazil | 42 | TAP | Taipei,China |
6 | CAN | Canada | 43 | USA | United States |
7 | SWI | Switzerland | 44 | BAN | Bangladesh |
8 | PRC | People's Republic of China | 45 | MAL | Malaysia |
9 | CYP | Cyprus | 46 | PHI | Philippines |
10 | CZE | Czech Republic | 47 | THA | Thailand |
11 | GER | Germany | 48 | VIE | Viet Nam |
12 | DEN | Denmark | 49 | KAZ | Kazakhstan |
13 | SPA | Spain | 50 | MON | Mongolia |
14 | EST | Estonia | 51 | SRI | Sri Lanka |
15 | FIN | Finland | 52 | PAK | Pakistan |
16 | FRA | France | 53 | FIJ | Fiji |
17 | UKG | United Kingdom | 54 | LAO | Lao People's Democratic Republic |
18 | GRC | Greece | 55 | BRU | Brunei Darussalam |
19 | HRV | Croatia | 56 | BHU | Bhutan |
20 | HUN | Hungary | 57 | KGZ | Kyrgyz Republic |
21 | INO | Indonesia | 58 | CAM | Cambodia |
22 | IND | India | 59 | MLD | Maldives |
23 | IRE | Ireland | 60 | NEP | Nepal |
24 | ITA | Italy | 61 | SIN | Singapore |
25 | JPN | Japan | 62 | HKG | Hong Kong, China |
26 | KOR | Republic of Korea | 63 | ARG | Argentina |
27 | LTU | Lithuania | 64 | COL | Colombia |
28 | LUX | Luxembourg | 65 | ECU | Ecuador |
29 | LVA | Latvia | 66 | ARM | Armenia |
30 | MEX | Mexico | 67 | GEO | Georgia |
31 | MLT | Malta | 68 | EGY | Egypt |
32 | NET | Netherlands | 69 | KUW | Kuwait |
33 | NOR | Norway | 70 | SAU | Saudi Arabia |
34 | POL | Poland | 71 | UAE | United Arab Emirates |
35 | POR | Portugal | 72 | NZL | New Zealand |
36 | ROM | Romania | 73 | RoW | Rest of the world |
37 | RUS | Russia |
MRIO code | Name | Short name | ISIC 3.1 |
---|---|---|---|
c1 | Agriculture, hunting, forestry, and fishing | Agriculture | A-B |
c2 | Mining and quarrying | Mining | C |
c3 | Food, beverages, and tobacco | Food & beverages | D15-16 |
c4 | Textiles and textile products | Textiles | D17-18 |
c5 | Leather, leather products, and footwear | Leather | D19 |
c6 | Wood and products of wood and cork | Wood | D20 |
c7 | Pulp, paper, printing, and publishing | Paper | D21-22 |
c8 | Coke, refined petroleum, and nuclear fuel | Refined fuels | D23 |
c9 | Chemicals and chemical products | Chemicals | D24 |
c10 | Rubber and plastics | Rubber | D25 |
c11 | Other non-metallic mineral | Other minerals | D26 |
c12 | Basic metals and fabricated metal | Metals | D27-28 |
c13 | Machinery, not elsewhere classified | Other machinery | D29 |
c14 | Electrical and optical equipment | Electricals | D30-33 |
c15 | Transport equipment | Transport equipment | D34-35 |
c16 | Manufacturing, not elsewhere classified; recycling | Other manufacturing | D36-37 |
c17 | Electricity, gas, and water supply | Utilities | E |
c18 | Construction | Construction | F |
c19 | Sale and repair of motor vehicles and motorcycles; retail sale of fuel | Sale of motor vehicles | G50 |
c20 | Wholesale trade, except of motor vehicles and motorcycles | Wholesale trade | G51 |
c21 | Retail trade and repair, except of motor vehicles and motorcycles | Retail trade & repair | G52 |
c22 | Hotels and restaurants | Hotels & restaurants | H |
c23 | Inland transport | Inland transport | I60 |
c24 | Water transport | Water transport | I61 |
c25 | Air transport | Air transport | I62 |
c26 | Other supporting transport activities | Other transport services | I63 |
c27 | Post and telecommunications | Telecommunications | I64 |
c28 | Financial intermediation | Finance | J65-67 |
c29 | Real estate activities | Real estate | K70 |
c30 | Renting of machinery & equipment and other business activities | Other business services | K71-74 |
c31 | Public administration and defence; compulsory social security | Public administration | L |
c32 | Education | Education | M |
c33 | Health and social work | Social work | N |
c34 | Other community, social, and personal services | Other personal services | O |
c35 | Private households with employed persons | Private households | P |
- Home
- Input–output overview
- Trade accounting
- GVC participation
- Production length
- Custom functions
- References