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 [ ]: