Help displaying a Completeness chart from Splink

[RTranLA]

Hello,

Essentially, I'm trying to display a completeness chart from Splink. I have done something like this before. Here is the code I used:

  import pandas as pd

  df = pd.read_excel('file.xlsx')
  
  from splink.exploratory import completeness_chart
  from splink import DuckDBAPI
  db_api = DuckDBAPI()
  completeness_chart(df, db_api=db_api).show()

But when I ran this, I got this error message:

  File C:\ProgramData\anaconda3\Lib\site-packages\altair\vegalite\v5\api.py:2274 in show
    import altair_viewer  # type: ignore

ModuleNotFoundError: No module named 'altair_viewer'


The above exception was the direct cause of the following exception:

Traceback (most recent call last):

  File C:\ProgramData\anaconda3\Lib\site-packages\spyder_kernels\py3compat.py:356 in compat_exec
    exec(code, globals, locals)

  File C:\ProgramData\anaconda3\Lib\site-packages\altair\vegalite\v5\api.py:2276 in show
    raise ValueError(

ValueError: 'show' method requires the altair_viewer package. See http://github.com/altair-viz/altair_viewer

Which confused me, because I'm pretty sure I installed altair. Here is a list of my packages from "pip list":

    Package                           Version
    --------------------------------- ------------------
    aiobotocore                       2.12.3
    aiohttp                           3.9.5
    aioitertools                      0.7.1
    aiosignal                         1.2.0
    alabaster                         0.7.16
    altair                            5.0.1
    anaconda-anon-usage               0.4.4
    anaconda-catalogs                 0.2.0
    anaconda-client                   1.12.3
    anaconda-cloud-auth               0.5.1
    anaconda-navigator                2.6.0
    anaconda-project                  0.11.1
    annotated-types                   0.6.0
    anyio                             4.2.0
    appdirs                           1.4.4
    archspec                          0.2.3
    argon2-cffi                       21.3.0
    argon2-cffi-bindings              21.2.0
    arrow                             1.2.3
    astroid                           2.14.2
    astropy                           6.1.0
    astropy-iers-data                 0.2024.6.3.0.31.14
    asttokens                         2.0.5
    async-lru                         2.0.4
    atomicwrites                      1.4.0
    attrs                             23.1.0
    Automat                           20.2.0
    autopep8                          2.0.4
    Babel                             2.11.0
    bcrypt                            3.2.0
    beautifulsoup4                    4.12.3
    binaryornot                       0.4.4
    black                             24.4.2
    bleach                            4.1.0
    blinker                           1.6.2
    bokeh                             3.4.1
    boltons                           23.0.0
    botocore                          1.34.69
    Bottleneck                        1.3.7
    Brotli                            1.0.9
    cachetools                        5.3.3
    certifi                           2024.6.2
    cffi                              1.16.0
    chardet                           4.0.0
    charset-normalizer                2.0.4
    click                             8.1.7
    cloudpickle                       2.2.1
    colorama                          0.4.6
    colorcet                          3.1.0
    comm                              0.2.1
    conda                             24.5.0
    conda-build                       24.5.1
    conda-content-trust               0.2.0
    conda_index                       0.5.0
    conda-libmamba-solver             24.1.0
    conda-pack                        0.7.1
    conda-package-handling            2.3.0
    conda_package_streaming           0.10.0
    conda-repo-cli                    1.0.88
    conda-token                       0.5.0+1.g2209e04
    constantly                        23.10.4
    contourpy                         1.2.0
    cookiecutter                      2.6.0
    cryptography                      42.0.5
    cssselect                         1.2.0
    cycler                            0.11.0
    Cython                            3.1.1
    cytoolz                           0.12.2
    dask                              2024.5.0
    dask-expr                         1.1.0
    datashader                        0.16.2
    debugpy                           1.6.7
    decorator                         5.1.1
    defusedxml                        0.7.1
    diff-match-patch                  20200713
    dill                              0.4.0
    distributed                       2024.5.0
    distro                            1.9.0
    docstring-to-markdown             0.11
    docutils                          0.18.1
    duckdb                            1.3.0
    entrypoints                       0.4
    et-xmlfile                        1.1.0
    executing                         0.8.3
    fastjsonschema                    2.16.2
    filelock                          3.13.1
    flake8                            7.0.0
    Flask                             3.0.3
    fonttools                         4.51.0
    frozendict                        2.4.2
    frozenlist                        1.4.0
    fsspec                            2024.3.1
    gensim                            4.3.2
    gitdb                             4.0.7
    GitPython                         3.1.37
    greenlet                          3.0.1
    h5py                              3.11.0
    HeapDict                          1.0.1
    holoviews                         1.19.0
    hvplot                            0.10.0
    hyperlink                         21.0.0
    idna                              3.7
    igraph                            0.11.8
    imagecodecs                       2023.1.23
    imageio                           2.33.1
    imagesize                         1.4.1
    imbalanced-learn                  0.12.3
    importlib-metadata                7.0.1
    incremental                       22.10.0
    inflection                        0.5.1
    iniconfig                         1.1.1
    intake                            0.7.0
    intervaltree                      3.1.0
    ipykernel                         6.28.0
    ipython                           8.25.0
    ipython-genutils                  0.2.0
    ipywidgets                        7.8.1
    isort                             5.13.2
    itemadapter                       0.3.0
    itemloaders                       1.1.0
    itsdangerous                      2.2.0
    jaraco.classes                    3.2.1
    jedi                              0.18.1
    jellyfish                         1.0.1
    Jinja2                            3.1.4
    jmespath                          1.0.1
    joblib                            1.4.2
    json5                             0.9.6
    jsonpatch                         1.33
    jsonpointer                       2.1
    jsonschema                        4.19.2
    jsonschema-specifications         2023.7.1
    jupyter                           1.0.0
    jupyter_client                    8.6.0
    jupyter-console                   6.6.3
    jupyter_core                      5.7.2
    jupyter-events                    0.10.0
    jupyter-lsp                       2.2.0
    jupyter_server                    2.14.1
    jupyter_server_terminals          0.4.4
    jupyterlab                        4.0.11
    jupyterlab-pygments               0.1.2
    jupyterlab_server                 2.25.1
    jupyterlab-widgets                1.0.0
    keyring                           24.3.1
    kiwisolver                        1.4.4
    lazy_loader                       0.4
    lazy-object-proxy                 1.10.0
    lckr_jupyterlab_variableinspector 3.1.0
    libarchive-c                      2.9
    libmambapy                        1.5.8
    linkify-it-py                     2.0.0
    llvmlite                          0.42.0
    lmdb                              1.4.1
    locket                            1.0.0
    lxml                              5.2.1
    lz4                               4.3.2
    Markdown                          3.4.1
    markdown-it-py                    2.2.0
    MarkupSafe                        2.1.3
    matplotlib                        3.8.4
    matplotlib-inline                 0.1.6
    mccabe                            0.7.0
    mdit-py-plugins                   0.3.0
    mdurl                             0.1.0
    menuinst                          2.1.1
    mistune                           2.0.4
    mkl-fft                           1.3.8
    mkl-random                        1.2.4
    mkl-service                       2.4.0
    more-itertools                    10.1.0
    mpmath                            1.3.0
    msgpack                           1.0.3
    multidict                         6.0.4
    multipledispatch                  0.6.0
    multiprocess                      0.70.18
    mypy                              1.10.0
    mypy-extensions                   1.0.0
    navigator-updater                 0.5.1
    nbclient                          0.8.0
    nbconvert                         7.10.0
    nbformat                          5.9.2
    nest-asyncio                      1.6.0
    networkx                          3.2.1
    nltk                              3.8.1
    notebook                          7.0.8
    notebook_shim                     0.2.3
    numba                             0.59.1
    numexpr                           2.8.7
    numpy                             1.26.4
    numpydoc                          1.7.0
    openpyxl                          3.1.2
    overrides                         7.4.0
    packaging                         23.2
    pandas                            2.2.2
    pandocfilters                     1.5.0
    panel                             1.4.4
    param                             2.1.0
    paramiko                          2.8.1
    parsel                            1.8.1
    parso                             0.8.3
    partd                             1.4.1
    pathspec                          0.10.3
    patsy                             0.5.6
    pexpect                           4.8.0
    pickleshare                       0.7.5
    pillow                            10.3.0
    pip                               24.0
    pkce                              1.0.3
    pkginfo                           1.10.0
    platformdirs                      3.10.0
    plotly                            5.22.0
    pluggy                            1.0.0
    ply                               3.11
    prometheus-client                 0.14.1
    prompt-toolkit                    3.0.43
    Protego                           0.1.16
    protobuf                          3.20.3
    psutil                            5.9.0
    ptyprocess                        0.7.0
    pure-eval                         0.2.2
    py-cpuinfo                        9.0.0
    pyarrow                           14.0.2
    pyasn1                            0.4.8
    pyasn1-modules                    0.2.8
    pycodestyle                       2.11.1
    pycosat                           0.6.6
    pycparser                         2.21
    pyct                              0.5.0
    pycurl                            7.45.2
    pydantic                          2.5.3
    pydantic_core                     2.14.6
    pydeck                            0.8.0
    PyDispatcher                      2.0.5
    pydocstyle                        6.3.0
    pyerfa                            2.0.1.4
    pyflakes                          3.2.0
    Pygments                          2.15.1
    PyJWT                             2.8.0
    pylint                            2.16.2
    pylint-venv                       3.0.3
    pyls-spyder                       0.4.0
    PyNaCl                            1.5.0
    pyodbc                            5.0.1
    pyOpenSSL                         24.0.0
    pyparsing                         3.0.9
    PyQt5                             5.15.10
    PyQt5-sip                         12.13.0
    PyQtWebEngine                     5.15.6
    pyrallel.lib                      0.0.10
    PySocks                           1.7.1
    pytest                            7.4.4
    python-dateutil                   2.9.0.post0
    python-dotenv                     0.21.0
    python-json-logger                2.0.7
    python-lsp-black                  2.0.0
    python-lsp-jsonrpc                1.1.2
    python-lsp-server                 1.10.0
    python-slugify                    5.0.2
    python-snappy                     0.6.1
    pytoolconfig                      1.2.6
    pytz                              2024.1
    pyviz_comms                       3.0.2
    pywavelets                        1.5.0
    pywin32                           305.1
    pywin32-ctypes                    0.2.2
    pywinpty                          2.0.10
    PyYAML                            6.0.1
    pyzmq                             25.1.2
    QDarkStyle                        3.2.3
    qstylizer                         0.2.2
    QtAwesome                         1.2.2
    qtconsole                         5.5.1
    QtPy                              2.4.1
    queuelib                          1.6.2
    recordlinkage                     0.16
    referencing                       0.30.2
    regex                             2023.10.3
    requests                          2.32.2
    requests-file                     1.5.1
    requests-toolbelt                 1.0.0
    rfc3339-validator                 0.1.4
    rfc3986-validator                 0.1.1
    rich                              13.3.5
    rltk                              2.0.0a20
    rope                              1.12.0
    rpds-py                           0.10.6
    Rtree                             1.0.1
    ruamel.yaml                       0.17.21
    ruamel-yaml-conda                 0.17.21
    s3fs                              2024.3.1
    scikit-image                      0.23.2
    scikit-learn                      1.4.2
    scipy                             1.13.1
    Scrapy                            2.11.1
    seaborn                           0.13.2
    semver                            3.0.2
    Send2Trash                        1.8.2
    service-identity                  18.1.0
    setuptools                        69.5.1
    sip                               6.7.12
    six                               1.16.0
    smart-open                        5.2.1
    smmap                             4.0.0
    sniffio                           1.3.0
    snowballstemmer                   2.2.0
    sortedcontainers                  2.4.0
    soupsieve                         2.5
    Sphinx                            7.3.7
    sphinxcontrib-applehelp           1.0.2
    sphinxcontrib-devhelp             1.0.2
    sphinxcontrib-htmlhelp            2.0.0
    sphinxcontrib-jsmath              1.0.1
    sphinxcontrib-qthelp              1.0.3
    sphinxcontrib-serializinghtml     1.1.10
    splink                            4.0.7
    spyder                            5.5.1
    spyder-kernels                    2.5.0
    SQLAlchemy                        2.0.30
    sqlglot                           26.24.0
    stack-data                        0.2.0
    statsmodels                       0.14.2
    streamlit                         1.32.0
    sympy                             1.12
    tables                            3.9.2
    tabulate                          0.9.0
    tblib                             1.7.0
    tenacity                          8.2.2
    terminado                         0.17.1
    text-unidecode                    1.3
    textdistance                      4.2.1
    texttable                         1.7.0
    threadpoolctl                     2.2.0
    three-merge                       0.1.1
    tifffile                          2023.4.12
    tinycss2                          1.2.1
    tldextract                        3.2.0
    toml                              0.10.2
    tomli                             2.0.1
    tomlkit                           0.11.1
    toolz                             0.12.0
    tornado                           6.4.1
    tqdm                              4.66.4
    traitlets                         5.14.3
    truststore                        0.8.0
    Twisted                           23.10.0
    twisted-iocpsupport               1.0.2
    typing                            3.7.4.3
    typing_extensions                 4.11.0
    tzdata                            2023.3
    uc-micro-py                       1.0.1
    ujson                             5.10.0
    unicodedata2                      15.1.0
    Unidecode                         1.2.0
    urllib3                           2.2.2
    w3lib                             2.1.2
    watchdog                          4.0.1
    wcwidth                           0.2.5
    webencodings                      0.5.1
    websocket-client                  1.8.0
    Werkzeug                          3.0.3
    whatthepatch                      1.0.2
    wheel                             0.43.0
    widgetsnbextension                3.6.6
    win-inet-pton                     1.1.0
    wrapt                             1.14.1
    xarray                            2023.6.0
    xlwings                           0.31.4
    xyzservices                       2022.9.0
    yapf                              0.40.2
    yarl                              1.9.3
    zict                              3.0.0
    zipp                              3.17.0
    zope.interface                    5.4.0
    zstandard                         0.22.0

Not exactly sure where I went wrong. One more thing,if it helps. I'm basing my python code off of this code from this link(https://moj-analytical-services.github.io/splink/demos/tutorials/02_Exploratory_analysis.html), which is:
from splink import splink_datasets

    df = splink_datasets.fake_1000
    from splink.exploratory import completeness_chart
    from splink import DuckDBAPI
    db_api = DuckDBAPI()
    completeness_chart(df, db_api=db_api)

That's all I have to say for now. Hope to hear something soon. Thanks

[kjgoodrick]

completeness_chart outputs an Altair chart object which you should be able to view as described in the docs. If you're in a notebook you can just remove the .show() and it should show in the cell output. .show() requires altair_viewer which is seperate from altair and also no longer maintained.

[RTranLA]

Forgive me for the late reply, but I have an update on the situation.

First off, I am using Spyder to run my python code. That's relevant because after combing through the docs, I stumbled across browser renderer, which looks like something that works with Spyder. So, I tweaked my code to look like this:

import pandas as pd
import altair as alt
alt.renderers.enable("browser")
df = pd.read_excel('file.xlsx')

from splink.exploratory import completeness_chart
from splink import DuckDBAPI
db_api = DuckDBAPI()
completeness_chart(df, db_api=db_api)

But when I ran the code, I got this:
NoSuchEntryPoint: No 'browser' entry point found in group 'altair.vegalite.v5.renderer'

Not sure where I went wrong. Do you know?

[kjgoodrick]

You may need to install Vega `pip install vega`. If that doesn’t work you may need to use the svg renderer.

…

On Mon, Jun 23, 2025 at 11:15 AM RTranLA ***@***.***> wrote: Forgive me for the late reply, but I have an update on the situation. First off, I am using Spyder to run my python code. That's relevant because after combing through the docs, I stumbled across browser renderer, which looks like something that works with Spyder. So, I tweaked my code to look like this: import pandas as pd import altair as alt alt.renderers.enable("browser") df = pd.read_excel('file.xlsx') from splink.exploratory import completeness_chart from splink import DuckDBAPI db_api = DuckDBAPI() completeness_chart(df, db_api=db_api) But when I ran the code, I got this: NoSuchEntryPoint: No 'browser' entry point found in group 'altair.vegalite.v5.renderer' Not sure where I went wrong. Do you know? — Reply to this email directly, view it on GitHub <#3843 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAOSGHB5YHEQDHJKWXTVVW33FAY2BAVCNFSM6AAAAAB6WKDWX2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTGNJVGM3DIMY> . You are receiving this because you commented.Message ID: ***@***.***>

[RTranLA]

After installing vega, I tried again, but I still got the same error.
I did try using the svg renderer and saving the chart as a svg. That worked pretty well.
Is there no way to use the browser?