Offshore Wind Debt Fraction Calculator throwing error

[NoahV-SC]

I'm receiving an error when calculating new debt fractions for offshore wind (both fixed and floating).
I am able to run debt fractions for other technologies (land-based wind, and utility PV) without issue, but when I attempt to run the debt fraction processor for all technologies or just for offshore wind, I receive a key error.

File "pandas\core\indexes\base.py", line 3812, in get_loc
raise KeyError(key) from err
KeyError: 'Fixed-Bottom Offshore Wind'`

(running Python 3.11.9)

[brtietz]

@NoahV-SC Thanks for reporting! I have a proposed fix here #22 - mind testing and letting us know how it goes?

[NoahV-SC]

Thanks Brian! That seems to work for Fixed Offshore Wind, but there still seem to be problems with Floating OSW:

Loading data from Floating Offshore Wind, for R&D and 20
Loading metrics
Loading assumptions
Loading WACC data
Done loading data
Traceback (most recent call last):
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 939, in _finalize_columns_and_data
columns = _validate_or_indexify_columns(contents, columns)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 986, in _validate_or_indexify_columns
raise AssertionError(
AssertionError: 31 columns passed, passed data had 23 columns

[brtietz]

Thanks for testing! I am not able to reproduce that error - can you share the version of the ATB spreadsheet you're running with (if it varies from the version at https://atb.nrel.gov/electricity/2024/data)

The error there suggests something about a difference in the base year - given that fixed starts in 2022 and floating starts in 2030 if that helps you debug.

[NoahV-SC]

I pulled a fresh copy of the ATB from the website but am still running into this same error.
I also confirmed that I'm running the latest commit on this issue branch.

python -m debt_fraction_calculator.debt_fraction_calc --tech FloatingOffShoreWindProc "C:/Users/Noah.verbeek/Downloads/2024 ATB.xlsx" "test.csv"

Processing tech OffShoreWind and financial case Market
Loading data from Floating Offshore Wind, for Market and 20
Loading metrics
Loading assumptions
Loading WACC data
Done loading data
Processing tech OffShoreWind and financial case R&D
Loading data from Floating Offshore Wind, for R&D and 20
Loading metrics
Loading assumptions
Loading WACC data
Done loading data
Traceback (most recent call last):
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 939, in _finalize_columns_and_data
columns = _validate_or_indexify_columns(contents, columns)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 986, in _validate_or_indexify_columns
raise AssertionError(
AssertionError: 31 columns passed, passed data had 23 columns

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "", line 198, in _run_module_as_main
File "", line 88, in _run_code
File "C:\Users\noah.verbeek\Documents\ATB\ATB-calc\debt_fraction_calculator\debt_fraction_calc.py", line 333, in
calculate_all_debt_fractions() # pylint: disable=no-value-for-parameter
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\click\core.py", line 1157, in call
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\click\core.py", line 1078, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\click\core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\click\core.py", line 783, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\Documents\ATB\ATB-calc\debt_fraction_calculator\debt_fraction_calc.py", line 328, in calculate_all_debt_fractions
debt_frac_df = pd.DataFrame.from_dict(debt_frac_dict, orient='index', columns=cols)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\frame.py", line 1917, in from_dict
return cls(data, index=index, columns=columns, dtype=dtype)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\frame.py", line 851, in init
arrays, columns, index = nested_data_to_arrays(
^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 520, in nested_data_to_arrays
arrays, columns = to_arrays(data, columns, dtype=dtype)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 845, in to_arrays
content, columns = _finalize_columns_and_data(arr, columns, dtype)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\noah.verbeek\anaconda3\Lib\site-packages\pandas\core\internals\construction.py", line 942, in _finalize_columns_and_data
raise ValueError(err) from err
ValueError: 31 columns passed, passed data had 23 columns

[mikebannis]

Noah, we're looking into this and I think we have an answer. Testing it out now. Hopefully will have everything working after the weekend.