search

USEPA / ElectricityLCI

Creative Commons Zero v1.0 Universal
24 stars 10 forks source link

Running from Pandas 1.2.0 fails due to pd.read_excel() engine #159

Closed jgrooviest closed 3 years ago

jgrooviest commented 3 years ago

Pandas 1.2.0 (release notes) no longer maintains the xlrd package for reading .xlsx files.

This is an easy fix if engine = openpyxl is added to every instance of pd.read_excel() and, or course, if openpyxl is imported. Kind of tedious though.

As of now though, the program raises an error when you try to generate an LCI using the default configuration files.

jgrooviest commented 3 years ago

Seems to fail on a fresh install with Pandas 0.24.0 too...issue is actually with the xlrd version (to import .xlsx files it needs to be <=1.2.0).

jgrooviest commented 3 years ago

Downgrading pandas to 0.24.0 and xlrd to 1.2.0 results in a sufficient fix.