Changelog is organized by the version of this library, commit date and main points of change
- Important fix
- Important feature
2023 December
- Fix dataframe sort with a pivot with the new pandas v2 API
- Optimize it by getting rid of
reset_index
andset_index
method calls when sorting
2023 November
Make removal of date total when generating highcharts more flexible by localizing the datetime when filtering out the totals. This will work with timezone aware datetimes as well not aware ones.
2023 September
- Specify extras dependencies correctly
- Specify extras names and the library dependencies for them under tool.poetry.extras
- Describe all the necessary group dependencies in
pyproject.toml
as none of other than Vertica and Snowflake libraries have been included in the published library - Add newly installed libraries to
poetry.lock
- Update
pymssql
to 2.2.8
2023 August
- Drop support for Python3.7 as pandas v2 does not support it
- Add Python3.9 support
- Use the newest
pandas
(2.0.3 in requirements) and add the minimum version 2.0.0 ofpandas
to pyproject.toml - Use the newest
vertica-python
(1.3.4 in requirements) and add the minimum version 1.0.0 ofvertica-python
to pyproject.toml - Use the newest
snowflake-connector-python
(3.0.4 in requirements) and add the minimum version 3.0.0 ofsnowflake-connector-python
to pyproject.toml - Use the newest
coverage
(7.3.0 in requirements) and add the minimum version 7.3.0 ofcoverage
to pyproject.toml - Use the newest
watchdog
(3.0.0 in requirements) and add the minimum version 3.0.0 ofwatchdiog
to pyproject.toml - Remove
python-dateutil
from dependencies as it is part of other libraries' dependencies - Bump
psycopg-binary==2.9.6
though it seems not needed for the tests - Bump
pymssql==2.2.7
though it seems not needed for the tests - Bump
Cython==3.0.0
though it seems not needed for the tests - Get rid of
SyntaxWarning: "is" with a literal. Did you mean "=="?
- Get rid of
DeprecationWarning: Using or importing the ABCs from 'collections' instead of from 'collections.abc' is deprecated since Python 3.3, and in 3.10 it will stop working
- Replace
Dataframe.append
topd.concat
becauseappend
does not exist since pandas v2 - Add
group_keys=False
toDataFrame.groupby()
method because it is no longer ignored since pandas v1.5 - Fix
_apply_share
method forShare
s with the new libraries. - Rename
TestDatabase
toMockDatabase
since it is used only for mocking. This is beneficial also because Python testing method will not delve into it to find methods to run - Rename
test_connect
andtest_fetch
tomock_connect
andmock_fetch
as these are mocks. This is beneficial also because Python testing method will not delve into it to find methods to run - Rename
TestMySQLDatabase
toMockMySQLDatabase
for the same reason - When concatenating
DataFrames
, use.tail(1)
instead of.iloc[-1]
as it includes indexes - Use static CSVs to get the expected
DataFrames
in tests instead of applying methods offireant
to aDataFrame
to get those expectedDataFrames
- Replace
np.float
tofloat
since it was deprecated - Get rid of
None
and[]
asascending
parameters forPandas
class - Replace
.iteritems()
with.items()
as the former method was deprecated