I have tried tabula-py library and java tool so far but it results in many false positives ( i.e. telling that a table is present when not the case).
Some of the cases were
content 1 content 3
content 2 content 4
If text is written in the above manner, then also it marks it as tabular data. Is there any solution that does the task better and handles the above problem. ( including Deep learning or other techniques).
The Excalibur, which is built on top of camelot:
https://pypi.org/project/excalibur-py/
Best Software to Extract Tables from PDF (and export them to Excel, CSV, …)
https://docparser.com/blog/extract-tables-from-pdf/
Python for Pdf: https://medium.com/@umerfarooq_26378/python-for-pdf-ef0fac2808b0
Hi there,
To search for all the tables in a file you have to specify the parameters page = “all” and multiple_tables = True.
For example:
tables = tabula.read_pdf(file, pages = "all", multiple_tables = True)
There is also pip install camelot-py[cv]
There is also Excalibur, which is built on top of camelot.
Link:
https://pypi.org/project/excalibur-py/
Excalibur is a web interface that extracts tabular data from PDFs.
All the best.
Thanks for the answer Zakia Salod . I have tried Camelot too but no luck there too.
I raised issue for the same on GitHub and seems like they didn't target all possible table structures.
Out of the above three, I found that Tabula was the best performer. Also, there is limitation mentioned for tabula.
The drawbacks are:
- It does not work on Multi-lines rows or merged cells.
- Tabula cannot detect a scanned PDF document. it only works on text-based PDF
Ashay Singh Please use "Camelot" a python library. i have used for tabular data extraction.
Hi Dost Muhammad, thanks for the suggestion, but I already tried it. I mentioned it in the reply too.
Camelot in my case gave more false positives. I think it better extracts data in a clean format and not jumbled up ( i.e. data retains the information and row contents are not affected). But it gave more false positives of table detection.
Thanks Ali Al Bataineh
, did you meant something similar:The quality of data extracted is better in case of difference in the number of lines per cells .
But it was not as good as tabula for classifying whether a pdf had table or not.
The Excalibur, which is built on top of camelot:
https://pypi.org/project/excalibur-py/
Best Software to Extract Tables from PDF (and export them to Excel, CSV, …)
https://docparser.com/blog/extract-tables-from-pdf/
Python for Pdf: https://medium.com/@umerfarooq_26378/python-for-pdf-ef0fac2808b0
for more information please check the following document:
https://medium.com/@umerfarooq_26378/python-for-pdf-ef0fac2808b0
- Badges
- Science topic