rexpert / tng_statement_in_csv Goto Github PK

Hi Sir. I am new to github. I have installed camelot-py and pandas in CMD. My python's version is 3.11.4. After copying down you code and pasting into VSC, I changed your r'.\data\tng_ewallet_transactions.pdf' to my downloaded statement path r'C:\Users\P1357685\Downloads\tng_ewallet_transactions.pdf' and r'.\output\tng_ewallet_transactions.csv' to r'C:\Users\P1357685\Downloads\tng_ewallet_transactions.csv'. After I ran the code, import error occurred as below:

Traceback (most recent call last):
File "c:\Users\P1357685\Downloads\CSV TNG.py", line 3, in
import camelot
File "C:\Users\P1357685\AppData\Local\Programs\Python\Python311\Lib\site-packages\camelot_init_.py", line 6, in
from .io import read_pdf
File "C:\Users\P1357685\AppData\Local\Programs\Python\Python311\Lib\site-packages\camelot\io.py", line 5, in
from .handlers import PDFHandler
File "C:\Users\P1357685\AppData\Local\Programs\Python\Python311\Lib\site-packages\camelot\handlers.py", line 8, in
from .core import TableList
ImportError: cannot import name 'TableList' from 'camelot.core' (C:\Users\P1357685\AppData\Local\Programs\Python\Python311\Lib\site-packages\camelot\core_init_.py)

I appreciate your advise as I am new to this field. Looking forward to your guidances.

Hi @Rexpert, good day to you. I need your kind assistance again.

I encountered an IndexError: list index out of range when I included one particular page from the pdf in the camelot.read_pdf syntax. This particular page is the start of GO+ TRANSACTION (attached screenshot below). If I exclude this page, there wont be any errors. I think the issue is related to the column coordinate setting columns=['80,140,230,294,460,660,720']. When I remove column setting, I can read all pages of pdf without error. If I want to include column setting, I must exclude this particular page of pdf.

Is it possible the Index Error is due to the title GO+ TRANSACTION? But why the title TNG WALLET TRANSACTION at the first page does not face this issue?

Hi, Rexpert bro. I noted you have self-specified tables_areas and columns when using camelot.read_pdf(). May I check how do you determine those coordinates from the PDF?