No autocomplete for pandas.json_normalize

[janosh]

In a regular Python file, Pylance does not auto-complete pandas.json_normalize. Instead, I'm being shown pandas.read_json:

[jakebailey]

This shows up for me:

Can you provide your trace logs?

[janosh]

Not sure there's anything relevant in the trace logs. Are these the ones you're interested in?

import pandas as pd


pd.json

User belongs to experiment group 'pythonaacf'
User belongs to experiment group 'pythonJediLSP'
User belongs to experiment group 'pythonDiscoveryModuleWithoutWatcher'
User belongs to experiment group 'pythonTensorboardExperiment'
User belongs to experiment group 'PythonPyTorchProfiler'
User belongs to experiment group 'pythonDeprecatePythonPath'
User belongs to experiment group 'pythonSortEnvs'
Python interpreter path: ~/.venv/py39/bin/python
Starting Pylance language server.
conda --version
~/.venv/py39/bin/python ~/.vscode/extensions/ms-python.python-2021.8.1159798656/pythonFiles/sortImports.py - --diff
cwd: ~/test
~/.venv/py39/bin/python -m black --diff --quiet ~/test/t.py.44e3e4b77cd0b80beb46bdf0bd59ad13.tmp
cwd: ~/test
~/.venv/py39/bin/python -m black --diff --quiet ~/test/t.py.44e3e4b77cd0b80beb46bdf0bd59ad13.tmp
cwd: ~/test
~/.venv/py39/bin/python -m flake8 --format=%(row)d,%(col)d,%(code).1s,%(code)s:%(text)s ~/test/t.py
cwd: ~/test
~/.venv/py39/bin/python -m flake8 --format=%(row)d,%(col)d,%(code).1s,%(code)s:%(text)s ~/test/t.py
cwd: ~/test
~/.venv/py39/bin/python -m mypy --follow-imports=silent --ignore-missing-imports --show-column-numbers ~/test/t.py
cwd: ~/test
~/.venv/py39/bin/python -m mypy --follow-imports=silent --ignore-missing-imports --show-column-numbers ~/test/t.py
cwd: ~/test
##########Linting Output - flake8##########
##########Linting Output - mypy##########
Success: no issues found in 1 source file

[jakebailey]

No, I'm afraid not; those are the Python extension's logs. The issue template had a guide on how to find our logs, but the instructions are mirrored here: https://github.com/microsoft/pylance-release/blob/main/TROUBLESHOOTING.md#filing-an-issue

[janosh]

Sorry about that, here are the LS logs:

[Info - 8:21:55 AM] Pylance language server 2021.8.3 (pyright fa4194fd) starting
[Info - 8:21:55 AM] Server root directory: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist
[Info - 8:21:55 AM] No configuration file found.
[Info - 8:21:55 AM] No pyproject.toml file found.
[Info - 8:21:55 AM] Setting pythonPath for service "Desktop": "/Users/janosh/.venv/py39/bin/python"
[Warn - 8:21:55 AM] stubPath /Users/janosh/Desktop/typings is not a valid directory.
[Info - 8:21:55 AM] Assuming Python version 3.9
[Info - 8:21:55 AM] Assuming Python platform Darwin
Search paths for /Users/janosh/Desktop
/Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib
/Users/janosh/Desktop
/Users/janosh/Desktop/typings
/Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stubs/...
/Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/bundled/stubs
/usr/local/Cellar/python@3.9/3.9.6/Frameworks/Python.framework/Versions/3.9/lib/python3.9
/usr/local/Cellar/python@3.9/3.9.6/Frameworks/Python.framework/Versions/3.9/lib/python3.9/lib-dynload
/Users/janosh/.venv/py39/lib/python3.9/site-packages
/Users/janosh/Repos/roost
/Users/janosh/Repos/dielectric-frontier
/Users/janosh/Repos/ml-matrics
/Users/janosh/Repos/pdf-compressor
/Users/janosh/Repos/GAM
/Users/janosh/Repos/GAM/src
/Users/janosh/Repos/tensorboard-reducer
[Info - 8:21:55 AM] Searching for source files
[Info - 8:21:55 AM] Found 1 source file
IntelliCode model /Users/janosh/.vscode/extensions/visualstudioexptteam.vscodeintellicode-1.2.14/cache/E61945A9A512ED5E1A3EE3F1A2365B88F8FE_E4E9EADA96734F01970E616FAB2FAC19
[Info - 8:21:55 AM] Background analysis(1) root directory: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist
[Info - 8:21:55 AM] Background analysis(1) started
Background analysis message: setConfigOptions
Background analysis message: setImportResolver
Background analysis message: ensurePartialStubPackages
Background analysis message: setTrackedFiles
Background analysis message: markAllFilesDirty
Background analysis message: setFileOpened
Background analysis message: getSemanticTokens full
[BG(1)] getSemanticTokens full at /Users/janosh/Desktop/t.py ...
[BG(1)] parsing: /Users/janosh/Desktop/t.py (22ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/builtins.pyi [fs read 2ms] (81ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/builtins.pyi (37ms)
[BG(1)] binding: /Users/janosh/Desktop/t.py (1ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing.pyi [fs read 1ms] (46ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing.pyi (19ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/_typeshed/init.pyi [fs read 0ms] (11ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/_typeshed/init.pyi (3ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing_extensions.pyi [fs read 0ms] (3ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing_extensions.pyi (2ms)
[BG(1)] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/init.pyi [fs read 0ms] (24ms)
[BG(1)] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/init.pyi (1ms)
[BG(1)] getSemanticTokens full at /Users/janosh/Desktop/t.py (294ms)
Background analysis message: getSemanticTokens range
[BG(1)] getSemanticTokens range 0:0 - 4:0 at /Users/janosh/Desktop/t.py (0ms)
Background analysis message: analyze
[BG(1)] analyzing: /Users/janosh/Desktop/t.py ...
[BG(1)] checking: /Users/janosh/Desktop/t.py (1ms)
[BG(1)] analyzing: /Users/janosh/Desktop/t.py (1ms)
Background analysis message: resumeAnalysis
Loading ONNX runtime...
Loaded ONNX runtime. Creating IntelliCode session...
Created IntelliCode session.
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
Background analysis message: invalidateAndForceReanalysis
[Info - 8:22:01 AM] Searching for source files
[Info - 8:22:01 AM] Found 1 source file
Background analysis message: setTrackedFiles
Background analysis message: markAllFilesDirty
Background analysis message: analyze
[BG(1)] analyzing: /Users/janosh/Desktop/t.py ...
[BG(1)] parsing: /Users/janosh/Desktop/t.py (58ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/builtins.pyi [fs read 0ms] (36ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/builtins.pyi (23ms)
[BG(1)] binding: /Users/janosh/Desktop/t.py (0ms)
[BG(1)] checking: /Users/janosh/Desktop/t.py ...
[BG(1)] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/init.pyi [fs read 0ms] (17ms)
[BG(1)] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/init.pyi (1ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing.pyi [fs read 0ms] (8ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing.pyi (5ms)
[BG(1)] checking: /Users/janosh/Desktop/t.py (31ms)
[BG(1)] analyzing: /Users/janosh/Desktop/t.py (148ms)
Background analysis message: resumeAnalysis
[FG] parsing: /Users/janosh/Desktop/t.py (68ms)
[FG] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/builtins.pyi [fs read 2ms] (73ms)
[FG] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/builtins.pyi (30ms)
[FG] binding: /Users/janosh/Desktop/t.py (0ms)
[FG] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing.pyi [fs read 2ms] (27ms)
[FG] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing.pyi (9ms)
[FG] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/_typeshed/init.pyi [fs read 1ms] (6ms)
[FG] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/_typeshed/init.pyi (1ms)
[FG] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing_extensions.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing_extensions.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/init.pyi [fs read 0ms] (16ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/init.pyi (1ms)
Background analysis message: getDiagnosticsForRange
Background analysis message: getDiagnosticsForRange
Background analysis message: setFileOpened
Background analysis message: markFilesDirty
[FG] completion at /Users/janosh/Desktop/t.py:3:7 ...
[FG] parsing: /Users/janosh/Desktop/t.py (0ms)
[FG] binding: /Users/janosh/Desktop/t.py (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_config/init.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_config/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_config/config.pyi [fs read 0ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_config/config.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/api.pyi [fs read 0ms] (45ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/api.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/boolean.pyi [fs read 0ms] (10ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/boolean.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/init.pyi [fs read 0ms] (9ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/categorical.pyi [fs read 1ms] (13ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/categorical.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/dtypes/dtypes.pyi [fs read 0ms] (7ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/dtypes/dtypes.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/api.pyi [fs read 0ms] (5ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/api.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/category.pyi [fs read 0ms] (4ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/category.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/frame.pyi [fs read 0ms] (19ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/frame.pyi (8ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/offsets.pyi [fs read 0ms] (7ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/offsets.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/datetimes.pyi [fs read 1ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/datetimes.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/numeric.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/numeric.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/groupby/init.pyi [fs read 0ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/groupby/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/groupby/grouper.pyi [fs read 0ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/groupby/grouper.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/base.pyi [fs read 0ms] (7ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/base.pyi (5ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexing.pyi [fs read 0ms] (4ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexing.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/integer.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/integer.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/interval.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/interval.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/interval.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/interval.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/multi.pyi [fs read 0ms] (5ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/multi.pyi (3ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/libs/missing.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/libs/missing.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/groupby/generic.pyi [fs read 0ms] (5ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/groupby/generic.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/period.pyi [fs read 1ms] (4ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/period.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/range.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/range.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/series.pyi [fs read 0ms] (9ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/series.pyi (3ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/string.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/string.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/init.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/init.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/tslibs/init.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/tslibs/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/tslibs/timedeltas.pyi [fs read 0ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/tslibs/timedeltas.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/timedeltas.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/indexes/timedeltas.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/tslibs/timestamps.pyi [fs read 0ms] (4ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/_libs/tslibs/timestamps.pyi (4ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/construction.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/construction.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/algorithms.pyi [fs read 0ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/algorithms.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/dtypes/missing.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/dtypes/missing.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/formats/format.pyi [fs read 1ms] (16ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/formats/format.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/tools/datetimes.pyi [fs read 1ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/tools/datetimes.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/tools/numeric.pyi [fs read 1ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/tools/numeric.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/tools/timedeltas.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/tools/timedeltas.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/sparse/init.pyi [fs read 0ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/sparse/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/sparse/dtype.pyi [fs read 1ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/arrays/sparse/dtype.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/computation/api.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/computation/api.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/computation/eval.pyi [fs read 1ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/computation/eval.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/api.pyi [fs read 0ms] (6ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/api.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/concat.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/concat.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/pivot.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/pivot.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/tile.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/tile.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/reshape.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/reshape.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/melt.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/melt.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/merge.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/core/reshape/merge.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/api.pyi [fs read 0ms] (18ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/api.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/excel/init.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/excel/init.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/excel/_base.pyi [fs read 0ms] (5ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/excel/_base.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/pytables.pyi [fs read 0ms] (9ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/pytables.pyi (5ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/clipboards.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/clipboards.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/parsers/init.py [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/parsers/init.py (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/parsers/readers.py [fs read 0ms] (38ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/parsers/readers.py (9ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/feather_format.pyi [fs read 1ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/feather_format.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/gbq.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/gbq.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/html.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/html.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/json/init.pyi [fs read 0ms] (4ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/json/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/json/_json.pyi [fs read 0ms] (6ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/json/_json.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/orc.pyi [fs read 1ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/orc.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/parquet.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/parquet.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/pickle.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/pickle.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/sas/init.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/sas/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/sas/sasreader.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/sas/sasreader.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/spss.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/spss.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/sql.pyi [fs read 0ms] (5ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/sql.pyi (4ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/stata.pyi [fs read 1ms] (3ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/stata.pyi (2ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/init.pyi [fs read 0ms] (0ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/init.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/api.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/api.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/frequencies.pyi [fs read 0ms] (2ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/tseries/frequencies.pyi (1ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/util/_print_versions.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/util/_print_versions.pyi (0ms)
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/util/_tester.pyi [fs read 0ms] (1ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/util/_tester.pyi (0ms)
[FG] completion at /Users/janosh/Desktop/t.py:3:7 [found 1 items] (443ms)
IntelliCode: current invocation did not produce any meaningful tokens.
Time taken to get recommendations: 2 ms, Memory increase: 114 KB.
Background analysis message: analyze
[BG(1)] analyzing: /Users/janosh/Desktop/t.py ...
[BG(1)] parsing: /Users/janosh/Desktop/t.py (0ms)
[BG(1)] binding: /Users/janosh/Desktop/t.py (0ms)
[BG(1)] checking: /Users/janosh/Desktop/t.py ...
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/_typeshed/init.pyi [fs read 1ms] (11ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/_typeshed/init.pyi (1ms)
[BG(1)] parsing: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing_extensions.pyi [fs read 0ms] (5ms)
[BG(1)] binding: /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/typeshed-fallback/stdlib/typing_extensions.pyi (1ms)
[BG(1)] checking: /Users/janosh/Desktop/t.py (25ms)
[BG(1)] analyzing: /Users/janosh/Desktop/t.py (25ms)
Background analysis message: getDiagnosticsForRange
Background analysis message: getSemanticTokens delta
[BG(1)] getSemanticTokens delta previousResultId:1630480915612 at /Users/janosh/Desktop/t.py (0ms)
Background analysis message: resumeAnalysis
Background analysis message: getDiagnosticsForRange
[FG] parsing: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/json/_json.py [fs read 0ms] (17ms)
[FG] binding: /Users/janosh/.venv/py39/lib/python3.9/site-packages/pandas/io/json/_json.py (6ms)

[jakebailey]

Hm, these logs imply that our pandas stubs are not being used at all, which doesn't make sense.

Can you go check what's in /Users/janosh/.vscode/extensions/ms-python.vscode-pylance-2021.8.3/dist/bundled/stubs? You should see a pandas folder there. If not, perhaps your extension install is corrupted in some way.

[janosh]

Ah, in that case it's probably because the Pylance Pandas stubs are suppressed by the ones I installed myself to use with mypy.

$ pip freeze | grep pandas
pandas==1.3.1
pandas-stubs==1.2.0.1

$ pip show pandas-stubs
Name: pandas-stubs
Version: 1.2.0.1
Summary: Type annotations for Pandas
Home-page: https://github.com/VirtusLab/pandas-stubs
Author: Zbigniew Królikowski
Author-email: zkrolikowski@virtuslab.com
License: MIT
Location: /Users/janosh/.venv/py39/lib/python3.9/site-packages
Requires:
Required-by:

Will raise an issue about the missing json_normalize there. Is it possible to use the Pylance stubs with mypy? I've seen this repo https://github.com/microsoft/python-type-stubs which says it publishes its stubs to https://github.com/python/typeshed but I'm getting

pip install types-pandas
ERROR: No matching distribution found for types-pandas

[jakebailey]

That repo doesn't publish to typeshed, it's a staging ground for WIP or lower quality stubs which are shipped with Pylance, but have yet to be put into typeshed or upstreamed. They also aren't published to PyPI (but you can copy them into your typings for modification).

Pandas is a huge library, and it's unlikely typeshed would ever accept it. The pandas project had intended to integrate our stubs into their code, so that we can eliminate the stubs.

I wasn't aware of https://github.com/VirtusLab/pandas-stubs; it seems to have been created after we started working on ours. @gramster You might be interested in taking a look.

[bdrum]

@jakebailey Hi! Thanks for your help. Perhaps not the same issue, but not sure that it worth to create a new issue.
The similar problem with pylance for pandas.arrays:

[jakebailey]

I'm not aware of anything in pandas called arrays; array (singular) works when I test.

[judej]

Closing old issue. If this is still a problem, please reopen with the information requested. thanks

[janosh]

I agree with closing. Just one more question for @jakebailey: Is pandas still planning to integrate the pylance stubs into their code?

[jakebailey]

Last I knew, yes, but I'm not currently working on Python anymore, so I can't really say anything with confidence having not been a part of those discussions in half a year.

[debonte]

@gramster