codeforboston / home-energy-analysis-tool

https://www.codeforboston.org/projects/
MIT License
8 stars 25 forks source link

CSV parsing for natural gas billing inputs #121

Closed alanisaac closed 2 months ago

alanisaac commented 7 months ago

The javascript team would like the rules engine to do CSV parsing for the time being for Natural Gas billing inputs. Implement this as a layer on top of the existing rules engine code.

erika-n commented 4 months ago

Is this still applicable? The Javascript will have to load the CSV into the interface before it is sent to the rules engine.

alanisaac commented 3 months ago

We checked in with the JS team this week and confirmed that:

alanisaac commented 3 months ago

The parser should be able to handle CSVs from both Eversource and National Grid, and the formats for each are slightly different.

jkwan2011 commented 3 months ago

Examples of each file type can be found here: https://drive.google.com/file/d/1vqfbl1VerpECJspUKxGwJs3RQzCveUEW/view?usp=drive_link