loads_to_dataframe().columns differs from class_to_dataframe("Load").columns

[nlaws-camus]

Perhaps related to #74

Versions

• Python version: 3.10.8
• Python architecture: x64
• Operating system and version: OSX 12.2.1
• OpenDSSDirect.py version number: 0.7.0

Bug

• What is the current behavior?

>>> dss.utils.loads_to_dataframe().columns
Index(['CVRCurve', 'CVRvars', 'CVRwatts', 'CFactor', 'Class', 'Growth',
       'IsDelta', 'Model', 'Name', 'NumCust', 'PF', 'PctMean', 'PctStdDev',
       'RelWeighting', 'Rneut', 'Spectrum', 'Status', 'Vmaxpu', 'VminEmerg',
       'VminNorm', 'Vminpu', 'Xneut', 'Yearly', 'ZipV', 'Daily', 'Duty', 'Idx',
       'kV', 'kW', 'kVABase', 'kvar', 'kWh', 'kWhDays', 'puSeriesRL', 'XfkVA',
       'Phases', 'AllocationFactor'],
      dtype='object')

>>> dss.utils.class_to_dataframe("Load").columns
Index(['phases', 'bus1', 'kV', 'kW', 'pf', 'model', 'yearly', 'daily', 'duty',
       'growth', 'conn', 'kvar', 'Rneut', 'Xneut', 'status', 'class', 'Vminpu',
       'Vmaxpu', 'Vminnorm', 'Vminemerg', 'xfkVA', 'allocationfactor', 'kVA',
       '%mean', '%stddev', 'CVRwatts', 'CVRvars', 'kwh', 'kwhdays', 'Cfactor',
       'CVRcurve', 'NumCust', 'ZIPV', '%SeriesRL', 'RelWeight', 'Vlowpu',
       'puXharm', 'XRharm', 'spectrum', 'basefreq', 'enabled', 'like'],
      dtype='object')

>>> set([s.lower() for s in dss.utils.class_to_dataframe("Load").columns]) - set([s.lower() for s in dss.utils.loads_to_dataframe().columns])
{'relweight', 'vlowpu', '%mean', 'like', 'enabled', 'basefreq', '%seriesrl', 'bus1', 'puxharm', '%stddev', 'xrharm', 'kva', 'conn'}

>>> set([s.lower() for s in dss.utils.loads_to_dataframe().columns]) - set([s.lower() for s in dss.utils.class_to_dataframe("Load").columns])
{'name', 'puseriesrl', 'pctmean', 'pctstddev', 'isdelta', 'kvabase', 'relweighting', 'idx'}

• What is the expected behavior? What is the motivation / use case for changing the behavior?
  Both methods should return the same dataframe (esp. note that loads_to_dataframe does not have a bus1 column).

• What are the steps to reproduce this bug? Please provide a minimal working example of the bug if possible.
  See above

[PMeira]

class_to_dataframe processes the DSS properties of each object, using the original DSSObject/DSSProperty APIs. loads_to_dataframe iterates over the Loads API to gather the fields. #74 is indeed related, so is #21.

We will add a better (faster and more complete) alternative based on the new APIs. This alternative is almost done but some details need to be handled/fixed. Some info in #104 (comment) and https://dss-extensions.org/dss_python/obj.html#the-new-dss-obj-api. It should be out by December if nothing major gets in the way.

[PMeira]

Closing since this is very close to a couple of other open Issues.