[Bug]: Empty index results in nan

[willu47]

The Issue

If a parameter index in an Excel workbook is empty, otoole writes nan in the CSV or datafile.

For example AccumulatedAnnualDemand tab has following values:

REGION	FUEL	2015		2016
	BJFW3X	76.26378	78.37409
	BJHE3X	0		0
	BJHF3X	0.6906382	0.7178051
	BJLF3X	68.3731818	71.0627049

This is converted to csv as:

REGION,FUEL,YEAR,VALUE
nan,BJFW3X,2015,76.26378,
nan,BJFW3X,2016,78.37409
nan,BJHE3X,2015,0,
nan,BJHE3X,2016,0
nan,BJHF3X,2015,0.6906382,
nan,BJHF3X,2016,0.7178051
nan,BJLF3X,2015,68.3731818,
nan,BJLF3X,2016,71.0627049

Expected Behavior

EITHER

• Blank indexes should be left blank. For example, I believe it is possible to run GNU MathProg without defining a REGION set
  OR
• An OtooleDataError should be raised. All rows in a datafile should have data for each index.

Steps To Reproduce

No response

Log output

No response

Operating System

MacOS

What version of otoole are you running?

v1.0.1

Possible Solution

No response

Anything else?

No response