pip install camelot-py[base] does not work properly on python@3.10 and python@3.11

[cebor]

On python@3.10 and python@3.11 pip install camelot-py[base] only installs camelot-py==0.9.0, which is a problem because it does not handle PyPDF2==3.0.1. Also the [base] is not provided by 0.9.0.

Logs pip install on python@3.11:

$ pip install "camelot-py[base]"
Collecting camelot-py[base]
  Using cached camelot_py-0.11.0-py3-none-any.whl (40 kB)
Collecting chardet>=3.0.4
  Using cached chardet-5.1.0-py3-none-any.whl (199 kB)
Collecting click>=6.7
  Using cached click-8.1.3-py3-none-any.whl (96 kB)
Collecting numpy>=1.13.3
  Using cached numpy-1.24.3-cp311-cp311-macosx_10_9_x86_64.whl (19.8 MB)
Collecting openpyxl>=2.5.8
  Using cached openpyxl-3.1.2-py2.py3-none-any.whl (249 kB)
Collecting pandas>=0.23.4
  Using cached pandas-2.0.1-cp311-cp311-macosx_10_9_x86_64.whl (11.6 MB)
Collecting pdfminer.six>=20200726
  Using cached pdfminer.six-20221105-py3-none-any.whl (5.6 MB)
Collecting pypdf>=3.0.0
  Using cached pypdf-3.8.1-py3-none-any.whl (248 kB)
Collecting tabulate>=0.8.9
  Using cached tabulate-0.9.0-py3-none-any.whl (35 kB)
Collecting ghostscript>=0.7
  Using cached ghostscript-0.7-py2.py3-none-any.whl (25 kB)
Collecting opencv-python>=3.4.2.17
  Using cached opencv_python-4.7.0.72-cp37-abi3-macosx_10_16_x86_64.whl (53.9 MB)
Collecting camelot-py[base]
  Using cached camelot_py-0.10.1-py3-none-any.whl (40 kB)
Collecting PyPDF2>=1.26.0
  Using cached pypdf2-3.0.1-py3-none-any.whl (232 kB)
Collecting camelot-py[base]
  Using cached camelot_py-0.10.0-py3-none-any.whl (40 kB)
  Using cached camelot_py-0.9.0-py3-none-any.whl (43 kB)
WARNING: camelot-py 0.9.0 does not provide the extra 'base'
Collecting et-xmlfile
  Using cached et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)
Collecting python-dateutil>=2.8.2
  Using cached python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
Collecting pytz>=2020.1
  Using cached pytz-2023.3-py2.py3-none-any.whl (502 kB)
Collecting tzdata>=2022.1
  Using cached tzdata-2023.3-py2.py3-none-any.whl (341 kB)
Collecting charset-normalizer>=2.0.0
  Using cached charset_normalizer-3.1.0-cp311-cp311-macosx_10_9_x86_64.whl (123 kB)
Collecting cryptography>=36.0.0
  Using cached cryptography-40.0.2-cp36-abi3-macosx_10_12_x86_64.whl (2.8 MB)
Collecting cffi>=1.12
  Using cached cffi-1.15.1-cp311-cp311-macosx_10_9_x86_64.whl (179 kB)
Collecting six>=1.5
  Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting pycparser
  Using cached pycparser-2.21-py2.py3-none-any.whl (118 kB)
Installing collected packages: pytz, tzdata, six, PyPDF2, pycparser, numpy, et-xmlfile, click, charset-normalizer, chardet, python-dateutil, openpyxl, cffi, pandas, cryptography, pdfminer.six, camelot-py
Successfully installed PyPDF2-3.0.1 camelot-py-0.9.0 cffi-1.15.1 chardet-5.1.0 charset-normalizer-3.1.0 click-8.1.3 cryptography-40.0.2 et-xmlfile-1.1.0 numpy-1.24.3 openpyxl-3.1.2 pandas-2.0.1 pdfminer.six-20221105 pycparser-2.21 python-dateutil-2.8.2 pytz-2023.3 six-1.16.0 tzdata-2023.3

Results to:

camelot-py==0.9.0
cffi==1.15.1
chardet==5.1.0
charset-normalizer==3.1.0
click==8.1.3
cryptography==40.0.2
et-xmlfile==1.1.0
numpy==1.24.3
openpyxl==3.1.2
pandas==2.0.1
pdfminer.six==20221105
pycparser==2.21
PyPDF2==3.0.1
python-dateutil==2.8.2
pytz==2023.3
six==1.16.0
tzdata==2023.3

Workaround is:

pip install "camelot-py[cv]"
pip install -U "PyPDF2<3.0"

[foarsitter]

For the time being you can install camelot-fork, we need to sort some things out before we can proceed over here

[lipsa7]

@foarsitter Hi, can you please help me out with this error?
When I'm trying to run tables.export('foo.xlsx', f='excel'), I'm getting the below error:
TypeError: NDFrame.to_excel() got an unexpected keyword argument 'encoding'

Can you please help with this?

[foarsitter]

Sounds like #373 @lipsa7

[foarsitter]

See #394 for details.