DeltaE / Canada-U.S.-ElecTrade

The Role of U.S.-Canada Electricity Trade in North American Decarbonization Pathways
2 stars 0 forks source link

Simplify trade input data format #109

Open trevorb1 opened 2 years ago

trevorb1 commented 2 years ago

In the datasoureces/Trade.csv file, we input the technology and commodity names manually following this convention...

image

This seems like we are cruising towards a clerical error if we are ever wanting to update/modify it, as it is easy to accidentally mistype a technology or commodity name. It would be nice if we just input the regions and fuels, then the code takes care of the rest. Something like....

Region 1 Region 2 Fuel Import Eff. (%) Export Eff. (%)
CANWS CANMW ELC 95 95
CANWS USANW ELC 90 95

The specifics of what the table actually looks like probably needs a little more thought. Just thinking it might be easier to read (and less prone to errors) if we let the code do more of the tech/fuel name assembling