When importing camelot AttributeError: partially initialized module 'pandas' has no attribute '_pandas_parser_CAPI'

[AnOdyssey]

When I'm importing camelot in a jupyter notebook I'm getting the following error:

AttributeError: partially initialized module 'pandas' has no attribute '_pandas_parser_CAPI' (most likely due to a circular import)

Full stacktrace

---

AttributeError Traceback (most recent call last)
Cell In[27], line 1
----> 1 import camelot

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\camelot_init_.py:6
3 import logging
5 from .version import version
----> 6 from .io import read_pdf
7 from .plotting import PlotMethods
10 # set up logging

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\camelot\io.py:5
1 # -- coding: utf-8 --
3 import warnings
----> 5 from .handlers import PDFHandler
6 from .utils import validate_input, remove_extra
9 def read_pdf(
10 filepath,
11 pages="1",
(...)
16 **kwargs
17 ):

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\camelot\handlers.py:8
4 import sys
6 from PyPDF2 import PdfFileReader, PdfFileWriter
----> 8 from .core import TableList
9 from .parsers import Stream, Lattice
10 from .utils import (
11 TemporaryDirectory,
12 get_page_layout,
(...)
16 download_url,
17 )

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\camelot\core.py:11
8 from operator import itemgetter
10 import numpy as np
---> 11 import pandas as pd
14 # minimum number of vertical textline intersections for a textedge
15 # to be considered valid
16 TEXTEDGE_REQUIRED_ELEMENTS = 4

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas_init_.py:151
132 from pandas.core.computation.api import eval
134 from pandas.core.reshape.api import (
135 concat,
136 lreshape,
(...)
148 qcut,
149 )
--> 151 from pandas import api, arrays, errors, io, plotting, tseries
152 from pandas import testing
153 from pandas.util._print_versions import show_versions

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas\api_init_.py:2
1 """ public toolkit API """
----> 2 from pandas.api import (
3 extensions,
4 indexers,
5 interchange,
6 types,
7 typing,
8 )
10 all = [
11 "interchange",
12 "extensions",
(...)
15 "typing",
16 ]

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas\api\typing_init_.py:31
19 from pandas.core.window import (
20 Expanding,
21 ExpandingGroupby,
(...)
26 Window,
27 )
29 # TODO: Can't import Styler without importing jinja2
30 # from pandas.io.formats.style import Styler
---> 31 from pandas.io.json._json import JsonReader
32 from pandas.io.stata import StataReader
34 all = [
35 "DataFrameGroupBy",
36 "DatetimeIndexResamplerGroupby",
(...)
54 "Window",
55 ]

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas\io\json_init_.py:1
----> 1 from pandas.io.json._json import (
2 read_json,
3 to_json,
4 ujson_dumps,
5 ujson_loads,
6 )
7 from pandas.io.json._table_schema import build_table_schema
9 all = [
10 "ujson_dumps",
11 "ujson_loads",
(...)
14 "build_table_schema",
15 ]

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas\io\json_json.py:71
66 from pandas.io.json._normalize import convert_to_line_delimits
67 from pandas.io.json._table_schema import (
68 build_table_schema,
69 parse_table_schema,
70 )
---> 71 from pandas.io.parsers.readers import validate_integer
73 if TYPE_CHECKING:
74 from collections.abc import (
75 Hashable,
76 Mapping,
77 )

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas\io\parsers_init_.py:1
----> 1 from pandas.io.parsers.readers import (
2 TextFileReader,
3 TextParser,
4 read_csv,
5 read_fwf,
6 read_table,
7 )
9 all = ["TextFileReader", "TextParser", "read_csv", "read_fwf", "read_table"]

File C:\projects\Redacted\Redacted\RedactedPoc.venv\Lib\site-packages\pandas\io\parsers\readers.py:32
29 from pandas._config import using_copy_on_write
31 from pandas._libs import lib
---> 32 from pandas._libs.parsers import STR_NA_VALUES
33 from pandas.errors import (
34 AbstractMethodError,
35 ParserWarning,
36 )
37 from pandas.util._decorators import Appender

File parsers.pyx:1418, in init pandas._libs.parsers()

pip list

Package Version
anyio 4.6.2.post1
argon2-cffi 23.1.0
argon2-cffi-bindings 21.2.0
arrow 1.3.0
asttokens 2.4.1
async-lru 2.0.4
attrs 24.2.0
babel 2.16.0
beautifulsoup4 4.12.3
bleach 6.1.0
camelot-py 0.9.0
certifi 2024.8.30
cffi 1.17.1
chardet 5.2.0
charset-normalizer 3.4.0
click 8.1.7
colorama 0.4.6
comm 0.2.2
cryptography 43.0.1
debugpy 1.8.7
decorator 5.1.1
defusedxml 0.7.1
et-xmlfile 1.1.0
executing 2.1.0
fastjsonschema 2.20.0
fqdn 1.5.1
h11 0.14.0
httpcore 1.0.6
httpx 0.27.2
idna 3.10
ipykernel 6.29.5
ipython 8.28.0
isoduration 20.11.0
jedi 0.19.1
Jinja2 3.1.4
json5 0.9.25
jsonpointer 3.0.0
jsonschema 4.23.0
jsonschema-specifications 2024.10.1
jupyter_client 8.6.3
jupyter_core 5.7.2
jupyter-events 0.10.0
jupyter-lsp 2.2.5
jupyter_server 2.14.2
jupyter_server_terminals 0.5.3
jupyterlab 4.2.5
jupyterlab_pygments 0.3.0
jupyterlab_server 2.27.3
MarkupSafe 3.0.1
matplotlib-inline 0.1.7
mistune 3.0.2
nbclient 0.10.0
nbconvert 7.16.4
nbformat 5.10.4
nest-asyncio 1.6.0
notebook 7.2.2
notebook_shim 0.2.4
numpy 2.1.2
opencv-python 4.10.0.84
openpyxl 3.1.5
overrides 7.7.0
packaging 24.1
pandas 2.2.3
pandocfilters 1.5.1
parso 0.8.4
pdfminer.six 20240706
pip 23.2.1
platformdirs 4.3.6
prometheus_client 0.21.0
prompt_toolkit 3.0.48
psutil 6.0.0
pure_eval 0.2.3
pycparser 2.22
Pygments 2.18.0
PyMuPDF 1.24.11
pymupdf4llm 0.0.17
pypdf 5.0.1
PyPDF2 3.0.1
python-dateutil 2.9.0.post0
python-json-logger 2.0.7
pytz 2024.2
pywin32 308
pywinpty 2.0.13
PyYAML 6.0.2
pyzmq 26.2.0
referencing 0.35.1
requests 2.32.3
rfc3339-validator 0.1.4
rfc3986-validator 0.1.1
rpds-py 0.20.0
Send2Trash 1.8.3
setuptools 68.2.0
six 1.16.0
sniffio 1.3.1
soupsieve 2.6
stack-data 0.6.3
tabulate 0.9.0
terminado 0.18.1
tinycss2 1.3.0
tornado 6.4.1
traitlets 5.14.3
types-python-dateutil 2.9.0.20241003
typing_extensions 4.12.2
tzdata 2024.2
uri-template 1.3.0
urllib3 2.2.3
wcwidth 0.2.13
webcolors 24.8.0
webencodings 0.5.1
websocket-client 1.8.0
wheel 0.41.2