Comment

What does the PDF look like? Can you not OCR it into something like a CSV, and import it in Excel?

Sort:hotnew top

Onomatopoeia@lemmy.cafe ⁨1⁩ ⁨day⁩ ago
Word can convert PDFs, then its easy to copy the data to excel and manipulate it there

source
Suck_on_my_Presence@lemmy.world ⁨19⁩ ⁨hours⁩ ago
Okay finally managed to grab a table or two - sorry for the delay. But yeah this is what they look like and I just need to consolidate this data and format it better haha

Image

Image

source
- TheDarkQuark@lemmy.world ⁨16⁩ ⁨hours⁩ ago
  Try using an LLM.
  
  I tried to timebox myself with a Python OCR solution, but ended up spending way more time than I should’ve, without ever arriving at a good solution.
  
  I then tried using Qwen 235B via Brave’s Leo AI, and got some okay results (I think you’ll have better luck with commercial AI models; I just don’t have an account with them atm)
  
  1000010905
  
  1000010906
  
  source
Suck_on_my_Presence@lemmy.world ⁨1⁩ ⁨day⁩ ago
The PDF is a bunch of tables mostly, but it’s tables within tables. I honestly don’t think I care to try OCR into a CSV into python or anything.

I honestly loathe these documents and reading them so I’m happy to just pay for the help

source