EORA parser
EORA26¶
In [1]:
import mario
import pandas as pd
In [2]:
folder_path = r'eora_files'
database_file = 'Eora26_2015_bp.zip'
indeces_file = 'indeces.zip'
world= mario.parse_eora(
path= rf'{folder_path}\{database_file}',
indeces= rf'{folder_path}\{indeces_file}',
multi_region= True,
year= 2015, # year of the datbase file
)
Parser; Deleting `ROW` from database due to inconsistency in the datbase and will be added to Z and Y matrix. C:\Users\payam\anaconda3\lib\site-packages\pandas\core\generic.py:4150: PerformanceWarning: dropping on a non-lexsorted multi-index without a level parameter may impact performance. C:\Users\payam\anaconda3\lib\site-packages\IPython\core\async_helpers.py:68: PerformanceWarning: indexing past lexsort depth may impact performance.
In [3]:
# Due to some inconsistency in database, some changes are implemenetd and recorded in metadata
world.meta_history
[13:13:56] Table added into metadata with value equal to IOT. [13:13:56] Price added into metadata with value equal to None. [13:13:56] Source added into metadata with value equal to Eora website @ https://www.worldmrio.com/. [13:13:56] Year added into metadata with value equal to 2015. [13:13:56] ROW deleted from database due to inconsistency. [13:13:56] Intermediate imports from ROW added to VA matrix [13:13:56] Intermediate exports to ROW added to Y matrix [13:13:56] Database successfully imported. [13:13:56] Number of Region = 189 [13:13:56] Number of Consumption category = 7 [13:13:56] Number of Satellite account = 2631 [13:13:56] Number of Factor of production = 7 [13:13:56] Number of Sector = 26
In [4]:
# checking if the datbase is balanced
world.is_balanced(
method= 'coefficients', # checking based on the coefficients method
margin= 0.3, # considering a margin of 0.5 (1.3 & 0.7) are considered as balanced
)
+----------------------------------------------------------------------------+---------------+ | | v+z | |----------------------------------------------------------------------------+---------------| | ('AFG', 'Sector', 'Re-export & Re-import') | 0.590342 | | ('ALB', 'Sector', 'Fishing') | 0.576508 | | ('ALB', 'Sector', 'Mining and Quarrying') | 0.235763 | | ('ALB', 'Sector', 'Hotels and Restraurants') | 0.536803 | | ('ALB', 'Sector', 'Transport') | 0.307692 | | ('ALB', 'Sector', 'Re-export & Re-import') | 0.683264 | | ('DZA', 'Sector', 'Re-export & Re-import') | 2.51327 | | ('AND', 'Sector', 'Fishing') | 0.547632 | | ('AND', 'Sector', 'Mining and Quarrying') | 0.501519 | | ('AND', 'Sector', 'Recycling') | 0.637035 | | ('AND', 'Sector', 'Transport') | 0.673593 | | ('AND', 'Sector', 'Re-export & Re-import') | 0.348236 | | ('AGO', 'Sector', 'Re-export & Re-import') | 0.420958 | | ('ATG', 'Sector', 'Fishing') | 1.61682 | | ('ATG', 'Sector', 'Mining and Quarrying') | 0.519493 | | ('ATG', 'Sector', 'Transport') | 0.573321 | | ('ATG', 'Sector', 'Re-export & Re-import') | 0.487125 | | ('ARG', 'Sector', 'Fishing') | 3.01443 | | ('ARG', 'Sector', 'Recycling') | 1.67963 | | ('ARM', 'Sector', 'Fishing') | 1.49406 | | ('ARM', 'Sector', 'Others') | 1.35824 | | ('ARM', 'Sector', 'Re-export & Re-import') | 0.531058 | | ('ABW', 'Sector', 'Agriculture') | 2.47029 | | ('ABW', 'Sector', 'Fishing') | 5.07896 | | ('ABW', 'Sector', 'Metal Products') | 1.30536 | | ('ABW', 'Sector', 'Recycling') | 0.665874 | | ('ABW', 'Sector', 'Others') | 1.92533 | | ('AUS', 'Sector', 'Electrical and Machinery') | 0.688453 | | ('AUS', 'Sector', 'Recycling') | 0.593457 | | ('AUS', 'Sector', 'Maintenance and Repair') | 1.48859 | | ('AUS', 'Sector', 'Wholesale Trade') | 1.56849 | | ('AUS', 'Sector', 'Retail Trade') | 1.4166 | | ('AUS', 'Sector', 'Others') | 1.46309 | | ('AUT', 'Sector', 'Fishing') | 2.79482 | | ('BHS', 'Sector', 'Re-export & Re-import') | 0.588265 | | ('BGD', 'Sector', 'Re-export & Re-import') | 1.34102 | | ('BRB', 'Sector', 'Agriculture') | 0.589933 | | ('BRB', 'Sector', 'Fishing') | 0.633125 | | ('BRB', 'Sector', 'Mining and Quarrying') | 0.303341 | | ('BRB', 'Sector', 'Hotels and Restraurants') | 0.680038 | | ('BRB', 'Sector', 'Transport') | 0.461713 | | ('BRB', 'Sector', 'Re-export & Re-import') | 0.566191 | | ('BLR', 'Sector', 'Agriculture') | 26.1626 | | ('BLR', 'Sector', 'Fishing') | 4.3086 | | ('BLR', 'Sector', 'Mining and Quarrying') | 6.47721 | | ('BLR', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 1.50353 | | ('BLR', 'Sector', 'Electrical and Machinery') | 1.53116 | | ('BLR', 'Sector', 'Transport Equipment') | 1.43127 | | ('BLR', 'Sector', 'Other Manufacturing') | 1.4499 | | ('BLR', 'Sector', 'Recycling') | 1.39854 | | ('BLR', 'Sector', 'Electricity, Gas and Water') | 5.55462 | | ('BLR', 'Sector', 'Construction') | 23.5242 | | ('BLR', 'Sector', 'Maintenance and Repair') | 1.80888 | | ('BLR', 'Sector', 'Wholesale Trade') | 9.48142 | | ('BLR', 'Sector', 'Retail Trade') | 1.79555 | | ('BLR', 'Sector', 'Hotels and Restraurants') | 2.70256 | | ('BLR', 'Sector', 'Transport') | 1.41897 | | ('BLR', 'Sector', 'Post and Telecommunications') | 1.42849 | | ('BLR', 'Sector', 'Finacial Intermediation and Business Activities') | 6.50146 | | ('BLR', 'Sector', 'Public Administration') | 4.86391 | | ('BLR', 'Sector', 'Education, Health and Other Services') | 13.3894 | | ('BLR', 'Sector', 'Private Households') | 1.8817 | | ('BLR', 'Sector', 'Others') | 2.47183 | | ('BLR', 'Sector', 'Re-export & Re-import') | 12.344 | | ('BEL', 'Sector', 'Mining and Quarrying') | 0.395648 | | ('BEL', 'Sector', 'Recycling') | 142.209 | | ('BEL', 'Sector', 'Retail Trade') | 1.38805 | | ('BLZ', 'Sector', 'Mining and Quarrying') | 0.6132 | | ('BLZ', 'Sector', 'Recycling') | 0.693102 | | ('BLZ', 'Sector', 'Transport') | 0.555702 | | ('BLZ', 'Sector', 'Re-export & Re-import') | 0.440904 | | ('BEN', 'Sector', 'Mining and Quarrying') | 0.367488 | | ('BEN', 'Sector', 'Transport') | 0.585462 | | ('BMU', 'Sector', 'Recycling') | 0.688222 | | ('BMU', 'Sector', 'Re-export & Re-import') | 0.594837 | | ('BTN', 'Sector', 'Fishing') | 2.07803 | | ('BOL', 'Sector', 'Re-export & Re-import') | 0.293407 | | ('BIH', 'Sector', 'Fishing') | 0.451499 | | ('BIH', 'Sector', 'Mining and Quarrying') | 0.370087 | | ('BIH', 'Sector', 'Hotels and Restraurants') | 0.677651 | | ('BIH', 'Sector', 'Transport') | 0.458951 | | ('BIH', 'Sector', 'Re-export & Re-import') | 0.686649 | | ('BWA', 'Sector', 'Fishing') | 0.698791 | | ('BWA', 'Sector', 'Re-export & Re-import') | 0.535392 | | ('BRA', 'Sector', 'Fishing') | 8.67084 | | ('BRA', 'Sector', 'Recycling') | 11.3354 | | ('BRA', 'Sector', 'Private Households') | 0.0124887 | | ('BRA', 'Sector', 'Others') | 2.03962 | | ('VGB', 'Sector', 'Re-export & Re-import') | 0.510268 | | ('BRN', 'Sector', 'Re-export & Re-import') | 0.655047 | | ('BGR', 'Sector', 'Fishing') | 0.690627 | | ('BFA', 'Sector', 'Re-export & Re-import') | 1.93293 | | ('BDI', 'Sector', 'Fishing') | 2.66292 | | ('BDI', 'Sector', 'Transport') | 0.609811 | | ('BDI', 'Sector', 'Re-export & Re-import') | 0.536804 | | ('KHM', 'Sector', 'Mining and Quarrying') | 0.623751 | | ('KHM', 'Sector', 'Re-export & Re-import') | 0.562384 | | ('CMR', 'Sector', 'Fishing') | 0.626247 | | ('CMR', 'Sector', 'Mining and Quarrying') | 0.581452 | | ('CMR', 'Sector', 'Transport') | 0.61701 | | ('CPV', 'Sector', 'Fishing') | 1.6729 | | ('CPV', 'Sector', 'Mining and Quarrying') | 0.535754 | | ('CPV', 'Sector', 'Recycling') | 0.693308 | | ('CPV', 'Sector', 'Re-export & Re-import') | 0.457244 | | ('CYM', 'Sector', 'Fishing') | 1.60682 | | ('CYM', 'Sector', 'Re-export & Re-import') | 0.327857 | | ('CAF', 'Sector', 'Fishing') | 1.89616 | | ('CAF', 'Sector', 'Mining and Quarrying') | 0.508542 | | ('CAF', 'Sector', 'Transport') | 0.549888 | | ('CAF', 'Sector', 'Re-export & Re-import') | 0.57596 | | ('TCD', 'Sector', 'Fishing') | 1.56801 | | ('TCD', 'Sector', 'Mining and Quarrying') | 0.595288 | | ('TCD', 'Sector', 'Transport') | 0.652937 | | ('TCD', 'Sector', 'Re-export & Re-import') | 0.473825 | | ('CHL', 'Sector', 'Recycling') | 0.684945 | | ('CHL', 'Sector', 'Private Households') | 0.2133 | | ('CHL', 'Sector', 'Others') | 4607.15 | | ('CHN', 'Sector', 'Re-export & Re-import') | 2.46449 | | ('COL', 'Sector', 'Agriculture') | 4.34253 | | ('COL', 'Sector', 'Mining and Quarrying') | 1.49347 | | ('COL', 'Sector', 'Food & Beverages') | 0.688632 | | ('COL', 'Sector', 'Wood and Paper') | 1.65472 | | ('COL', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 1.33113 | | ('COL', 'Sector', 'Electrical and Machinery') | 0.439157 | | ('COL', 'Sector', 'Transport Equipment') | 0.636815 | | ('COL', 'Sector', 'Recycling') | 0.361296 | | ('COL', 'Sector', 'Construction') | 0.135239 | | ('COL', 'Sector', 'Maintenance and Repair') | 15.5235 | | ('COL', 'Sector', 'Wholesale Trade') | 15.5235 | | ('COL', 'Sector', 'Retail Trade') | 15.5235 | | ('COL', 'Sector', 'Hotels and Restraurants') | 0.463457 | | ('COL', 'Sector', 'Transport') | 0.455102 | | ('COL', 'Sector', 'Finacial Intermediation and Business Activities') | 0.245587 | | ('COL', 'Sector', 'Public Administration') | 2.301 | | ('COL', 'Sector', 'Education, Health and Other Services') | 0.612844 | | ('COL', 'Sector', 'Others') | 2.51595 | | ('COL', 'Sector', 'Re-export & Re-import') | 1.64535 | | ('COG', 'Sector', 'Re-export & Re-import') | 0.673128 | | ('CRI', 'Sector', 'Re-export & Re-import') | 1.3522 | | ('HRV', 'Sector', 'Fishing') | 0.618804 | | ('HRV', 'Sector', 'Mining and Quarrying') | 0.645799 | | ('HRV', 'Sector', 'Transport') | 0.644042 | | ('CUB', 'Sector', 'Fishing') | 0.41038 | | ('CUB', 'Sector', 'Mining and Quarrying') | 0.572574 | | ('CYP', 'Sector', 'Fishing') | 0.493851 | | ('CYP', 'Sector', 'Mining and Quarrying') | 0.563142 | | ('CYP', 'Sector', 'Transport') | 0.652525 | | ('CYP', 'Sector', 'Re-export & Re-import') | 0.346601 | | ('CZE', 'Sector', 'Private Households') | 1.53677 | | ('CZE', 'Sector', 'Re-export & Re-import') | 0.225994 | | ('CIV', 'Sector', 'Mining and Quarrying') | 0.671006 | | ('CIV', 'Sector', 'Re-export & Re-import') | 0.638763 | | ('PRK', 'Sector', 'Re-export & Re-import') | 0.337202 | | ('COD', 'Sector', 'Re-export & Re-import') | 0.395185 | | ('DJI', 'Sector', 'Fishing') | 2.07902 | | ('DJI', 'Sector', 'Mining and Quarrying') | 0.464522 | | ('DJI', 'Sector', 'Hotels and Restraurants') | 0.675304 | | ('DJI', 'Sector', 'Transport') | 0.60458 | | ('DJI', 'Sector', 'Re-export & Re-import') | 0.425403 | | ('DOM', 'Sector', 'Fishing') | 0.501049 | | ('DOM', 'Sector', 'Re-export & Re-import') | 1.75834 | | ('ECU', 'Sector', 'Wood and Paper') | 1.71767 | | ('ECU', 'Sector', 'Other Manufacturing') | 0.0858897 | | ('ECU', 'Sector', 'Recycling') | 0.0858898 | | ('ECU', 'Sector', 'Re-export & Re-import') | 0.392069 | | ('EGY', 'Sector', 'Re-export & Re-import') | 3.53006 | | ('SLV', 'Sector', 'Fishing') | 0.5791 | | ('SLV', 'Sector', 'Mining and Quarrying') | 0.619338 | | ('SLV', 'Sector', 'Re-export & Re-import') | 0.339895 | | ('ERI', 'Sector', 'Fishing') | 2.15267 | | ('ERI', 'Sector', 'Mining and Quarrying') | 0.379123 | | ('ERI', 'Sector', 'Transport') | 0.62978 | | ('ERI', 'Sector', 'Re-export & Re-import') | 0.425214 | | ('EST', 'Sector', 'Recycling') | 3.81724 | | ('EST', 'Sector', 'Private Households') | 1.72198 | | ('ETH', 'Sector', 'Agriculture') | 3.86677 | | ('ETH', 'Sector', 'Fishing') | 59.283 | | ('ETH', 'Sector', 'Mining and Quarrying') | 7.03749 | | ('ETH', 'Sector', 'Food & Beverages') | 4.38696 | | ('ETH', 'Sector', 'Textiles and Wearing Apparel') | 4.39306 | | ('ETH', 'Sector', 'Wood and Paper') | 16.6021 | | ('ETH', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 7.92316 | | ('ETH', 'Sector', 'Metal Products') | 11.3346 | | ('ETH', 'Sector', 'Electrical and Machinery') | 4.69687 | | ('ETH', 'Sector', 'Transport Equipment') | 10.391 | | ('ETH', 'Sector', 'Other Manufacturing') | 14.8769 | | ('ETH', 'Sector', 'Recycling') | 14.391 | | ('ETH', 'Sector', 'Electricity, Gas and Water') | 9.30984 | | ('ETH', 'Sector', 'Construction') | 6.54581 | | ('ETH', 'Sector', 'Maintenance and Repair') | 12.5854 | | ('ETH', 'Sector', 'Wholesale Trade') | 7.3907 | | ('ETH', 'Sector', 'Retail Trade') | 11.0661 | | ('ETH', 'Sector', 'Hotels and Restraurants') | 8.0149 | | ('ETH', 'Sector', 'Transport') | 4.26697 | | ('ETH', 'Sector', 'Post and Telecommunications') | 6.14041 | | ('ETH', 'Sector', 'Finacial Intermediation and Business Activities') | 6.74409 | | ('ETH', 'Sector', 'Public Administration') | 8.33629 | | ('ETH', 'Sector', 'Education, Health and Other Services') | 8.08222 | | ('ETH', 'Sector', 'Private Households') | 14.9176 | | ('ETH', 'Sector', 'Others') | 16.7393 | | ('ETH', 'Sector', 'Re-export & Re-import') | 2.0456 | | ('FJI', 'Sector', 'Fishing') | 0.595422 | | ('FJI', 'Sector', 'Mining and Quarrying') | 0.28553 | | ('FJI', 'Sector', 'Hotels and Restraurants') | 0.667253 | | ('FJI', 'Sector', 'Transport') | 0.507693 | | ('FJI', 'Sector', 'Re-export & Re-import') | 0.572823 | | ('FIN', 'Sector', 'Recycling') | 5.27798 | | ('FRA', 'Sector', 'Recycling') | 120.021 | | ('PYF', 'Sector', 'Mining and Quarrying') | 0.524065 | | ('PYF', 'Sector', 'Transport') | 0.665538 | | ('PYF', 'Sector', 'Re-export & Re-import') | 0.557539 | | ('GAB', 'Sector', 'Fishing') | 0.614878 | | ('GAB', 'Sector', 'Mining and Quarrying') | 0.664597 | | ('GAB', 'Sector', 'Transport') | 0.564642 | | ('GMB', 'Sector', 'Fishing') | 1.51396 | | ('GMB', 'Sector', 'Recycling') | 0.461423 | | ('GMB', 'Sector', 'Private Households') | 0.47602 | | ('GMB', 'Sector', 'Others') | 0.589492 | | ('GMB', 'Sector', 'Re-export & Re-import') | 0.408144 | | ('GEO', 'Sector', 'Food & Beverages') | 0.528209 | | ('GEO', 'Sector', 'Textiles and Wearing Apparel') | 2.47203 | | ('GEO', 'Sector', 'Wood and Paper') | 0.26593 | | ('GEO', 'Sector', 'Transport Equipment') | 0.164004 | | ('GEO', 'Sector', 'Other Manufacturing') | 2.45257 | | ('GEO', 'Sector', 'Recycling') | 2.45257 | | ('GEO', 'Sector', 'Wholesale Trade') | 1.99976 | | ('GEO', 'Sector', 'Private Households') | 85.5445 | | ('GEO', 'Sector', 'Re-export & Re-import') | 0.607937 | | ('GHA', 'Sector', 'Fishing') | 0.696141 | | ('GHA', 'Sector', 'Mining and Quarrying') | 0.590392 | | ('GRL', 'Sector', 'Wood and Paper') | 1.51129 | | ('GRL', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 2.34985 | | ('GRL', 'Sector', 'Metal Products') | 1.52126 | | ('GRL', 'Sector', 'Electrical and Machinery') | 1.52126 | | ('GRL', 'Sector', 'Transport Equipment') | 1.52127 | | ('GRL', 'Sector', 'Other Manufacturing') | 1.52127 | | ('GRL', 'Sector', 'Recycling') | 1.52127 | | ('GTM', 'Sector', 'Re-export & Re-import') | 1.35603 | | ('GIN', 'Sector', 'Transport') | 0.588065 | | ('GIN', 'Sector', 'Re-export & Re-import') | 0.679896 | | ('GUY', 'Sector', 'Agriculture') | 0.58075 | | ('GUY', 'Sector', 'Fishing') | 0.366339 | | ('GUY', 'Sector', 'Mining and Quarrying') | 0.420226 | | ('GUY', 'Sector', 'Re-export & Re-import') | -0.116821 | | ('HTI', 'Sector', 'Mining and Quarrying') | 0.564972 | | ('HTI', 'Sector', 'Re-export & Re-import') | 0.695746 | | ('HKG', 'Sector', 'Re-export & Re-import') | 0.565741 | | ('HUN', 'Sector', 'Private Households') | 1.55957 | | ('ISL', 'Sector', 'Mining and Quarrying') | 0.373392 | | ('ISL', 'Sector', 'Hotels and Restraurants') | 0.609355 | | ('ISL', 'Sector', 'Re-export & Re-import') | 0.639594 | | ('IND', 'Sector', 'Textiles and Wearing Apparel') | 1.30381 | | ('IND', 'Sector', 'Private Households') | 0.506093 | | ('IND', 'Sector', 'Others') | 0.506092 | | ('IND', 'Sector', 'Re-export & Re-import') | 1.53377 | | ('IRN', 'Sector', 'Fishing') | 1.81153 | | ('IRN', 'Sector', 'Mining and Quarrying') | 1.53436 | | ('IRN', 'Sector', 'Textiles and Wearing Apparel') | 1.80418 | | ('IRN', 'Sector', 'Wood and Paper') | 2.32137 | | ('IRN', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 0.347997 | | ('IRN', 'Sector', 'Metal Products') | 1.98487 | | ('IRN', 'Sector', 'Transport Equipment') | 0.54668 | | ('IRN', 'Sector', 'Other Manufacturing') | 1.80694 | | ('IRN', 'Sector', 'Recycling') | 3.79461 | | ('IRN', 'Sector', 'Electricity, Gas and Water') | 7.28841 | | ('IRN', 'Sector', 'Construction') | 0.213668 | | ('IRN', 'Sector', 'Maintenance and Repair') | 0.633852 | | ('IRN', 'Sector', 'Wholesale Trade') | 0.633852 | | ('IRN', 'Sector', 'Retail Trade') | 0.633852 | | ('IRN', 'Sector', 'Hotels and Restraurants') | 1.85438 | | ('IRN', 'Sector', 'Post and Telecommunications') | 2.20241 | | ('IRN', 'Sector', 'Finacial Intermediation and Business Activities') | 0.663701 | | ('IRN', 'Sector', 'Public Administration') | 1.59376 | | ('IRN', 'Sector', 'Education, Health and Other Services') | 1.64055 | | ('IRN', 'Sector', 'Private Households') | 9.73685 | | ('IRN', 'Sector', 'Others') | 9.73686 | | ('IRN', 'Sector', 'Re-export & Re-import') | 0.555862 | | ('IRL', 'Sector', 'Other Manufacturing') | 0.688124 | | ('ISR', 'Sector', 'Re-export & Re-import') | 20.0482 | | ('ITA', 'Sector', 'Re-export & Re-import') | 1.38054 | | ('JPN', 'Sector', 'Re-export & Re-import') | 0.153804 | | ('KAZ', 'Sector', 'Re-export & Re-import') | 0.481204 | | ('KWT', 'Sector', 'Private Households') | 1.82015 | | ('KWT', 'Sector', 'Re-export & Re-import') | 3.30106 | | ('KGZ', 'Sector', 'Fishing') | 4.80647 | | ('KGZ', 'Sector', 'Wood and Paper') | 0.681305 | | ('KGZ', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 0.61834 | | ('KGZ', 'Sector', 'Maintenance and Repair') | 12.511 | | ('KGZ', 'Sector', 'Wholesale Trade') | 6.25691 | | ('KGZ', 'Sector', 'Retail Trade') | 14.2979 | | ('KGZ', 'Sector', 'Private Households') | 0.562898 | | ('KGZ', 'Sector', 'Others') | 0.562898 | | ('LAO', 'Sector', 'Re-export & Re-import') | 0.482284 | | ('LVA', 'Sector', 'Hotels and Restraurants') | 0.63953 | | ('LVA', 'Sector', 'Private Households') | 0.462012 | | ('LVA', 'Sector', 'Re-export & Re-import') | 2.14564 | | ('LBN', 'Sector', 'Fishing') | 0.678848 | | ('LBN', 'Sector', 'Mining and Quarrying') | 0.557127 | | ('LBR', 'Sector', 'Fishing') | 1.32923 | | ('LBR', 'Sector', 'Mining and Quarrying') | 0.381612 | | ('LBR', 'Sector', 'Textiles and Wearing Apparel') | 0.667472 | | ('LBR', 'Sector', 'Other Manufacturing') | 0.682866 | | ('LBR', 'Sector', 'Recycling') | 0.425856 | | ('LBR', 'Sector', 'Maintenance and Repair') | 0.539178 | | ('LBR', 'Sector', 'Hotels and Restraurants') | 0.679329 | | ('LBR', 'Sector', 'Transport') | 0.505332 | | ('LBR', 'Sector', 'Private Households') | 0.449195 | | ('LBR', 'Sector', 'Others') | 0.527347 | | ('LBR', 'Sector', 'Re-export & Re-import') | 0.473632 | | ('LTU', 'Sector', 'Agriculture') | 1.37448 | | ('LTU', 'Sector', 'Fishing') | 0.687091 | | ('LUX', 'Sector', 'Fishing') | 3.80894 | | ('LUX', 'Sector', 'Recycling') | 2.46661 | | ('MAC', 'Sector', 'Agriculture') | 0.61849 | | ('MAC', 'Sector', 'Fishing') | -1.78692 | | ('MAC', 'Sector', 'Mining and Quarrying') | 0.176629 | | ('MAC', 'Sector', 'Transport') | 0.577197 | | ('MAC', 'Sector', 'Re-export & Re-import') | 0.441478 | | ('MDG', 'Sector', 'Mining and Quarrying') | 0.406378 | | ('MDG', 'Sector', 'Transport') | 0.647738 | | ('MDG', 'Sector', 'Re-export & Re-import') | 0.676545 | | ('MWI', 'Sector', 'Mining and Quarrying') | 0.695759 | | ('MWI', 'Sector', 'Re-export & Re-import') | 0.409779 | | ('MYS', 'Sector', 'Others') | 4.35267 | | ('MDV', 'Sector', 'Recycling') | 0.447194 | | ('MDV', 'Sector', 'Private Households') | 0.513603 | | ('MDV', 'Sector', 'Re-export & Re-import') | 0.28436 | | ('MLI', 'Sector', 'Mining and Quarrying') | 0.456377 | | ('MLI', 'Sector', 'Transport') | 0.566504 | | ('MLI', 'Sector', 'Re-export & Re-import') | 0.691964 | | ('MLT', 'Sector', 'Re-export & Re-import') | 0.38238 | | ('MRT', 'Sector', 'Recycling') | 0.619361 | | ('MRT', 'Sector', 'Re-export & Re-import') | 0.560833 | | ('MUS', 'Sector', 'Mining and Quarrying') | 0.208138 | | ('MUS', 'Sector', 'Electrical and Machinery') | 0.473155 | | ('MUS', 'Sector', 'Transport Equipment') | 0.259332 | | ('MUS', 'Sector', 'Other Manufacturing') | 1.32327 | | ('MUS', 'Sector', 'Recycling') | 13.3532 | | ('MUS', 'Sector', 'Maintenance and Repair') | 1.45386 | | ('MUS', 'Sector', 'Wholesale Trade') | 0.427225 | | ('MUS', 'Sector', 'Retail Trade') | 4.63867 | | ('MUS', 'Sector', 'Private Households') | 0.00591609 | | ('MUS', 'Sector', 'Others') | 70.9943 | | ('MUS', 'Sector', 'Re-export & Re-import') | 0.59649 | | ('MEX', 'Sector', 'Re-export & Re-import') | 1.51827 | | ('MCO', 'Sector', 'Fishing') | 0.538732 | | ('MCO', 'Sector', 'Recycling') | 0.659676 | | ('MCO', 'Sector', 'Re-export & Re-import') | 0.537505 | | ('MNE', 'Sector', 'Mining and Quarrying') | 0.551087 | | ('MNE', 'Sector', 'Transport') | 0.502927 | | ('MNE', 'Sector', 'Re-export & Re-import') | 1.62757 | | ('MAR', 'Sector', 'Re-export & Re-import') | 2.65221 | | ('MMR', 'Sector', 'Re-export & Re-import') | 1.48084 | | ('NAM', 'Sector', 'Re-export & Re-import') | 0.631566 | | ('NPL', 'Sector', 'Mining and Quarrying') | 0.670537 | | ('NLD', 'Sector', 'Fishing') | 1.36043 | | ('NLD', 'Sector', 'Other Manufacturing') | 1.32701 | | ('NLD', 'Sector', 'Recycling') | 1.44051 | | ('NLD', 'Sector', 'Others') | 0.643124 | | ('ANT', 'Sector', 'Mining and Quarrying') | 0.225796 | | ('ANT', 'Sector', 'Food & Beverages') | 0.394789 | | ('ANT', 'Sector', 'Textiles and Wearing Apparel') | 7.3702 | | ('ANT', 'Sector', 'Wood and Paper') | 7.61004 | | ('ANT', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 0.535109 | | ('ANT', 'Sector', 'Electrical and Machinery') | 1.39447 | | ('ANT', 'Sector', 'Transport Equipment') | 0.37488 | | ('ANT', 'Sector', 'Other Manufacturing') | 1.45639 | | ('ANT', 'Sector', 'Recycling') | 1.45639 | | ('ANT', 'Sector', 'Post and Telecommunications') | 0.566629 | | ('ANT', 'Sector', 'Education, Health and Other Services') | 1.33039 | | ('ANT', 'Sector', 'Private Households') | 0.626495 | | ('ANT', 'Sector', 'Others') | 0.183568 | | ('ANT', 'Sector', 'Re-export & Re-import') | 1.59547 | | ('NCL', 'Sector', 'Re-export & Re-import') | 0.650205 | | ('NZL', 'Sector', 'Recycling') | 10.0595 | | ('NZL', 'Sector', 'Maintenance and Repair') | 1.72052 | | ('NZL', 'Sector', 'Wholesale Trade') | 1.67256 | | ('NZL', 'Sector', 'Retail Trade') | 1.77523 | | ('NIC', 'Sector', 'Re-export & Re-import') | 0.545079 | | ('NER', 'Sector', 'Fishing') | 1.31383 | | ('NER', 'Sector', 'Recycling') | 0.694501 | | ('NGA', 'Sector', 'Re-export & Re-import') | 2.85641 | | ('NOR', 'Sector', 'Recycling') | 1.30914 | | ('PSE', 'Sector', 'Mining and Quarrying') | 0.624775 | | ('OMN', 'Sector', 'Re-export & Re-import') | 1.32125 | | ('PAK', 'Sector', 'Re-export & Re-import') | 2.37949 | | ('PNG', 'Sector', 'Re-export & Re-import') | 0.687337 | | ('PRY', 'Sector', 'Metal Products') | 0.498559 | | ('PRY', 'Sector', 'Electrical and Machinery') | 3.10287 | | ('PRY', 'Sector', 'Transport Equipment') | 0.248097 | | ('PRY', 'Sector', 'Transport') | 0.632701 | | ('PRY', 'Sector', 'Re-export & Re-import') | 2.03593 | | ('POL', 'Sector', 'Recycling') | 1.38202 | | ('PRT', 'Sector', 'Re-export & Re-import') | 0.42461 | | ('QAT', 'Sector', 'Re-export & Re-import') | 1.35223 | | ('MDA', 'Sector', 'Agriculture') | 6.18846 | | ('MDA', 'Sector', 'Fishing') | 9.72973 | | ('MDA', 'Sector', 'Mining and Quarrying') | 11.5293 | | ('MDA', 'Sector', 'Food & Beverages') | 4.9538 | | ('MDA', 'Sector', 'Textiles and Wearing Apparel') | 4.58124 | | ('MDA', 'Sector', 'Wood and Paper') | 7.99061 | | ('MDA', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 8.07634 | | ('MDA', 'Sector', 'Metal Products') | 5.68229 | | ('MDA', 'Sector', 'Electrical and Machinery') | 6.87075 | | ('MDA', 'Sector', 'Transport Equipment') | 6.46095 | | ('MDA', 'Sector', 'Other Manufacturing') | 6.48972 | | ('MDA', 'Sector', 'Recycling') | 5.68197 | | ('MDA', 'Sector', 'Electricity, Gas and Water') | 7.81911 | | ('MDA', 'Sector', 'Construction') | 7.96199 | | ('MDA', 'Sector', 'Maintenance and Repair') | 6.70893 | | ('MDA', 'Sector', 'Wholesale Trade') | 6.16538 | | ('MDA', 'Sector', 'Retail Trade') | 58.91 | | ('MDA', 'Sector', 'Hotels and Restraurants') | 8.14513 | | ('MDA', 'Sector', 'Transport') | 5.60782 | | ('MDA', 'Sector', 'Post and Telecommunications') | 7.52637 | | ('MDA', 'Sector', 'Finacial Intermediation and Business Activities') | 7.00899 | | ('MDA', 'Sector', 'Public Administration') | 11.3311 | | ('MDA', 'Sector', 'Education, Health and Other Services') | 9.54645 | | ('MDA', 'Sector', 'Private Households') | 5.71053 | | ('MDA', 'Sector', 'Others') | 75.168 | | ('MDA', 'Sector', 'Re-export & Re-import') | 43.8839 | | ('ROU', 'Sector', 'Recycling') | 0.388788 | | ('ROU', 'Sector', 'Others') | 1.49361 | | ('RUS', 'Sector', 'Transport Equipment') | 0.204647 | | ('RUS', 'Sector', 'Hotels and Restraurants') | 0.413987 | | ('RUS', 'Sector', 'Post and Telecommunications') | 0.252666 | | ('RUS', 'Sector', 'Private Households') | 0.263346 | | ('RUS', 'Sector', 'Others') | 0.263346 | | ('RWA', 'Sector', 'Fishing') | 1.75733 | | ('RWA', 'Sector', 'Mining and Quarrying') | 0.571349 | | ('RWA', 'Sector', 'Recycling') | 1.4633 | | ('RWA', 'Sector', 'Re-export & Re-import') | 1.72752 | | ('WSM', 'Sector', 'Fishing') | 2.086 | | ('WSM', 'Sector', 'Recycling') | 0.620649 | | ('WSM', 'Sector', 'Private Households') | 0.52558 | | ('WSM', 'Sector', 'Re-export & Re-import') | 0.42665 | | ('SMR', 'Sector', 'Fishing') | 2.33925 | | ('SMR', 'Sector', 'Mining and Quarrying') | 0.680796 | | ('SMR', 'Sector', 'Recycling') | 1.34075 | | ('SMR', 'Sector', 'Others') | 1.56046 | | ('STP', 'Sector', 'Agriculture') | 1.43414 | | ('STP', 'Sector', 'Fishing') | 4.18707 | | ('STP', 'Sector', 'Private Households') | 0.543546 | | ('STP', 'Sector', 'Re-export & Re-import') | 0.506051 | | ('SAU', 'Sector', 'Re-export & Re-import') | 9.92775 | | ('SEN', 'Sector', 'Fishing') | 0.586724 | | ('SEN', 'Sector', 'Mining and Quarrying') | 0.682577 | | ('SEN', 'Sector', 'Transport') | 0.543297 | | ('SRB', 'Sector', 'Mining and Quarrying') | 0.605151 | | ('SRB', 'Sector', 'Transport') | 0.665991 | | ('SRB', 'Sector', 'Re-export & Re-import') | 5.75971 | | ('SYC', 'Sector', 'Agriculture') | 0.491853 | | ('SYC', 'Sector', 'Fishing') | 0.552277 | | ('SYC', 'Sector', 'Mining and Quarrying') | 0.176701 | | ('SYC', 'Sector', 'Hotels and Restraurants') | 0.477408 | | ('SYC', 'Sector', 'Transport') | 0.310148 | | ('SYC', 'Sector', 'Finacial Intermediation and Business Activities') | 0.689564 | | ('SYC', 'Sector', 'Private Households') | 0.658554 | | ('SYC', 'Sector', 'Re-export & Re-import') | 0.334876 | | ('SLE', 'Sector', 'Fishing') | 1.57172 | | ('SLE', 'Sector', 'Recycling') | 0.67595 | | ('SLE', 'Sector', 'Transport') | 0.623753 | | ('SGP', 'Sector', 'Mining and Quarrying') | 0.63283 | | ('SGP', 'Sector', 'Re-export & Re-import') | 0.362893 | | ('SVK', 'Sector', 'Wholesale Trade') | 1.39351 | | ('SVK', 'Sector', 'Private Households') | 1.37956 | | ('SVN', 'Sector', 'Retail Trade') | 0.639084 | | ('SVN', 'Sector', 'Private Households') | 1.5169 | | ('SVN', 'Sector', 'Re-export & Re-import') | 1.32029 | | ('SOM', 'Sector', 'Fishing') | 2.36657 | | ('SOM', 'Sector', 'Mining and Quarrying') | 0.210499 | | ('SOM', 'Sector', 'Hotels and Restraurants') | 0.64416 | | ('SOM', 'Sector', 'Transport') | 0.449532 | | ('ZAF', 'Sector', 'Recycling') | 1.36609 | | ('ZAF', 'Sector', 'Private Households') | 0.578792 | | ('ZAF', 'Sector', 'Others') | 0.578793 | | ('ESP', 'Sector', 'Maintenance and Repair') | 0.120444 | | ('ESP', 'Sector', 'Private Households') | 289.483 | | ('ESP', 'Sector', 'Re-export & Re-import') | 8.34156 | | ('SUD', 'Sector', 'Re-export & Re-import') | 40.4157 | | ('SWZ', 'Sector', 'Fishing') | 1.62611 | | ('SWZ', 'Sector', 'Mining and Quarrying') | 0.339474 | | ('SWZ', 'Sector', 'Recycling') | 1.63893 | | ('SWZ', 'Sector', 'Hotels and Restraurants') | 0.696829 | | ('SWZ', 'Sector', 'Transport') | 0.493104 | | ('SWZ', 'Sector', 'Re-export & Re-import') | 0.530081 | | ('SWE', 'Sector', 'Wholesale Trade') | 0.107639 | | ('SWE', 'Sector', 'Retail Trade') | 2.38436 | | ('CHE', 'Sector', 'Recycling') | 1.74758 | | ('CHE', 'Sector', 'Public Administration') | 3.70809 | | ('CHE', 'Sector', 'Re-export & Re-import') | 0.0483251 | | ('SYR', 'Sector', 'Re-export & Re-import') | 1.31428 | | ('THA', 'Sector', 'Re-export & Re-import') | 0.567591 | | ('MKD', 'Sector', 'Fishing') | 1.60939 | | ('MKD', 'Sector', 'Mining and Quarrying') | 0.371314 | | ('MKD', 'Sector', 'Maintenance and Repair') | 0.489782 | | ('MKD', 'Sector', 'Hotels and Restraurants') | 0.645584 | | ('MKD', 'Sector', 'Private Households') | 0.417274 | | ('MKD', 'Sector', 'Re-export & Re-import') | 1.5252 | | ('TGO', 'Sector', 'Mining and Quarrying') | 0.473924 | | ('TGO', 'Sector', 'Transport') | 0.522329 | | ('TGO', 'Sector', 'Re-export & Re-import') | 0.497329 | | ('TTO', 'Sector', 'Re-export & Re-import') | 0.597277 | | ('TUN', 'Sector', 'Fishing') | 0.663696 | | ('TUN', 'Sector', 'Mining and Quarrying') | 0.660655 | | ('TKM', 'Sector', 'Re-export & Re-import') | 0.296736 | | ('USR', 'Sector', 'Agriculture') | 3.84318 | | ('USR', 'Sector', 'Fishing') | 3.84832 | | ('USR', 'Sector', 'Mining and Quarrying') | 3.87224 | | ('USR', 'Sector', 'Food & Beverages') | 3.89629 | | ('USR', 'Sector', 'Textiles and Wearing Apparel') | 3.92064 | | ('USR', 'Sector', 'Wood and Paper') | 3.94522 | | ('USR', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 3.97002 | | ('USR', 'Sector', 'Metal Products') | 3.99505 | | ('USR', 'Sector', 'Electrical and Machinery') | 4.02033 | | ('USR', 'Sector', 'Transport Equipment') | 4.04583 | | ('USR', 'Sector', 'Other Manufacturing') | 4.07158 | | ('USR', 'Sector', 'Recycling') | 4.09757 | | ('USR', 'Sector', 'Electricity, Gas and Water') | 4.12391 | | ('USR', 'Sector', 'Construction') | 4.15223 | | ('USR', 'Sector', 'Maintenance and Repair') | 4.17894 | | ('USR', 'Sector', 'Wholesale Trade') | 4.20597 | | ('USR', 'Sector', 'Retail Trade') | 4.23327 | | ('USR', 'Sector', 'Hotels and Restraurants') | 4.26085 | | ('USR', 'Sector', 'Transport') | 4.28875 | | ('USR', 'Sector', 'Post and Telecommunications') | 4.31689 | | ('USR', 'Sector', 'Finacial Intermediation and Business Activities') | 4.34336 | | ('USR', 'Sector', 'Public Administration') | 4.37397 | | ('USR', 'Sector', 'Education, Health and Other Services') | 4.40298 | | ('USR', 'Sector', 'Private Households') | 4.4323 | | ('USR', 'Sector', 'Others') | 4.45996 | | ('USR', 'Sector', 'Re-export & Re-import') | 4.44419 | | ('UGA', 'Sector', 'Mining and Quarrying') | 0.616635 | | ('ARE', 'Sector', 'Re-export & Re-import') | 5.09356 | | ('GBR', 'Sector', 'Recycling') | 1.67097 | | ('GBR', 'Sector', 'Hotels and Restraurants') | 0.629207 | | ('TZA', 'Sector', 'Fishing') | 0.664603 | | ('TZA', 'Sector', 'Maintenance and Repair') | 0.687347 | | ('USA', 'Sector', 'Recycling') | 0.00357223 | | ('USA', 'Sector', 'Re-export & Re-import') | 111.742 | | ('URY', 'Sector', 'Private Households') | 296.233 | | ('URY', 'Sector', 'Others') | 0.432434 | | ('URY', 'Sector', 'Re-export & Re-import') | 0.352879 | | ('UZB', 'Sector', 'Re-export & Re-import') | 0.619852 | | ('VUT', 'Sector', 'Fishing') | 2.19209 | | ('VUT', 'Sector', 'Mining and Quarrying') | 0.381777 | | ('VUT', 'Sector', 'Transport') | 0.55949 | | ('VUT', 'Sector', 'Private Households') | 0.629678 | | ('VUT', 'Sector', 'Re-export & Re-import') | 0.500515 | | ('ZMB', 'Sector', 'Re-export & Re-import') | 0.626064 | | ('ZWE', 'Sector', 'Agriculture') | 79.1493 | | ('ZWE', 'Sector', 'Fishing') | 61.1683 | | ('ZWE', 'Sector', 'Mining and Quarrying') | 77.9683 | | ('ZWE', 'Sector', 'Food & Beverages') | 85.6493 | | ('ZWE', 'Sector', 'Textiles and Wearing Apparel') | 74.6593 | | ('ZWE', 'Sector', 'Wood and Paper') | 81.9078 | | ('ZWE', 'Sector', 'Petroleum, Chemical and Non-Metallic Mineral Products') | 85.4707 | | ('ZWE', 'Sector', 'Metal Products') | 61.121 | | ('ZWE', 'Sector', 'Electrical and Machinery') | 88.6479 | | ('ZWE', 'Sector', 'Transport Equipment') | 79.528 | | ('ZWE', 'Sector', 'Other Manufacturing') | 73.375 | | ('ZWE', 'Sector', 'Recycling') | 12.5272 | | ('ZWE', 'Sector', 'Electricity, Gas and Water') | 93.151 | | ('ZWE', 'Sector', 'Construction') | 78.228 | | ('ZWE', 'Sector', 'Maintenance and Repair') | 63.6672 | | ('ZWE', 'Sector', 'Wholesale Trade') | 91.0589 | | ('ZWE', 'Sector', 'Retail Trade') | 98.7206 | | ('ZWE', 'Sector', 'Hotels and Restraurants') | 68.2833 | | ('ZWE', 'Sector', 'Transport') | 64.7867 | | ('ZWE', 'Sector', 'Post and Telecommunications') | 88.7394 | | ('ZWE', 'Sector', 'Finacial Intermediation and Business Activities') | 91.4021 | | ('ZWE', 'Sector', 'Public Administration') | 85.5732 | | ('ZWE', 'Sector', 'Education, Health and Other Services') | 80.0968 | | ('ZWE', 'Sector', 'Private Households') | 51.6251 | | ('ZWE', 'Sector', 'Others') | 65.7326 | | ('ZWE', 'Sector', 'Re-export & Re-import') | 4.01465 | +----------------------------------------------------------------------------+---------------+
Out[4]:
False
In [5]:
# removing all the satellite account except the Energy usage using aggrgation function
# Finding the Energy Usage accounts using search function
energy_usages = world.search(item='Satellite account',search= 'Energy Usage')
In [6]:
# Creating the aggregation dataframe
aggregator = pd.DataFrame(data = 'unused',
index=world.E.index,# taking the index of E matrix
columns= ['Aggregation']
)
# Filling the energy_usages with their names to dont aggregate/remove then
aggregator.loc[energy_usages,'Aggregation']= energy_usages
In [7]:
# calling the aggregate function
level = 'Satellite account'
world.aggregate(io={level:aggregator}, # defining the io with a dict
levels=level, # defining the level to aggregate
)
In [8]:
# new E matrix
world.E
Out[8]:
Region | AFG | ... | ZWE | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Level | Sector | ... | Sector | ||||||||||||||||||
Item | Agriculture | Fishing | Mining and Quarrying | Food & Beverages | Textiles and Wearing Apparel | Wood and Paper | Petroleum, Chemical and Non-Metallic Mineral Products | Metal Products | Electrical and Machinery | Transport Equipment | ... | Retail Trade | Hotels and Restraurants | Transport | Post and Telecommunications | Finacial Intermediation and Business Activities | Public Administration | Education, Health and Other Services | Private Households | Others | Re-export & Re-import |
Energy Usage (TJ) - Natural Gas | 14.5665 | 0.424861 | 6.35112 | 32.6228 | 5.95376 | 15.3731 | 42.8622 | 17.4204 | 44.2079 | 23.9727 | ... | 0.00000 | 0.0000 | 0.0000 | 0.00000 | 0.000 | 0.0000 | 0.0000 | 0.00000 | 0.00000 | 0.0 |
Energy Usage (TJ) - Coal | 11.8107 | 0.344482 | 5.14956 | 26.4509 | 4.82737 | 12.4647 | 34.7532 | 14.1247 | 35.8443 | 19.4373 | ... | 362.14900 | 683.7270 | 1696.1200 | 594.74900 | 1808.420 | 1395.8900 | 1189.2000 | 159.37400 | 0.00000 | 0.0 |
Energy Usage (TJ) - Petroleum | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 4.11468 | 7.7684 | 17262.7000 | 6.75744 | 20.547 | 15.8599 | 13.5115 | 1.81078 | 2723.33000 | 0.0 |
Energy Usage (TJ) - Nuclear Electricity | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 0.00000 | 0.0000 | 0.0000 | 0.00000 | 0.000 | 0.0000 | 0.0000 | 0.00000 | 0.00000 | 0.0 |
Energy Usage (TJ) - Hydroelectric Electricity | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 0.00000 | 0.0000 | 0.0000 | 0.00000 | 0.000 | 0.0000 | 0.0000 | 0.00000 | 0.00000 | 0.0 |
Energy Usage (TJ) - Geothermal Electricity | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 0.00000 | 0.0000 | 0.0000 | 0.00000 | 0.000 | 0.0000 | 0.0000 | 0.00000 | 0.00000 | 0.0 |
Energy Usage (TJ) - Wind Electricity | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 0.00000 | 0.0000 | 0.0000 | 0.00000 | 0.000 | 0.0000 | 0.0000 | 0.00000 | 0.00000 | 0.0 |
Energy Usage (TJ) - Solar, Tide and Wave Electricity | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 0.00000 | 0.0000 | 0.0000 | 0.00000 | 0.000 | 0.0000 | 0.0000 | 0.00000 | 0.00000 | 0.0 |
Energy Usage (TJ) - Biomass and Waste Electricity | 0.0000 | 0.000000 | 0.00000 | 0.0000 | 0.00000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | ... | 4.11627 | 7.7714 | 13.0921 | 6.76005 | 20.555 | 15.8660 | 13.5167 | 1.81148 | 1.91107 | 0.0 |
9 rows × 4914 columns
Eora Single Region¶
In [9]:
path = r'IO_AUS_2015_BasicPrice.txt'
AUS = mario.parse_eora(
path=path,
multi_region=False,
aggregate_trade= False # keeping the trades with any region in the database
)
C:\Users\payam\Documents\GitHub\MARIO\mario\tools\parsersclass.py:346: DtypeWarning: Columns (0) have mixed types.Specify dtype option on import or set low_memory=False. C:\Users\payam\anaconda3\lib\site-packages\pandas\core\generic.py:4150: PerformanceWarning: dropping on a non-lexsorted multi-index without a level parameter may impact performance.
In [10]:
# Value added matrix
AUS.V
Out[10]:
Region | Australia | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Level | Sector | ||||||||||||||||||||
Item | Sheep and lambs | Shorn wool | Oats, sorghum and other cereal grains | Wheat | Barley | Rice | Oilseeds | Legumes | Beef cattle | Untreated milk | ... | Sport and recreation services (incl horse and dog racing, sports grounds, services) | Personal services | Photographic film processing | Community services and religious organisations | Interest groups and community organisations | Police | Corrective centres | Fire brigade | Sanitary and garbage disposal | Re-export |
Item | |||||||||||||||||||||
Compensation of employees D.1 | 2.556220e+08 | 2.433937e+08 | 7.336618e+07 | 3.146963e+08 | 1.122533e+08 | 1.532834e+07 | 2.895112e+07 | 3.808025e+07 | 1.326969e+09 | 1.189331e+08 | ... | 3.361140e+09 | 4.401588e+09 | 5.739301e+08 | 3.127360e+09 | 7.186972e+09 | 4.824663e+09 | 1.606611e+09 | 1.298814e+09 | 7.169460e+08 | 3.987337e+02 |
Taxes on production D.29 | 5.924522e+06 | 5.236558e+06 | 1.747110e+06 | 7.466145e+06 | 2.858386e+06 | 3.653033e+05 | 7.074210e+05 | 1.003368e+06 | 1.574106e+07 | 2.584761e+06 | ... | 1.764520e+07 | 1.184938e+07 | 1.499049e+06 | 2.502957e+07 | 1.044704e+07 | 7.161947e+06 | 2.317332e+06 | 1.928980e+06 | 9.854777e+05 | 3.987337e+02 |
Subsidies on production D.39 | -3.982510e+02 | -4.255667e+02 | -5.574359e+02 | -7.299914e+02 | -5.181845e+02 | -6.731255e+02 | -6.697036e+02 | -6.769138e+02 | -4.100346e+02 | -5.599736e+02 | ... | -3.495486e+02 | -3.564911e+02 | -3.388479e+02 | -5.139558e+02 | -3.408873e+02 | -4.818684e+02 | -4.473704e+02 | -4.313031e+02 | -3.759746e+02 | -3.084256e+02 |
Net operating surplus B.2n | 8.653479e+08 | 7.636153e+08 | 3.861760e+08 | 1.568198e+09 | 5.982055e+08 | 7.540848e+07 | 1.486669e+08 | 1.974871e+08 | 3.062457e+09 | 2.532524e+08 | ... | 6.620869e+08 | 8.688302e+08 | 1.038264e+08 | 2.802075e+08 | 3.649793e+08 | 2.702725e+08 | 8.240794e+07 | 6.939703e+07 | 1.692389e+07 | 3.987337e+02 |
Net mixed income B.3n | 8.036153e+07 | 7.063326e+07 | 3.512474e+07 | 1.500548e+08 | 5.493422e+07 | 6.752769e+06 | 1.336661e+07 | 1.779826e+07 | 3.109050e+08 | 2.287670e+07 | ... | 5.917697e+07 | 7.770368e+07 | 9.265546e+06 | 2.501862e+07 | 3.259638e+07 | 2.414360e+07 | 7.353610e+06 | 6.195869e+06 | 1.509936e+06 | 3.987337e+02 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
Import From Viet Nam | 7.379228e+05 | 1.076063e+06 | 8.115792e+05 | 7.208088e+05 | 2.130037e+05 | 7.076472e+04 | 1.459128e+05 | 1.300391e+05 | 1.437444e+06 | 7.993276e+05 | ... | 4.168866e+06 | 3.671290e+06 | 3.828300e+05 | 1.580519e+06 | 2.677914e+06 | 2.252865e+06 | 6.679025e+05 | 7.136330e+05 | 6.717864e+05 | 4.074160e+06 |
Import From Yemen | 1.609756e+04 | 2.102819e+04 | 1.196540e+04 | 2.100690e+04 | 1.365229e+04 | 8.108515e+03 | 1.049776e+04 | 1.052042e+04 | 2.349277e+04 | 2.265923e+04 | ... | 1.823329e+05 | 1.227823e+05 | 1.658229e+04 | 7.964904e+04 | 1.281645e+05 | 1.073916e+05 | 3.615555e+04 | 3.828378e+04 | 3.621322e+04 | 1.004808e+05 |
Import From Zambia | 1.245779e+04 | 1.274972e+04 | 1.340160e+04 | 1.016656e+04 | 1.079732e+04 | 9.122464e+03 | 9.678976e+03 | 9.652559e+03 | 1.492284e+04 | 1.161494e+04 | ... | 2.348715e+04 | 1.842717e+04 | 1.385903e+04 | 1.429528e+04 | 1.883653e+04 | 1.613773e+04 | 1.280334e+04 | 1.328591e+04 | 1.347164e+04 | 1.764952e+04 |
Import From Zimbabwe | 3.951108e+03 | 3.962073e+03 | 3.987687e+03 | 3.668710e+03 | 3.951348e+03 | 3.918034e+03 | 3.944364e+03 | 3.941616e+03 | 3.928798e+03 | 4.004405e+03 | ... | 3.954858e+03 | 3.953485e+03 | 3.982567e+03 | 3.949252e+03 | 3.977558e+03 | 3.915654e+03 | 3.921187e+03 | 3.949097e+03 | 3.936648e+03 | 3.899365e+03 |
Import From Rest of World | 3.229660e+07 | 3.834387e+07 | 1.766877e+07 | 5.624691e+07 | 1.888846e+07 | 4.095423e+06 | 5.558659e+06 | 6.490833e+06 | 1.109013e+08 | 1.827571e+07 | ... | 1.725137e+08 | 1.476738e+08 | 1.934893e+07 | 6.461909e+07 | 1.103917e+08 | 5.792222e+07 | 1.629316e+07 | 1.915407e+07 | 2.460468e+07 | 6.202203e+06 |
196 rows × 345 columns
In [ ]: