Convert Static Data Files to `json` and `csv` - Githubissues

brightway-lca / bw_hybrid

Hybrid (Input-Output/Process-based) Life-Cycle Assessment

https://docs.brightway.dev/projects/hybrid/

BSD 3-Clause "New" or "Revised" License

2 stars 1 forks source link

Convert Static Data Files to `json` and `csv` #31

Closed michaelweinold closed 5 months ago

michaelweinold commented 1 year ago

Currently, data files are of formats txt, csv, xlsx. To avoid using unsafe functions like eval() and to simpify data import, all data should be converted to either json or csv.

File names should indicate the target Python type (e.g.: dict_ecoinvent_aux_data.json or list_geography_correspondence.json.

Task List

[x] countries_per_regions.txt
[x] countries.txt
[ ] Filter.xlsx
[ ] geography_replacements.txt
[ ] Product_Concordances.xlsx
[x] STAM_categories.txt
[ ] STAM_functional_categories.txt

michaelweinold commented 1 year ago

Relevant notebooks:

json_export.ipynb

michaelweinold commented 1 year ago

Compare also follow-up issue: https://github.com/michaelweinold/bw_hybrid/issues/32