Time Series: Incompatibility between Google Colab and pandas 2

[wierdvanderhaar]

When running timeseries-queries-and-visualization.ipynb in Colab you get the following error when installing the needed pip packages.

!pip install --upgrade kaleido 'pandas>=2' plotly sqlalchemy-cratedb
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
cudf-cu12 24.4.1 requires pandas<2.2.2dev0,>=2.0, but you have pandas 2.2.2 which is incompatible.
google-colab 1.0.0 requires pandas==2.0.3, but you have pandas 2.2.2 which is incompatible.

This can be fixed by running:

!pip install --upgrade kaleido 'pandas==2.0.3' plotly sqlalchemy-cratedb

[amotl]

Thanks. Will be fixed with fa5edbd, on behalf of GH-482.

[amotl]

Google Colab's changelog reports that on 2024-05-13, the cudf package has been included.

Python package inclusions

• cudf 24.4.1

This apparently wants to pull in pandas=>2.0, [...]

ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
cudf-cu12 24.4.1 requires pandas<2.2.2dev0,>=2.0, but you have pandas 1.5.3 which is incompatible.
cudf-cu12 24.4.1 requires pyarrow<15.0.0a0,>=14.0.1, but you have pyarrow 16.1.0 which is incompatible.
google-colab 1.0.0 requires pandas==2.0.3, but you have pandas 1.5.3 which is incompatible.
google-colab 1.0.0 requires requests==2.31.0, but you have requests 2.32.3 which is incompatible.
ibis-framework 8.0.0 requires pyarrow<16,>=2, but you have pyarrow 16.1.0 which is incompatible.

[...] but our "Time Series" stack is not up-to-date to be able to use it, because the update needs to be unblocked.

• Time Series: Modernize notebooks to use recent versions of pandas and SQLAlchemy #387
• Time Series: Update to pandas 2.0 and SQLAlchemy 2.0 #430

As outlined on both the ticket and the PR, any support is appreciated.

[amotl]

The situation will be improved with:

• Time Series: Update to pandas 2.0 and SQLAlchemy 2.0 #430

Upgrading two other notebooks has been postponed:

• Time Series: Some notebooks are not compatible with pandas 2.x #493