Extract tabular data from PDF with Python - Tabula, Camelot, PyPDF2

Code

PDF example 1

PDF example 2

Survey Stack OverFlow

Survey Jetbrains

0:00: intro
1:50: Extract table from PDF with Tabula
7:48: Extract PDF tables with Camelot
9:07: pasrse PDF table - PyPDF2

---------------------------------------------------------------------------------------------------------------------------------------------------------------
Code store

Socials

If you really find this channel useful and enjoy the content, you're welcome to support me and this channel with a small donation via PayPal.

[softhints]

Tabula - 1:50
Camelot - 7:48
PyPDF2 - 9:07

[matheusrodrigues-kfpj]

thank you for showing us tabula! really helpful!

[paulmeloramos]

Buen video, les recomiendo para que no sufran con la instalación de librerias usar colab, se evitarán problemas si usan jupyter.

[Ndofi]

great one and thanks. I see tabula very pratical

[Al-Ahdal]

I used tabula and successfully read PDF, but the output is not coming in dataframe. Could you please help.

[Anonymouscrow-gm]

I have multiple tables in single pdf page.

[amiramorsli]

How I can delete the header and footer from PDF pages using the PyPDF2 library in Python. Thank you!

[vivekasthana]

Thank you for such a good explanation. :)
I am working on something similar but the tables in PDF are in image format (not in tabular), can you please suggest any blog or video from where I can get some help. Currently I am trying to work using pytesseract but it seems there are lot of dependencies I need to install and its not straight forward. Thanks

[DeepChamuah]

I have imported the 'food calories list' pdf, but unable to see it as a data frame. Type() method returns the output to be a list. Any idea?

[MrPalak]

fantastic Tutorial.
How to extract Same table spans across multiple pages?
How to differentiate that Table 1 is ended and Table 2 is started?

[umamaheswararaom]

How to extract tables from scanned image pdf, what's the best library for OCR extraction, how to label the data in such documents

[SatvikSrivastava-jsgm]

Hi tabula is crashing again and again in my jupyter notebook, the kernel appears to have died it will restart automatically, anyone else faced this problem?

[ashu]

i tried extracting table from pdf all iam getting NaN values why??

[marioustxexcel]

thank you so much. did you compare with pdftools from R?. I normally use pypdf2 but sometimes the scripts are conversome to troubleshoot for complex tables in which the layout might change within the same document.

[sourabhgadre]

JavaNotFoundError: `java` command is not found from this Python process.Please ensure Java is installed and PATH is set for `java` . Please can someone help with error occurring while i try to import pdf

[udayroyzada]

I want to extract all keys and values from finance pdf. Can you suggest what can we do to extract??

[raghvendra]

Hi. Thanks for this. Really helpful. Does it work for all the languages like tables that have say Japanese text ?

[bitchslapper]

In PyPDF2, is getPage(0) the first page or how does the numbering work?

[WoW_Chillies]

How to get the area parameters. Please guide.

[MuhammadUsman-ixjo]

How to extract table from unstructured PDF file?