Skip to content

KeyError: "None of ['company_id', 'time_frame', 'scope'] are in the columns" #253

@trev0rwright

Description

@trev0rwright

Hello,
I am trying to deploy the tool on a portfolio of assets with only intensity targets. Columns definitely have contents in them when uploaded to 'provider'. I have set the intensity_metric to 'other' for all assets. Yet seeing this error when I run temperature_score.calculate: KeyError: "None of ['company_id', 'time_frame', 'scope'] are in the columns". Wondering if issue is with interfaces.py IDataProviderTarget?

Have visited this, (#250) but since I have intensity_metric = to 'other' for all assets, not sure why I am still seeing this error. Interestingly, when I remove 'other' from intensity_metric (leave blank), temperature_score.calculate() will successfully run, but every asset receives the default temperature score.

Thanks for considering and really appreciate any support.

By way of additional details:

  • I have checked base/end_year columns to make sure no issues with weird dates. All targets have end_year > 2021.
  • I have checked Scope column - all are "S1+S2"
  • each unique company_id is represented in PortfolioTemplate and DataProviderTemplate tabs. While every company_id is unique, I do have some repeat companies (reflecting different portfolios holding same company).
  • Doing this all locally, and already have had previous success with my own test/sample data with my local notebook.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions