Transaction Network 2: Extract a PDF Ledger and Enrich Its Rows

The challenge

Turn this PDF ledger into a searchable table. Use the CSV or JSON to check your work, then add the extra fields that the PDF doesn't show.

Start here

Open the SharePoint folder linked above. transactions.pdf is a 1,039-page text PDF. transactions.csv and transactions.json contain 47,193 reference records. Inspect pages near the beginning, middle, and end before settling on a parser. The PDF columns are Tx ID, Timestamp, From, To, Amount, Type, and Flags.

Try it

1. Extract the seven visible ledger fields and retain source-page source details.

2. Detect missing or duplicate output rows by comparing the ID sets, rather than assuming a continuous ID sequence.

3. Enrich the PDF rows with CSV-only fields and report their source details.

4. Calculate type counts and currency-separated totals, and explain what is missing for a supervised fraud task.

What to build

Build a PDF-derived ledger, a separately identified enriched version, an extraction-error report, and the requested summaries. Do not fill absent PDF fields with guesses.