running error in retail_rate_calculations.py

[wanyingw193]

Hi ReEDS team!

So strange that an error reported in retail_rate_calculations.py when input csv is cases_text.csv. Below is the error info copied from Gamslog.txt. Could I get some suggestions for debugging? Thanks!

*** Status: Normal completion
--- Job e_report_dump.gms Stop 01/04/22 09:18:08 elapsed 0:00:13.329
Traceback (most recent call last):
File "C:\software\ReEDS_OpenAccess-2021\retail_rate_module\retail_rate_calculations.py", line 2062, in
write=True, verbose=args.verbose,
File "C:\software\ReEDS_OpenAccess-2021\retail_rate_module\retail_rate_calculations.py", line 382, in main
received_expenditures, on = ['price_type', 't', 'state'], how = 'outer').fillna(0)
File "C:\Users\14399\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\core\frame.py", line 7963, in merge
validate=validate,
File "C:\Users\14399\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\core\reshape\merge.py", line 87, in merge
validate=validate,
File "C:\Users\14399\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\core\reshape\merge.py", line 652, in init
) = self._get_merge_keys()
File "C:\Users\14399\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\core\reshape\merge.py", line 1005, in _get_merge_keys
right_keys.append(right._get_label_or_level_values(rk))
File "C:\Users\14399\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\core\generic.py", line 1563, in _get_label_or_level_values
raise KeyError(key)
KeyError: 'price_type'

[wesleyjcole]

Without knowing what cases_text.csv is, I can really provide much input here. I will note two things that might be helpful:

1. The retail rate calculation is an output calculation only. If you are not doing any work with the retail rate, then it you can ignore this.
2. The retail rate calculation only works when you run the full U.S., so if you are running ERCOT or some other subregion, it won't work without some further development.

[wanyingw193]

Thanks for your answer! cases_test.csv is run in the ERCOT region, and I used the same cases_test.csv as the OpenAccess version.

This is probably a quick way to directly ignore the calculations. So I added the # related to retail calculations directly in the runbatch.py code, but in this case the standard report doesn't seem to be generated. Did I go into a wrong way?

[wesleyjcole]

The outputs report should still generate even if the retail rate module fails. You can try generating a Bokeh output report manually to make sure everything is working correctly. See this video if you are unfamiliar with making a Bokeh output report.

[wanyingw193]

Thank you!