Exio3-to-bw2

Import Exiobase v3 into brightway2

This is an attempt to import tables of the Multi-Regional Input-Output database Exiobase version 3 into the python-baseed Brightway2 LCA framework. It works, but it is slow (1h on my computer) and there are certainly better ways to do it.

Run the code

With the official “exiobase_3.3.15_hsut_2011” folder ( downloaded here)in your working directory. This is what the code does:

1. Import the HIO sheet from xlsb file
2. Create a dict with activities and exchanges
3. Write the dict as bw database
4. Import final prod sheet from xlsb file
5. Add the final prod to existing bw database
6. Import emissions from another xlsb file
7. Match emissions with biosphere3 codes (not all of them)
8. Add the emissions to the existing bw database
9. Do calculations.

Notes and limitations

• Steps 1 and 3 take quite long time.

• This code is exclusively for the supply and use table in hybrid units.

• Right now only three GHG emissions are included in the calculation.

• (the v2 file uses a preliminary mapping of exiobase emissions to biosphere3 exchange codes is provided, not all emissions are matched though. This code is not fully tested. Works, but the results are unrealistic (too low LCIA scores) so there is some mistake in the numbers.)

• It is not currently possible to import other types of environmental exchanges (need mapping files)

• I haven’t imported the final demand either. These are activities so would need to be done just before step 3 I think (and will make step 3 even more time consuming).

• One can convert manually the .xlsb files in .csv and then the import becomes much quicker (seconds insteads of minutes):

  HIO = pd.read_csv("Exiobase_MR_HIOT_2011_v3_3_15_by_prod_tech.csv", header=None)

  However, this is at your own risk. The manual conversion might mess up the original tables and that's why I have not implemented this option in first place. This code takes point of departure in the original exiobase files.