A lightweight preprocessing tool for SimaPro CSV exports. Quickly organizes input/output fields to help your team create an initial data blueprint.
- SimaPro is a leading tool for Life Cycle Assessment (LCA), following the ISO 14040 series of standards to evaluate the environmental impact of products or services.
- This tool aims to assist with early-stage data organization and serve as a foundation for further LCA modeling.
- SimaPro is commercial software. This tool does not provide any original data; please prepare your own CSV files for preprocessing.
- Due to SimaPro's software limitations, data for cleaning must be manually exported from your projects as CSV files.
- If your LCA team already has established LCI (Life Cycle Inventory) items and corresponding conventions, please follow your existing LCI guidelines. If you do not have established conventions yet, you can use this tool to help create an initial data blueprint.
- This tool is only for preliminary data cleaning and field organization. The output fields are not guaranteed to comply with any particular PCR standard and should be used for reference only.
- The actual LCA modeling fields required should be determined based on your production process and discussions with domain experts.
- Do not use the results of this tool directly for formal declarations or certification purposes.
- This tool is compatible with CSV files exported from SimaPro Craft 10.2.0.0.
-
Create a Python 3.12 virtual environment and install dependencies via
pip install -r requirements.txt. -
Export your SimaPro data to Excel and place the files inside a folder, for example
resources/. -
Run the cleaner script
python scripts/main.py --input_dir resources --output outputs/merged_cleaned.xlsx
The command merges every
.xls/.xlsxfile under the input folder, deduplicates rows, and saves the consolidated result to the path provided in--output.
This project is licensed under the Apache License 2.0.
Feedback and contributions are welcome via Issues or Pull Requests.