Pandas 1.0.0 Compatibility #287

joshkreud · 2020-01-31T10:13:47Z

Issue

Environment

Operating System: WIN10 1903
Python Version: 3.7.6
How did you install Qgrid: conda create -n qgrid_test python=3.7 qgrid pandas

Python packages in conda env:

(qgrid_test) H:\>conda list
# Name                    Version                   Build  Channel
attrs                     19.3.0                     py_0    conda-forge
backcall                  0.1.0                      py_0    conda-forge
bleach                    3.1.0                      py_0    conda-forge
ca-certificates           2019.11.28           hecc5488_0    conda-forge
certifi                   2019.11.28               py37_0    conda-forge
colorama                  0.4.3                      py_0    conda-forge
decorator                 4.4.1                      py_0    conda-forge
defusedxml                0.6.0                      py_0    conda-forge
entrypoints               0.3                   py37_1000    conda-forge
importlib_metadata        1.5.0                    py37_0    conda-forge
inflect                   4.0.0                    py37_1    conda-forge
intel-openmp              2019.4                      245
ipykernel                 5.1.4            py37h5ca1d4c_0    conda-forge
ipython                   7.11.1           py37h5ca1d4c_0    conda-forge
ipython_genutils          0.2.0                      py_1    conda-forge
ipywidgets                7.5.1                      py_0    conda-forge
jaraco.itertools          5.0.0                      py_0    conda-forge
jedi                      0.16.0                   py37_0    conda-forge
jinja2                    2.11.1                     py_0    conda-forge
jsonschema                3.2.0                    py37_0    conda-forge
jupyter_client            5.3.4                    py37_1    conda-forge
jupyter_core              4.6.1                    py37_0    conda-forge
libblas                   3.8.0                    14_mkl    conda-forge
libcblas                  3.8.0                    14_mkl    conda-forge
liblapack                 3.8.0                    14_mkl    conda-forge
libsodium                 1.0.17               h2fa13f4_0    conda-forge
m2w64-gcc-libgfortran     5.3.0                         6
m2w64-gcc-libs            5.3.0                         7
m2w64-gcc-libs-core       5.3.0                         7
m2w64-gmp                 6.1.0                         2
m2w64-libwinpthread-git   5.0.0.4634.697f757               2
markupsafe                1.1.1            py37hfa6e2cd_0    conda-forge
mistune                   0.8.4           py37hfa6e2cd_1000    conda-forge
mkl                       2019.4                      245
more-itertools            8.2.0                      py_0    conda-forge
msys2-conda-epoch         20160418                      1
nbconvert                 5.6.1                    py37_0    conda-forge
nbformat                  5.0.4                      py_0    conda-forge
notebook                  6.0.3                    py37_0    conda-forge
numpy                     1.17.5           py37hc71023c_0    conda-forge
openssl                   1.1.1d               hfa6e2cd_0    conda-forge
pandas                    1.0.0            py37he350917_0    conda-forge
pandoc                    2.9.1.1                       0    conda-forge
pandocfilters             1.4.2                      py_1    conda-forge
parso                     0.6.0                      py_0    conda-forge
pickleshare               0.7.5                 py37_1000    conda-forge
pip                       20.0.2                   py37_1    conda-forge
prometheus_client         0.7.1                      py_0    conda-forge
prompt_toolkit            3.0.3                      py_0    conda-forge
pygments                  2.5.2                      py_0    conda-forge
pyrsistent                0.14.11          py37hfa6e2cd_1    conda-forge
python                    3.7.6                h5b45d93_2    conda-forge
python-dateutil           2.8.1                      py_0    conda-forge
pytz                      2019.3                     py_0    conda-forge
pywin32                   225              py37hfa6e2cd_0    conda-forge
pywinpty                  0.5.7                    py37_0    conda-forge
pyzmq                     18.1.1           py37h16f9016_0    conda-forge
qgrid                     1.1.1                 py37_1001    conda-forge
send2trash                1.5.0                      py_0    conda-forge
setuptools                45.1.0                   py37_0    conda-forge
six                       1.14.0                   py37_0    conda-forge
sqlite                    3.30.1               hfa6e2cd_0    conda-forge
terminado                 0.8.3                    py37_0    conda-forge
testpath                  0.4.4                      py_0    conda-forge
tornado                   6.0.3            py37hfa6e2cd_0    conda-forge
traitlets                 4.3.3                    py37_0    conda-forge
vc                        14.1                 h0510ff6_4
vs2015_runtime            14.16.27012          hf0eaf9b_1
wcwidth                   0.1.8                      py_0    conda-forge
webencodings              0.5.1                      py_1    conda-forge
wheel                     0.34.2                   py37_0    conda-forge
widgetsnbextension        3.5.1                    py37_0    conda-forge
wincertstore              0.2                   py37_1003    conda-forge
winpty                    0.4.3                         4    conda-forge
zeromq                    4.3.2                h6538335_2    conda-forge
zipp                      2.1.0                      py_0    conda-forge

Jupyterlab extensions:

Runs in base environment accesses the environment kernel using nb_conda_kernels

(base) H:\>labextension list

JupyterLab v1.2.6
Known labextensions:
   app dir: C:\ProgramData\Miniconda3\share\jupyter\lab
        @aquirdturtle/collapsible_headings v0.5.0 enabled  ok
        @bokeh/jupyter_bokeh v1.1.1 enabled  ok
        @jupyter-widgets/jupyterlab-manager v1.1.0 enabled  ok
        @jupyterlab/toc v1.0.1 enabled  ok
        @lckr/jupyterlab_variableinspector v0.3.0 enabled  ok
        @pyviz/jupyterlab_pyviz v0.8.0 enabled  ok
        jupyter-matplotlib v0.5.0 enabled  ok
        jupyterlab-jupytext v1.1.1 enabled  ok
        jupyterlab-system-monitor v0.4.1 enabled  ok
        jupyterlab-theme-toggle v0.4.2 enabled  ok
        jupyterlab-topbar-extension v0.4.0 enabled  ok
        qgrid v1.1.1 enabled  ok

Description of Issue

Qgrid seems to be incompatible with Pandas 1.0.0.

Reproduction Steps

Notebook Cell:

import qgrid
qwid = qgrid.show_grid(pd.DataFrame({'col1': [1, 2], 'col2': [3, 4]}), show_toolbar=True)
qwid

Output:

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-26-f756e5d59b94> in <module>
      1 import qgrid
----> 2 qwid = qgrid.show_grid(pd.DataFrame({'col1': [1, 2], 'col2': [3, 4]}), show_toolbar=True)
      3 qwid

~\.conda\envs\WeldCompare\lib\site-packages\qgrid\grid.py in show_grid(data_frame, show_toolbar, precision, grid_options, column_options, column_definitions, row_edit_callback)
    509                        column_definitions=column_definitions,
    510                        row_edit_callback=row_edit_callback,
--> 511                        show_toolbar=show_toolbar)
    512 
    513 

~\.conda\envs\WeldCompare\lib\site-packages\qgrid\grid.py in __init__(self, *args, **kwargs)
    625 
    626         if self.df is not None:
--> 627             self._update_df()
    628 
    629     def _grid_options_default(self):

~\.conda\envs\WeldCompare\lib\site-packages\qgrid\grid.py in _update_df(self)
    818         self._unfiltered_df = self._df.copy()
    819 
--> 820         self._update_table(update_columns=True, fire_data_change_event=False)
    821         self._ignore_df_changed = False
    822 

~\.conda\envs\WeldCompare\lib\site-packages\qgrid\grid.py in _update_table(self, update_columns, triggered_by, scroll_to_row, fire_data_change_event)
    877                        isinstance(col_series, pd.PeriodIndex)
    878 
--> 879             if type(df.index) == pd.core.index.MultiIndex:
    880                 self._multi_index = True
    881                 for idx, cur_level in enumerate(df.index.levels):

AttributeError: module 'pandas.core' has no attribute 'index'

Possible solution

From Pandas Release Notes:

pandas.core.index has been deprecated and will be removed in a future version, the public classes are available in the top-level namespace (GH19711)

The text was updated successfully, but these errors were encountered:

ajp619 · 2020-01-31T18:18:56Z

+1 same issue
I was able to get things working by modifying grid.py:

line 879:
if type(df.index) == pd.core.index.MultiIndex: -> if type(df.index) == pd.MultiIndex:
line 916:
if type(df.index) == pd.core.index.MultiIndex and \ -> if type(df.index) == pd.MultiIndex and \

DinisCruz · 2020-02-05T22:43:06Z

Just got hit by this issue too, so is the solution to downgrade for now, and then use the release the qgrid that has the update merged above?

richlysakowski · 2020-02-06T23:17:33Z

The code edits above worked for me. I am so grateful, since I want to work with the latest pandas and Python 3.7 and not go backward. Can someone please push the edits to the Quantopian Qgrid repository?

Pandas 1.0.1 had a breaking change for qgrid because core.index was deprecated. This fixes it. For more information see: quantopian#287

richlysakowski · 2020-02-06T23:57:38Z

I pushed the edits to the Quantopian github repo for this. I need someone to approve it to become part of the master.

astrojuanlu · 2020-02-07T06:12:05Z

Fixed in #290. Plans for a release? :)

bajizhh · 2020-02-11T00:57:51Z

i have the same error, fixing it please!

richlysakowski · 2020-02-11T02:14:46Z

It is already fixed. I posted the fix over the weekend.

…

On Mon, Feb 10, 2020, 7:57 PM bajizhh ***@***.***> wrote: i have the same error, fixing it please! — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#287?email_source=notifications&email_token=ACHJVL2OD5PXUSFQ2BULTBTRCHZZBA5CNFSM4KOETD6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOELK3U5I#issuecomment-584432245>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACHJVL4QTKGBAIOPE6TWYBLRCHZZBANCNFSM4KOETD6A> .

jongablop · 2020-02-15T18:57:03Z

Does anyone know when will be the fixed version released so it can be installed through pip?

richlysakowski · 2020-02-15T21:58:24Z

Just make the change yourself for your local installation. I posted the fix earlier. Quantopian engineers have not yet approved the pull request on the github repository.

…

On Sat, Feb 15, 2020, 1:57 PM Jon Gabirondo-López ***@***.***> wrote: Does anyone know when will be the fixed version released so it can be installed through pip? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#287?email_source=notifications&email_token=ACHJVL6DY6WE2E4IKWYWXGLRDA3IBA5CNFSM4KOETD6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEL3UNVI#issuecomment-586630869>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACHJVL3E3DK5OE3TV5RKZZTRDA3IBANCNFSM4KOETD6A> .

racuna · 2020-02-17T15:05:27Z

I had to downgrade. I hope the fix will release soon.

gerrymanoim · 2020-02-18T16:58:49Z

Hey all - thanks for all the reports/follow ups here! I'm currently working on a new CI/CD branch (#293) that uncovered some issues with pandas 1.0.1/qgrid. Namely:

Some tz-naive and tz-aware timestamp issues
Period columns not being able to be converted into json (to_json of Series with period dtype results in AttributeError pandas-dev/pandas#31917)

Once we fix or work around these issues, we'll cut a new release.

gerrymanoim · 2020-02-25T17:41:15Z

We've now released a new version. Period columns are still broken, but otherwise it is good to use with pandas 1.0

andreassimon · 2020-03-21T20:24:07Z

We've now released a new version. Period columns are still broken, but otherwise it is good to use with pandas 1.0

I just tried to install version 1.3.0 of qgrid via conda, but the most recent version in conda-forge seems to be 1.1.1. Is there another way to get 1.3.0 into Jupyter Lab?

senkin · 2020-03-30T20:43:43Z

@andreassimon I managed to bypass this by installing pip within the conda environment and just upgrading qgrid with pip install qgrid --upgrade. I also had to remove the virualenv requirement of pip with export PIP_REQUIRE_VIRTUALENV=false. Hope this helps!

samlakhmani · 2020-06-14T14:19:26Z

I am a beginner, can someone tell me how to make this edit in the local

The problem is still there in June

CarlosGrohmann · 2020-06-15T15:19:24Z

I confirm this is still present in v.1.3.1 (Manjaro Linux, Pandas 1.0.3, no virtualenv)

mkincaid · 2020-08-06T22:38:16Z

Contra preceding two comments, I had this issue in 1.1.1 but did find it fixed after upgrading to 1.3.1. The issue may be that "stable" anaconda still provides qgrid 1.1.1; you need conda-forge enabled to get 1.3.1.

To fix in Navigator:

From Environments tab, click Channels button
Enter channel name conda-forge and hit return
Hit Update channels button
You should now be able to search for qgrid 1.3.1 in the package list, add, and apply

To fix from command line:

Use the config command given in the README to add the conda-forge channel
conda install qgrid
Optionally, if you don't want your other packages upgraded to "bleeding edge" from conda-forge, you can remove conda-forge after qgrid-1.3.1 is installed:
conda config --remove channels conda-forge

alexmill · 2021-08-10T06:12:24Z

To follow up on @mkincaid's comment, note you can install qgrid 1.3.1 from the conda-forge channel in one line with:

conda install -c conda-forge qgrid=1.3.1

This does not require you to make conda-forge your default channel for your environment.

rosbo mentioned this issue Feb 3, 2020

Pin pandas to 0.25.3 Kaggle/docker-python#699

Merged

richlysakowski added a commit to richlysakowski/qgrid that referenced this issue Feb 6, 2020

update grid.py

613d87a

Pandas 1.0.1 had a breaking change for qgrid because core.index was deprecated. This fixes it. For more information see: quantopian#287

richlysakowski mentioned this issue Feb 6, 2020

update grid.py for changes in pandas 1.0.1 #290

Merged

keatonb mentioned this issue Feb 10, 2020

Issue arising from pandas 1.0.1 update keatonb/Pyriod#3

Closed

gerrymanoim mentioned this issue Feb 18, 2020

Pandas 1.0.1 Compatibility #294

Closed

gerrymanoim mentioned this issue Feb 18, 2020

Javascript inconsistent between PyPI and npm/unpkg #291

Closed

gerrymanoim closed this as completed Feb 25, 2020

pbadenski mentioned this issue Apr 2, 2020

qgrid 1.2.0 & 1.3.0 are not available in conda-forge #302

Open

david-lippert mentioned this issue Apr 30, 2020

vegalite no longer working with pandas 1.0 or later version vega/ipyvega#203

Closed

ericbdaniels mentioned this issue Feb 26, 2021

Trouble getting qgrid to work with Jupyter Notebooks on Windows 10. #355

Open

lukewys mentioned this issue Nov 30, 2021

Support installation of custom widgets. googlecolab/colabtools#498

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Pandas 1.0.0 Compatibility #287

Pandas 1.0.0 Compatibility #287

joshkreud commented Jan 31, 2020 •

edited

Loading

ajp619 commented Jan 31, 2020

DinisCruz commented Feb 5, 2020

richlysakowski commented Feb 6, 2020 •

edited

Loading

richlysakowski commented Feb 6, 2020

astrojuanlu commented Feb 7, 2020

bajizhh commented Feb 11, 2020

richlysakowski commented Feb 11, 2020 via email

jongablop commented Feb 15, 2020

richlysakowski commented Feb 15, 2020 via email

racuna commented Feb 17, 2020

gerrymanoim commented Feb 18, 2020

gerrymanoim commented Feb 25, 2020

andreassimon commented Mar 21, 2020

senkin commented Mar 30, 2020

samlakhmani commented Jun 14, 2020

CarlosGrohmann commented Jun 15, 2020

mkincaid commented Aug 6, 2020 •

edited

Loading

alexmill commented Aug 10, 2021 •

edited

Loading

Pandas 1.0.0 Compatibility #287

Pandas 1.0.0 Compatibility #287

Comments

joshkreud commented Jan 31, 2020 • edited Loading

Issue

Environment

Description of Issue

Reproduction Steps

Possible solution

ajp619 commented Jan 31, 2020

DinisCruz commented Feb 5, 2020

richlysakowski commented Feb 6, 2020 • edited Loading

richlysakowski commented Feb 6, 2020

astrojuanlu commented Feb 7, 2020

bajizhh commented Feb 11, 2020

richlysakowski commented Feb 11, 2020 via email

jongablop commented Feb 15, 2020

richlysakowski commented Feb 15, 2020 via email

racuna commented Feb 17, 2020

gerrymanoim commented Feb 18, 2020

gerrymanoim commented Feb 25, 2020

andreassimon commented Mar 21, 2020

senkin commented Mar 30, 2020

samlakhmani commented Jun 14, 2020

CarlosGrohmann commented Jun 15, 2020

mkincaid commented Aug 6, 2020 • edited Loading

alexmill commented Aug 10, 2021 • edited Loading

joshkreud commented Jan 31, 2020 •

edited

Loading

richlysakowski commented Feb 6, 2020 •

edited

Loading

mkincaid commented Aug 6, 2020 •

edited

Loading

alexmill commented Aug 10, 2021 •

edited

Loading