Python Camelot borderless table extraction issue

13.1k Views Asked by At

I'm trying hard to extract some borderless table as show in the below image which are from pdf files. I have installed python-camelot as shown here and is working fine for bordered tables only. Please find below details:

platform - Linux-4.5.5-300.fc24.x86_64-x86_64-with-fedora-24-Twenty_Four

sys - Python 3.6.1 (default, May 15 2017, 11:42:04)[GCC 6.3.1 20161221 (Red Hat 6.3.1-1)]

numpy - NumPy 1.15.4

cv2 - OpenCV 3.4.3

camelot - Camelot 0.3.2enter image description here

3

There are 3 best solutions below

1
On BEST ANSWER

To improve the detected area, you can increase the edge_tol (default: 50) value to counter the effect of text being placed relatively far apart vertically. Larger edge_tol will lead to longer textedges being detected, leading to an improved guess of the table area. Let’s use a value of 500.

>>> tables = camelot.read_pdf('edge_tol.pdf', flavor='stream', edge_tol=500)
>>> camelot.plot(tables[0], kind='contour')
>>> plt.show()
>>> tables[0].df
0
On

Another solution that might help is setting the table_areas explicitely, e.g. to the size of the page :

# A4 portrait, MediaBox[0 0 595 842]
tables = camelot.read_pdf("filename.pdf", table_areas=["0,842,595,0"])

You can find the size of the area either throug Camelot’s visual debugging features, or by opening the PDF with a text editor and checking for MediaBox or CropBox dimensions (beware that they don’t use the same coordinates convention).

2
On

Camelot uses lattice by default which relies on clear lines dividing the cells.

For tables without lines you want to use stream:

tables = camelot.read_pdf('your_file_name.pdf', flavor = 'stream')