Multi regional monetary supply and use exiobase
In [1]:
import mario
In [2]:
# database path in local storage
path= r'MRSUT_2021.zip'
In [3]:
world = mario.parse_exiobase_sut(path=path,year=2011,name='mrsut example')
In [4]:
# getting the Activities and Commodities
world.get_index('Activity')
Out[4]:
['Cultivation of paddy rice', 'Cultivation of wheat', 'Cultivation of cereal grains nec', 'Cultivation of vegetables, fruit, nuts', 'Cultivation of oil seeds', 'Cultivation of sugar cane, sugar beet', 'Cultivation of plant-based fibers', 'Cultivation of crops nec', 'Cattle farming', 'Pigs farming', 'Poultry farming', 'Meat animals nec', 'Animal products nec', 'Raw milk', 'Wool, silk-worm cocoons', 'Manure treatment (conventional), storage and land application', 'Manure treatment (biogas), storage and land application', 'Forestry, logging and related service activities (02)', 'Fishing, operating of fish hatcheries and fish farms; service activities incidental to fishing (05)', 'Mining of coal and lignite; extraction of peat (10)', 'Extraction of crude petroleum and services related to crude oil extraction, excluding surveying', 'Extraction of natural gas and services related to natural gas extraction, excluding surveying', 'Extraction, liquefaction, and regasification of other petroleum and gaseous materials', 'Mining of uranium and thorium ores (12)', 'Mining of iron ores', 'Mining of copper ores and concentrates', 'Mining of nickel ores and concentrates', 'Mining of aluminium ores and concentrates', 'Mining of precious metal ores and concentrates', 'Mining of lead, zinc and tin ores and concentrates', 'Mining of other non-ferrous metal ores and concentrates', 'Quarrying of stone', 'Quarrying of sand and clay', 'Mining of chemical and fertilizer minerals, production of salt, other mining and quarrying n.e.c.', 'Processing of meat cattle', 'Processing of meat pigs', 'Processing of meat poultry', 'Production of meat products nec', 'Processing vegetable oils and fats', 'Processing of dairy products', 'Processed rice', 'Sugar refining', 'Processing of Food products nec', 'Manufacture of beverages', 'Manufacture of fish products', 'Manufacture of tobacco products (16)', 'Manufacture of textiles (17)', 'Manufacture of wearing apparel; dressing and dyeing of fur (18)', 'Tanning and dressing of leather; manufacture of luggage, handbags, saddlery, harness and footwear (19)', 'Manufacture of wood and of products of wood and cork, except furniture; manufacture of articles of straw and plaiting materials (20)', 'Re-processing of secondary wood material into new wood material', 'Pulp', 'Re-processing of secondary paper into new pulp', 'Paper', 'Publishing, printing and reproduction of recorded media (22)', 'Manufacture of coke oven products', 'Petroleum Refinery', 'Processing of nuclear fuel', 'Plastics, basic', 'Re-processing of secondary plastic into new plastic', 'N-fertiliser', 'P- and other fertiliser', 'Chemicals nec', 'Manufacture of rubber and plastic products (25)', 'Manufacture of glass and glass products', 'Re-processing of secondary glass into new glass', 'Manufacture of ceramic goods', 'Manufacture of bricks, tiles and construction products, in baked clay', 'Manufacture of cement, lime and plaster', 'Re-processing of ash into clinker', 'Manufacture of other non-metallic mineral products n.e.c.', 'Manufacture of basic iron and steel and of ferro-alloys and first products thereof', 'Re-processing of secondary steel into new steel', 'Precious metals production', 'Re-processing of secondary preciuos metals into new preciuos metals', 'Aluminium production', 'Re-processing of secondary aluminium into new aluminium', 'Lead, zinc and tin production', 'Re-processing of secondary lead into new lead, zinc and tin', 'Copper production', 'Re-processing of secondary copper into new copper', 'Other non-ferrous metal production', 'Re-processing of secondary other non-ferrous metals into new other non-ferrous metals', 'Casting of metals', 'Manufacture of fabricated metal products, except machinery and equipment (28)', 'Manufacture of machinery and equipment n.e.c. (29)', 'Manufacture of office machinery and computers (30)', 'Manufacture of electrical machinery and apparatus n.e.c. (31)', 'Manufacture of radio, television and communication equipment and apparatus (32)', 'Manufacture of medical, precision and optical instruments, watches and clocks (33)', 'Manufacture of motor vehicles, trailers and semi-trailers (34)', 'Manufacture of other transport equipment (35)', 'Manufacture of furniture; manufacturing n.e.c. (36)', 'Recycling of waste and scrap', 'Recycling of bottles by direct reuse', 'Production of electricity by coal', 'Production of electricity by gas', 'Production of electricity by nuclear', 'Production of electricity by hydro', 'Production of electricity by wind', 'Production of electricity by petroleum and other oil derivatives', 'Production of electricity by biomass and waste', 'Production of electricity by solar photovoltaic', 'Production of electricity by solar thermal', 'Production of electricity by tide, wave, ocean', 'Production of electricity by Geothermal', 'Production of electricity nec', 'Transmission of electricity', 'Distribution and trade of electricity', 'Manufacture of gas; distribution of gaseous fuels through mains', 'Steam and hot water supply', 'Collection, purification and distribution of water (41)', 'Construction (45)', 'Re-processing of secondary construction material into aggregates', 'Sale, maintenance, repair of motor vehicles, motor vehicles parts, motorcycles, motor cycles parts and accessoiries', 'Retail sale of automotive fuel', 'Wholesale trade and commission trade, except of motor vehicles and motorcycles (51)', 'Retail trade, except of motor vehicles and motorcycles; repair of personal and household goods (52)', 'Hotels and restaurants (55)', 'Transport via railways', 'Other land transport', 'Transport via pipelines', 'Sea and coastal water transport', 'Inland water transport', 'Air transport (62)', 'Supporting and auxiliary transport activities; activities of travel agencies (63)', 'Post and telecommunications (64)', 'Financial intermediation, except insurance and pension funding (65)', 'Insurance and pension funding, except compulsory social security (66)', 'Activities auxiliary to financial intermediation (67)', 'Real estate activities (70)', 'Renting of machinery and equipment without operator and of personal and household goods (71)', 'Computer and related activities (72)', 'Research and development (73)', 'Other business activities (74)', 'Public administration and defence; compulsory social security (75)', 'Education (80)', 'Health and social work (85)', 'Incineration of waste: Food', 'Incineration of waste: Paper', 'Incineration of waste: Plastic', 'Incineration of waste: Metals and Inert materials', 'Incineration of waste: Textiles', 'Incineration of waste: Wood', 'Incineration of waste: Oil/Hazardous waste', 'Biogasification of food waste, incl. land application', 'Biogasification of paper, incl. land application', 'Biogasification of sewage slugde, incl. land application', 'Composting of food waste, incl. land application', 'Composting of paper and wood, incl. land application', 'Waste water treatment, food', 'Waste water treatment, other', 'Landfill of waste: Food', 'Landfill of waste: Paper', 'Landfill of waste: Plastic', 'Landfill of waste: Inert/metal/hazardous', 'Landfill of waste: Textiles', 'Landfill of waste: Wood', 'Activities of membership organisation n.e.c. (91)', 'Recreational, cultural and sporting activities (92)', 'Other service activities (93)', 'Private households with employed persons (95)', 'Extra-territorial organizations and bodies']
In [5]:
world.get_index('Commodity')
Out[5]:
['Paddy rice', 'Wheat', 'Cereal grains nec', 'Vegetables, fruit, nuts', 'Oil seeds', 'Sugar cane, sugar beet', 'Plant-based fibers', 'Crops nec', 'Cattle', 'Pigs', 'Poultry', 'Meat animals nec', 'Animal products nec', 'Raw milk', 'Wool, silk-worm cocoons', 'Manure (conventional treatment)', 'Manure (biogas treatment)', 'Products of forestry, logging and related services (02)', 'Fish and other fishing products; services incidental of fishing (05)', 'Anthracite', 'Coking Coal', 'Other Bituminous Coal', 'Sub-Bituminous Coal', 'Patent Fuel', 'Lignite/Brown Coal', 'BKB/Peat Briquettes', 'Peat', 'Crude petroleum and services related to crude oil extraction, excluding surveying', 'Natural gas and services related to natural gas extraction, excluding surveying', 'Natural Gas Liquids', 'Other Hydrocarbons', 'Uranium and thorium ores (12)', 'Iron ores', 'Copper ores and concentrates', 'Nickel ores and concentrates', 'Aluminium ores and concentrates', 'Precious metal ores and concentrates', 'Lead, zinc and tin ores and concentrates', 'Other non-ferrous metal ores and concentrates', 'Stone', 'Sand and clay', 'Chemical and fertilizer minerals, salt and other mining and quarrying products n.e.c.', 'Products of meat cattle', 'Products of meat pigs', 'Products of meat poultry', 'Meat products nec', 'products of Vegetable oils and fats', 'Dairy products', 'Processed rice', 'Sugar', 'Food products nec', 'Beverages', 'Fish products', 'Tobacco products (16)', 'Textiles (17)', 'Wearing apparel; furs (18)', 'Leather and leather products (19)', 'Wood and products of wood and cork (except furniture); articles of straw and plaiting materials (20)', 'Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Pulp', 'Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Paper and paper products', 'Printed matter and recorded media (22)', 'Coke Oven Coke', 'Gas Coke', 'Coal Tar', 'Motor Gasoline', 'Aviation Gasoline', 'Gasoline Type Jet Fuel', 'Kerosene Type Jet Fuel', 'Kerosene', 'Gas/Diesel Oil', 'Heavy Fuel Oil', 'Refinery Gas', 'Liquefied Petroleum Gases (LPG)', 'Refinery Feedstocks', 'Ethane', 'Naphtha', 'White Spirit & SBP', 'Lubricants', 'Bitumen', 'Paraffin Waxes', 'Petroleum Coke', 'Non-specified Petroleum Products', 'Nuclear fuel', 'Plastics, basic', 'Secondary plastic for treatment, Re-processing of secondary plastic into new plastic', 'N-fertiliser', 'P- and other fertiliser', 'Chemicals nec', 'Charcoal', 'Additives/Blending Components', 'Biogasoline', 'Biodiesels', 'Other Liquid Biofuels', 'Rubber and plastic products (25)', 'Glass and glass products', 'Secondary glass for treatment, Re-processing of secondary glass into new glass', 'Ceramic goods', 'Bricks, tiles and construction products, in baked clay', 'Cement, lime and plaster', 'Ash for treatment, Re-processing of ash into clinker', 'Other non-metallic mineral products', 'Basic iron and steel and of ferro-alloys and first products thereof', 'Secondary steel for treatment, Re-processing of secondary steel into new steel', 'Precious metals', 'Secondary preciuos metals for treatment, Re-processing of secondary preciuos metals into new preciuos metals', 'Aluminium and aluminium products', 'Secondary aluminium for treatment, Re-processing of secondary aluminium into new aluminium', 'Lead, zinc and tin and products thereof', 'Secondary lead for treatment, Re-processing of secondary lead into new lead', 'Copper products', 'Secondary copper for treatment, Re-processing of secondary copper into new copper', 'Other non-ferrous metal products', 'Secondary other non-ferrous metals for treatment, Re-processing of secondary other non-ferrous metals into new other non-ferrous metals', 'Foundry work services', 'Fabricated metal products, except machinery and equipment (28)', 'Machinery and equipment n.e.c. (29)', 'Office machinery and computers (30)', 'Electrical machinery and apparatus n.e.c. (31)', 'Radio, television and communication equipment and apparatus (32)', 'Medical, precision and optical instruments, watches and clocks (33)', 'Motor vehicles, trailers and semi-trailers (34)', 'Other transport equipment (35)', 'Furniture; other manufactured goods n.e.c. (36)', 'Secondary raw materials', 'Bottles for treatment, Recycling of bottles by direct reuse', 'Electricity by coal', 'Electricity by gas', 'Electricity by nuclear', 'Electricity by hydro', 'Electricity by wind', 'Electricity by petroleum and other oil derivatives', 'Electricity by biomass and waste', 'Electricity by solar photovoltaic', 'Electricity by solar thermal', 'Electricity by tide, wave, ocean', 'Electricity by Geothermal', 'Electricity nec', 'Transmission services of electricity', 'Distribution and trade services of electricity', 'Coke oven gas', 'Blast Furnace Gas', 'Oxygen Steel Furnace Gas', 'Gas Works Gas', 'Biogas', 'Distribution services of gaseous fuels through mains', 'Steam and hot water supply services', 'Collected and purified water, distribution services of water (41)', 'Construction work (45)', 'Secondary construction material for treatment, Re-processing of secondary construction material into aggregates', 'Sale, maintenance, repair of motor vehicles, motor vehicles parts, motorcycles, motor cycles parts and accessoiries', 'Retail trade services of motor fuel', 'Wholesale trade and commission trade services, except of motor vehicles and motorcycles (51)', 'Retail trade services, except of motor vehicles and motorcycles; repair services of personal and household goods (52)', 'Hotel and restaurant services (55)', 'Railway transportation services', 'Other land transportation services', 'Transportation services via pipelines', 'Sea and coastal water transportation services', 'Inland water transportation services', 'Air transport services (62)', 'Supporting and auxiliary transport services; travel agency services (63)', 'Post and telecommunication services (64)', 'Financial intermediation services, except insurance and pension funding services (65)', 'Insurance and pension funding services, except compulsory social security services (66)', 'Services auxiliary to financial intermediation (67)', 'Real estate services (70)', 'Renting services of machinery and equipment without operator and of personal and household goods (71)', 'Computer and related services (72)', 'Research and development services (73)', 'Other business services (74)', 'Public administration and defence services; compulsory social security services (75)', 'Education services (80)', 'Health and social work services (85)', 'Food waste for treatment: incineration', 'Paper waste for treatment: incineration', 'Plastic waste for treatment: incineration', 'Intert/metal waste for treatment: incineration', 'Textiles waste for treatment: incineration', 'Wood waste for treatment: incineration', 'Oil/hazardous waste for treatment: incineration', 'Food waste for treatment: biogasification and land application', 'Paper waste for treatment: biogasification and land application', 'Sewage sludge for treatment: biogasification and land application', 'Food waste for treatment: composting and land application', 'Paper and wood waste for treatment: composting and land application', 'Food waste for treatment: waste water treatment', 'Other waste for treatment: waste water treatment', 'Food waste for treatment: landfill', 'Paper for treatment: landfill', 'Plastic waste for treatment: landfill', 'Inert/metal/hazardous waste for treatment: landfill', 'Textiles waste for treatment: landfill', 'Wood waste for treatment: landfill', 'Membership organisation services n.e.c. (91)', 'Recreational, cultural and sporting services (92)', 'Other services (93)', 'Private households with employed persons (95)', 'Extra-territorial organizations and bodies']
In [6]:
# Aggregating the database
aggregation_path= r'C:\Users\payam\Desktop\MRSUT Test\Excels\aggregation_test.xlsx'
world.aggregate(
io= aggregation_path,
ignore_nan= True, # will ignore nans in the excel file and does not aggregate them
)
nan values for the aggregation of Activity for following items ignored ['Manufacture of furniture; manufacturing n.e.c. (36)', 'Recycling of waste and scrap', 'Recycling of bottles by direct reuse', 'Production of electricity by coal', 'Production of electricity by gas', 'Production of electricity by nuclear', 'Production of electricity by hydro', 'Production of electricity by wind', 'Production of electricity by petroleum and other oil derivatives', 'Production of electricity by biomass and waste', 'Production of electricity by solar photovoltaic', 'Production of electricity by solar thermal', 'Production of electricity by tide, wave, ocean', 'Production of electricity by Geothermal', 'Production of electricity nec', 'Transmission of electricity', 'Distribution and trade of electricity', 'Extra-territorial organizations and bodies'] ['unused'] does not found in Satellite account and can not be removed. ['unused'] does not found in Satellite account and can not be removed.
In [7]:
# new configuartion of database
print(world)
name = mrsut example table = SUT scenarios = ['baseline'] Activity = 22 Commodity = 4 Factor of production = 2 Satellite account = 1 Consumption category = 1 Region = 3
In [8]:
# calculating the multpliers
world.M
Database: to calculate M following matrices are need. ['m'].Trying to calculate dependencies. Database: to calculate m following matrices are need. ['w'].Trying to calculate dependencies.
Out[8]:
Europe | Asia | RoW | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Level | Commodity | Commodity | Commodity | ... | Activity | ||||||||||||||||
Agriculture | Mining | Manufacturing | Services | Agriculture | Mining | Manufacturing | Services | Agriculture | Mining | ... | Production of electricity by biomass and waste | Production of electricity by solar photovoltaic | Production of electricity by solar thermal | Production of electricity by tide, wave, ocean | Production of electricity by Geothermal | Production of electricity nec | Transmission of electricity | Distribution and trade of electricity | Services | Extra-territorial organizations and bodies | |
Value Added1 | 3.296589e+10 | 9.297474e+11 | 1.244670e+12 | 9.784042e+11 | 3.263168e+11 | 3.455338e+12 | 4.710777e+12 | 4.287542e+12 | 2.357422e+11 | 1.276377e+12 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Value Added2 | 9.444731e+10 | 1.499971e+12 | 2.695647e+12 | 2.102571e+12 | 3.521533e+11 | 4.816340e+12 | 7.935938e+12 | 7.233903e+12 | 1.893915e+11 | 1.300781e+12 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2 rows × 78 columns
In [9]:
# checking if the database is balanced
world.is_balanced('coefficients')
Out[9]:
True
In [ ]: