Parse PDF Statements to SQLite
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
Python, Data Processing, Software Architecture, Database Programming, SQLite, Data Extraction, Documentation, Database Design · I have several bank statements saved as PDFs where each transaction is presented line-by-line. I need a small utility that can read those files, pull out every transaction, and insert the information into an SQLite database.
The essential fields are the date, description and amount shown on each line; if a running balance is available it would be great to capture that as well. Accurate numeric handling is critical—please strip currency symbols, recognise minus signs or debit/credit markers, and make sure amounts are stored as real numbers rather than text.
I use macOS but a cross-platform command-line solution is ideal. Python with pdfplumber / PyPDF2, pandas and the built-in sqlite3 module would suit me perfectly, though I’m open to another stack if you clearly outline the advantages.
Deliverables • Well-documented source code for the parser • SQLite schema (single table is fine) and a sample database produced from one of my PDFs • Simple run instructions so I can feed in new statements whenever I need • A brief log or report highlighting any rows that could not be parsed cleanly or looked suspicious
If you can build in light data cleaning—trimming whitespace, removing