rexpert / tng_statement_in_csv Goto Github PK

The current ReadMe is quite complicated, there are various ways to install the dependencies. The ReadMe involves some instructions to build a Virtual Environment with venv, but also some instructions involving Conda setup.

As a Python beginner user, it is better if

1. I can easily install the environment without any hassle
2. I can focus on the virtual environment that I am familiar with instead of using multiple virtual environments.

Expectation:

1. Build a requirements.txt that includes all necessary packages, and write some introductions about how to use it.
2. Rearrange the ReadMe's installation section and add introductions about how to create, activate and deactivate the conda environment.

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?

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 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.