residential_quota_downselect leads to bad format buildstock

[lixiliu]

Describe the bug
There's a problem with the buildstock created fromresidential_quota_downselect. All "None" fields become empty and I believe there are other formatting issues that are causing these failures on Eagle:

[00:32:57.683956 ERROR] Could not find parameter 'Geometry Building Number Units MF' and option '6.0' in /lib/resources/options_lookup.tsv.

[00:16:10.751502 ERROR] Could not find parameter 'CEC Climate Zone' and option '13.0' in /lib/resources/options_lookup.tsv.

[22:32:00.491794 ERROR] :/ruby/2.7.0/gems/openstudio-workflow-2.3.1/lib/openstudio/workflow/util/measure.rb failed with message Runner error :/ruby/2.7.0/gems/openstudio-workflow-2.3.1/lib/openstudio/workflow/util/measure.rb failed with invalid null reference Expected argument 2 of type std::string const &, but got NilClass nil

The last error I think is tied to None being completely gone.

To Reproduce
This folder contains the yaml, downselect buildstock and original buildstock. You can run the yaml against ResStock develop branch.

I am using bsb env: buildstock-2023.05.0
@nmerket for your awareness. This is potentially caused by recent pandas changes and it does not appear to be an issue for buildstock-2023.01.0

downselect buildstock errors.zip

[afontani]

Is this might be a float string interpretation issue?

[shorowit]

I think @afontani nailed it. They should be 6 and 13, not 6.0 and 13.0.

[afontani]

@nmerket @rajeee Thinking a little more about this, pandas recently changed the way it reads in files and assigns the data types. It might be related to the pandas version. We might have to tag a specific version of pandas or update the way we read in files.

resstock-estimation used pandas<2 (https://github.com/NREL/resstock-estimation/blob/778d24c6f9f98edd5401e2103f3849241529e3ec/setup.py#L34)