The Adapter software is developed at the Energy Efficiency Standards Department and it provides a convenient data table loader from various formats such as xlsx, csv, db (sqlite database), and sqlalchemy. Its main feature is the ability to convert data tables identified in one main and optionally one or more additional input files into database tables and Pandas DataFrames for downstream usage in any compatible software.
1
stars
1
forks
source link
quick fix for openpyxl and SQLAlchemy backwards compatibility issue #33
I created a patch solution by specifying the dependency versions; All unit tests passed.
"SQLAlchemy==1.4.29", "openpyxl==3.0.9"