TraitError: n_rows and n_columns must be positive integer

[kovar-ursa]

Describe the bug

When running profile.to_widgets() on this error was generated when it tried to present the widget:

TraitError: n_rows and n_columns must be positive integer

To Reproduce

<class 'pandas.core.frame.DataFrame'>
DatetimeIndex: 42492 entries, 2021-06-01 08:58:47+00:00 to 2021-06-30 00:38:09+00:00
Data columns (total 13 columns):
 #   Column          Non-Null Count  Dtype                     
---  ------          --------------  -----                     
 0   AeroscopeID     42492 non-null  string                    
 1   DroneType       42492 non-null  string                    
 2   Callsign        42492 non-null  string                    
 3   FlightID        42492 non-null  string                    
 4   Latitude        42492 non-null  float64                   
 5   Longitude       42492 non-null  float64                   
 6   Speed           42492 non-null  float64                   
 7   AGL             42492 non-null  float64                   
 8   HomeLongitude   42492 non-null  float64                   
 9   HomeLatitude    42492 non-null  float64                   
 10  PilotLongitude  42492 non-null  float64                   
 11  PilotLatitude   42492 non-null  float64                   
 12  TimeLocal       42492 non-null  datetime64[ns, US/Eastern]
dtypes: datetime64[ns, US/Eastern](1), float64(8), string(4)
memory usage: 4.5 MB

The dataset it sensitive and cannot be shared.

Version information:

python 3.9.7

Click to expand Version information

altair==4.1.0
anyio @ file:///Users/runner/miniforge3/conda-bld/anyio_1632754437423/work/dist
appnope @ file:///Users/runner/miniforge3/conda-bld/appnope_1610094673755/work
argon2-cffi @ file:///Users/runner/miniforge3/conda-bld/argon2-cffi_1625821234041/work
astor==0.8.1
async-generator==1.10
attrs @ file:///home/conda/feedstock_root/build_artifacts/attrs_1620387926260/work
Babel @ file:///home/conda/feedstock_root/build_artifacts/babel_1619719576210/work
backcall @ file:///home/conda/feedstock_root/build_artifacts/backcall_1592338393461/work
backports.functools-lru-cache @ file:///home/conda/feedstock_root/build_artifacts/backports.functools_lru_cache_1618230623929/work
base58==2.1.0
bleach @ file:///home/conda/feedstock_root/build_artifacts/bleach_1629908509068/work
blinker==1.4
boto3 @ file:///home/conda/feedstock_root/build_artifacts/boto3_1631951251863/work
botocore @ file:///home/conda/feedstock_root/build_artifacts/botocore_1632782434050/work
brotlipy==0.7.0
cachetools==4.2.2
certifi==2021.5.30
cffi @ file:///Users/runner/miniforge3/conda-bld/cffi_1625835329396/work
chardet @ file:///Users/runner/miniforge3/conda-bld/chardet_1610093613037/work
charset-normalizer @ file:///home/conda/feedstock_root/build_artifacts/charset-normalizer_1626371162869/work
click==7.1.2
click-plugins==1.1.1
cligj @ file:///home/conda/feedstock_root/build_artifacts/cligj_1622246659049/work
cryptography @ file:///Users/runner/miniforge3/conda-bld/cryptography_1616851523607/work
cycler==0.10.0
debugpy @ file:///Users/runner/miniforge3/conda-bld/debugpy_1627075104865/work
decorator @ file:///home/conda/feedstock_root/build_artifacts/decorator_1631346842025/work
defusedxml @ file:///home/conda/feedstock_root/build_artifacts/defusedxml_1615232257335/work
entrypoints @ file:///home/conda/feedstock_root/build_artifacts/entrypoints_1605121927639/work/dist/entrypoints-0.3-py2.py3-none-any.whl
Fiona==1.8.20
fsspec @ file:///home/conda/feedstock_root/build_artifacts/fsspec_1632442862447/work
GDAL==3.3.2
geographiclib @ file:///home/conda/feedstock_root/build_artifacts/geographiclib_1624386157733/work
geopandas @ file:///home/conda/feedstock_root/build_artifacts/geopandas_1623249625470/work
geopy @ file:///home/conda/feedstock_root/build_artifacts/geopy_1626114677070/work
gitdb==4.0.7
GitPython==3.1.24
greenlet @ file:///Users/runner/miniforge3/conda-bld/greenlet_1628272262836/work
htmlmin==0.1.12
idna @ file:///home/conda/feedstock_root/build_artifacts/idna_1609836280497/work
ImageHash==4.2.1
importlib-metadata @ file:///Users/runner/miniforge3/conda-bld/importlib-metadata_1630267507666/work
ipykernel @ file:///Users/runner/miniforge3/conda-bld/ipykernel_1631291142144/work/dist/ipykernel-6.4.1-py3-none-any.whl
ipython @ file:///Users/runner/miniforge3/conda-bld/ipython_1632763987529/work
ipython-genutils==0.2.0
ipywidgets @ file:///home/conda/feedstock_root/build_artifacts/ipywidgets_1631590360471/work
jedi @ file:///Users/runner/miniforge3/conda-bld/jedi_1610146808808/work
Jinja2 @ file:///home/conda/feedstock_root/build_artifacts/jinja2_1621419064915/work
jmespath @ file:///home/conda/feedstock_root/build_artifacts/jmespath_1589369830981/work
joblib @ file:///home/conda/feedstock_root/build_artifacts/joblib_1612898609989/work
json5 @ file:///home/conda/feedstock_root/build_artifacts/json5_1600692310011/work
jsonschema @ file:///home/conda/feedstock_root/build_artifacts/jsonschema_1614815863336/work
jupyter @ file:///Users/runner/miniforge3/conda-bld/jupyter_1611871926923/work
jupyter-client @ file:///home/conda/feedstock_root/build_artifacts/jupyter_client_1632841627383/work
jupyter-console @ file:///home/conda/feedstock_root/build_artifacts/jupyter_console_1616560109969/work
jupyter-core==4.8.1
jupyter-server @ file:///home/conda/feedstock_root/build_artifacts/jupyter_server_1631218027728/work
jupyterlab @ file:///home/conda/feedstock_root/build_artifacts/jupyterlab_1631631911084/work
jupyterlab-pygments==0.1.2
jupyterlab-server @ file:///home/conda/feedstock_root/build_artifacts/jupyterlab_server_1632590716858/work
jupyterlab-widgets @ file:///home/conda/feedstock_root/build_artifacts/jupyterlab_widgets_1631590465624/work
kiwisolver @ file:///Users/runner/miniforge3/conda-bld/kiwisolver_1630173773255/work
mapclassify @ file:///home/conda/feedstock_root/build_artifacts/mapclassify_1627363180059/work
MarkupSafe @ file:///Users/runner/miniforge3/conda-bld/markupsafe_1621455730541/work
matplotlib @ file:///Users/runner/miniforge3/conda-bld/matplotlib-suite_1632416605047/work
matplotlib-inline @ file:///home/conda/feedstock_root/build_artifacts/matplotlib-inline_1631080358261/work
missingno==0.5.0
mistune @ file:///Users/runner/miniforge3/conda-bld/mistune_1624941339085/work
multimethod==1.6
munch==2.5.0
nbclassic @ file:///home/conda/feedstock_root/build_artifacts/nbclassic_1631880505492/work
nbclient @ file:///home/conda/feedstock_root/build_artifacts/nbclient_1629120697898/work
nbconvert @ file:///Users/runner/miniforge3/conda-bld/nbconvert_1632536029521/work
nbformat==5.1.3
nest-asyncio @ file:///home/conda/feedstock_root/build_artifacts/nest-asyncio_1617163391303/work
networkx @ file:///home/conda/feedstock_root/build_artifacts/networkx_1598210780226/work
notebook==6.4.4
numpy @ file:///Users/runner/miniforge3/conda-bld/numpy_1629092076711/work
olefile @ file:///home/conda/feedstock_root/build_artifacts/olefile_1602866521163/work
packaging @ file:///home/conda/feedstock_root/build_artifacts/packaging_1625323647219/work
pandas==1.3.3
pandas-profiling==3.1.0
pandocfilters @ file:///home/conda/feedstock_root/build_artifacts/pandocfilters_1631603243851/work
parso @ file:///home/conda/feedstock_root/build_artifacts/parso_1617148930513/work
pexpect @ file:///home/conda/feedstock_root/build_artifacts/pexpect_1602535608087/work
phik==0.12.0
pickleshare @ file:///home/conda/feedstock_root/build_artifacts/pickleshare_1602536217715/work
Pillow @ file:///Users/runner/miniforge3/conda-bld/pillow_1630696651849/work
prometheus-client @ file:///home/conda/feedstock_root/build_artifacts/prometheus_client_1622586138406/work
prompt-toolkit @ file:///home/conda/feedstock_root/build_artifacts/prompt-toolkit_1629903925368/work
protobuf==3.18.0
ptyprocess @ file:///home/conda/feedstock_root/build_artifacts/ptyprocess_1609419310487/work/dist/ptyprocess-0.7.0-py2.py3-none-any.whl
pyarrow==5.0.0
pycparser @ file:///home/conda/feedstock_root/build_artifacts/pycparser_1593275161868/work
pydantic==1.8.2
pydeck @ file:///home/conda/feedstock_root/build_artifacts/pydeck_1630093567483/work
Pygments @ file:///home/conda/feedstock_root/build_artifacts/pygments_1629119114968/work
pyOpenSSL @ file:///home/conda/feedstock_root/build_artifacts/pyopenssl_1608055815057/work
pyparsing==2.4.7
pyproj @ file:///Users/runner/miniforge3/conda-bld/pyproj_1632526447121/work
PyQt5==5.12.3
PyQt5_sip==4.19.18
PyQtChart==5.12
PyQtWebEngine==5.12.1
pyrsistent @ file:///Users/runner/miniforge3/conda-bld/pyrsistent_1624984762901/work
PySocks @ file:///Users/runner/miniforge3/conda-bld/pysocks_1610291470465/work
python-dateutil @ file:///home/conda/feedstock_root/build_artifacts/python-dateutil_1626286286081/work
pytz @ file:///home/conda/feedstock_root/build_artifacts/pytz_1612179539967/work
PyWavelets==1.1.1
PyYAML==5.4.1
pyzmq @ file:///Users/runner/miniforge3/conda-bld/pyzmq_1631793531263/work
qtconsole @ file:///home/conda/feedstock_root/build_artifacts/qtconsole_1625023841584/work
QtPy @ file:///home/conda/feedstock_root/build_artifacts/qtpy_1632440819550/work
requests @ file:///home/conda/feedstock_root/build_artifacts/requests_1626393743643/work
requests-unixsocket==0.2.0
Rtree @ file:///Users/runner/miniforge3/conda-bld/rtree_1626987867021/work
s3fs==0.4.2
s3transfer @ file:///home/conda/feedstock_root/build_artifacts/s3transfer_1626384238958/work
scikit-learn @ file:///Users/runner/miniforge3/conda-bld/scikit-learn_1632611470401/work
scipy @ file:///Users/runner/miniforge3/conda-bld/scipy_1628206569514/work
seaborn==0.11.2
Send2Trash @ file:///home/conda/feedstock_root/build_artifacts/send2trash_1628511208346/work
Shapely @ file:///Users/runner/miniforge3/conda-bld/shapely_1622660863030/work
six @ file:///home/conda/feedstock_root/build_artifacts/six_1620240208055/work
smmap==4.0.0
sniffio @ file:///Users/runner/miniforge3/conda-bld/sniffio_1610318427209/work
SQLAlchemy @ file:///Users/runner/miniforge3/conda-bld/sqlalchemy_1629315197500/work
streamlit==0.89.0
tabulate @ file:///home/conda/feedstock_root/build_artifacts/tabulate_1614001031686/work
tangled-up-in-unicode==0.1.0
terminado @ file:///Users/runner/miniforge3/conda-bld/terminado_1631192978302/work
testpath @ file:///home/conda/feedstock_root/build_artifacts/testpath_1621261527237/work
threadpoolctl @ file:///home/conda/feedstock_root/build_artifacts/threadpoolctl_1626092076920/work
toml==0.10.2
toolz @ file:///home/conda/feedstock_root/build_artifacts/toolz_1600973991856/work
tornado @ file:///Users/runner/miniforge3/conda-bld/tornado_1625488906146/work
tqdm==4.62.3
traitlets @ file:///home/conda/feedstock_root/build_artifacts/traitlets_1630423529112/work
typing-extensions==3.10.0.2
tzlocal==3.0
urllib3 @ file:///home/conda/feedstock_root/build_artifacts/urllib3_1632350318291/work
validators==0.18.2
vega-datasets @ file:///home/conda/feedstock_root/build_artifacts/vega_datasets_1606414058616/work
visions==0.7.4
wcwidth @ file:///home/conda/feedstock_root/build_artifacts/wcwidth_1600965781394/work
webencodings==0.5.1
websocket-client @ file:///Users/runner/miniforge3/conda-bld/websocket-client_1610127894508/work
widgetsnbextension @ file:///Users/runner/miniforge3/conda-bld/widgetsnbextension_1605475534277/work
zipp @ file:///home/conda/feedstock_root/build_artifacts/zipp_1625284368454/work

[SebastianLarssonDTU]

I got the exact same error. My data is also sensitive. Python version: 3.7.11

[srinivasramakrishnan]

I was seeing the same error when I was using profile.to_widgets()
I tried profile.to_notebook_iframe() and it worked. I was using a notebook though

[sbrugman]

Please provide a minimal reproducible example and the stack trace to find the root cause.

[srinivasramakrishnan]

You can reproduce this with this public dataset - https://liangfgithub.github.io/F21/Ames_data.csv
which is based on https://www.kaggle.com/c/house-prices-advanced-regression-techniques/data

when you run the code below, you see the following error:

import pandas as pd
import numpy as np
from pandas_profiling import ProfileReport

df = pd.read_csv("Ames_data.csv")
profile = ProfileReport(df, explorative=True, 
                        title="Ames Dataset", 
                        html={"style": {"full_width": True}}, sort=None)
profile.to_widgets()

/usr/local/lib/python3.7/site-packages/ipywidgets/widgets/widget_templates.py in _validate_integer(self, proposal)
    293         if proposal['value'] > 0:
    294             return proposal['value']
--> 295         raise TraitError('n_rows and n_columns must be positive integer')
    296 
    297     def _get_indices_from_slice(self, row, column):

TraitError: n_rows and n_columns must be positive integer

When I replace profile.to_widgets() with profile.to_notebook_iframe(), it works.

[wonyoungseo]

This seems to be a bug in v3.1.0 release,
I downgraded to v3.0.0 and it works as it supposed to.

[AdamXCA]

I have the same problem as this, and I fixed it by the steps below.

1. uninstall pandas profiling
2. update Anaconda
3. update Notebook
4. !pip install https://github.com/pandas-profiling/pandas-profiling/archive/refs/tags/v3.0.0.zip

let me know if it works for you

[mickaelandrieu]

Hi, just to notice you I've managed to reproduce the issue too.

Also, the workaround for now is good :

replace profile.to_widgets() with profile.to_notebook_iframe()

[lmsasu]

This seems to be a bug in v3.1.0 release, I downgraded to v3.0.0 and it works as it supposed to.

The downgrade worked for me. Thanks.

[guillermo-carrasco]

I am having the same issue. Also using to_notebook_iframe() instead of to_widgets() seems to work, however the output is not as nice (you don't get all those well organized tabs)

[ApurvBhusari]

I was also having the same issue but after using to_notebook_iframe() . it worked for me . But there is a fix for to_widgets also. But downgrade your pandas profiling version from 3.1.0 to 3.0.0. pip install pandas_profiling==3.0.0. Make sure your pandas version is 1.3.5 . Hope this helps