camelot-dev / camelot-dev/excalibur

Unable to extract full table from PDF

Open
#150 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.8k
Forks
238
PR merge metrics
No merged PRs in 30d

Description

I was trying to extract table and convert it to excel from a PDF file. But full table is not extracted when using the flavor 'stream'. The full PDF table was divided into 2 table dfs(which I concated later, no problem with that) but some part of table data is not extracted. With flavor 'lattice' full table data is extracted but format is preferable with 'stream'. Can u please help to extract full table data with 'stream' itself.
In the submitted excel, sheet1 is data with flavor 'stream' and sheet2 with 'lattice'
![pdf](https://user-images.githubusercontent.com/78193389/144398026-e04cc368-4f8c-4eb9-8bb1-7a588c7860a3.png)
[pdf-excel226-11.xlsx](https://github.com/camelot-dev/excalibur/files/7640847/pdf-excel226-11.xlsx)
.

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the attached image and workbook, comparing the stream and lattice sheets to identify which table data is missing from stream extraction. Reproduce the report with the supplied PDF context if available, then verify that stream extracts the complete table while retaining its preferred formatting.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.