search

LBNL-ETA / Adapter

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

Update sqlalchemy and/or pandas dependency #45

Open evaneill opened 5 months ago

evaneill commented 5 months ago

The current setup.py fixes the sqlalchemy requirement at 1.4.29, though for versions of pandas ≥2.2.0 (which is not restricted in setup.py), this will result in some adapter dependents no longer working.

It seems to make sense to commit to having dependents of adapter become compatible with pandas ≥2.2.0, and then commit to updating adapter to require pandas≥2.2.0 and newer sqlalchemy.

Related to this issue, which is a matter of newer versions of pandas requiring newer versions of openpyxl.

lyralan commented 2 months ago

Related to upgrading pandas to 2.2.0+, numexpr and bottleneck need to be higher than 2.8.4 and 1.3.6 respectively to avoid user warnings. It might also make sense to add requirements for other related packages (e.g., seaborn ≥0.13.2, xlsxwriter ≥3.0.5, scipy ≥1.13.0).