How to Extract Tables from PDF using Python

Support me on Patreon to access all the source code for my tutorials and join a private community of Python Programmers:

In this tutorial we will discuss how to extract table from PDF files using Python.

⭐️ Timeline
0:00 - Introduction
1:41 - Sample PDF files
2:49 - Extract single table from PDF file
8:48 - Extract multiple tables from PDF file
11:36 - Extract all tables from PDF file
13:30 - Conclusion

📄 Resources

🔗 My Social Media

🎬 My YouTube Equipment

💸 Donations

--------------------------------------------------------------------------------------------------------------
⭐️ Tags
- Extract Table from PDF
- Tabula

[paulsmithson]

Wow, fantastic tutorial! I work as an accountant, and Linda from HR, who, and this is between us, is thick as a brick, keeps sending us the payroll tables as PDFs. As an accountant, I need my tables in the Excel software so that I can generate the macros for the supervisors' meetings on every second Thursdays. Thanks to your brilliant, amazing tutorial, what used to take 4 hours (not counting lunch time) now takes 15 minutes tops! I have been able to use my remaining 3h45 minutes to clean-up my Desktop folders, entertain myself to some sudoku, and n0sc0pe h8ters on the LoL game. Thank you again Mr. Sv, very much appreciated!

[davidpalomeque]

Super clever tutorial Misha, in 10 minutes you gave me what I was looking for. Keep up the good work!

[chethanchintumj]

Thanks a lot for all your efforts to makes understand the pdf table extraction. 😇🥰 I'm now able to fetch tables from un structure format pdfs. Once again thanks a lot

[marcobaquero]

thank you Misha...Very clear and useful your video!! TKS!!

[DwaraknathKeerthi]

Well explainted in the short time, thanks, Misha!

[gregNFL]

I’m familiar with the Tabula Windows app (which works pretty well) but this is next level. Thank you so much!

[RC-qllp]

Very concise but detailed explanation even for new Python user like me. Also the video is very easy to follow, and is organized logically. Very valuable 14 minutes I spent watching this. Thank You.

[carloschire]

Thanks a lot, it helps so much, greetings from Peru

[gregorydunks]

Hi I have one big table that carries on through each page but each page is technically it’s own table with new headers so is there anyway to append all of these tables in one file and remove the headers so that it becomes one long csv file with only one set of headers

[GururajSapkal]

In above video, the table data extracted from pdf as list, what to do in order to convert this list type data into Dataframe?

[saviodemirandapereira]

Hey, how can i solve this?
No JVM shared library file (jvm.dll) found. Try setting up the JAVA_HOME environment variable properly.

[jayzeen]

Helloo. Great tutorial. A quick question. If i wanted to use this on my application and host it, will it still work after hosting too

[yo]

After- print(len(dfs)) I got "SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated escape"
could you tell me what's the problem?
Solved it 1: Just put `r` before your normal string. It converts a normal string to a raw string:

[mariamalmutairi]

Thank you that's very helpful, i just have a question what if I have the same table repeated in multiple PDFs and I need to append them to one csv file

[tanmaychaturvedi]

The thing is whether it is tabula Or camelot they don't read all the tables, I want to extract tables from research papers but my rag pipeline in which I have used tabula Or camelot for doing it fails in covering all the cases, so do we have any other solution.

[bushramodi]

Code is running without any error but still not getting teh excel file. Can you help please?

[defypark]

JVMNotFoundException: No JVM shared library file (libjli.dylib) found. Try setting up the JAVA_HOME environment variable properly. It's my error. Any can help please? I've downloaded Java and installed tabula and tabula-py.

[Rockleev]

CalledProcessError: Command '['java', '-Dfile.encoding=UTF8', '-jar' returned non-zero exit status 1.
I'm getting the above error, even after installing latest version JVM, any help would be very much appreciated

[meixinyap]

Hi, your work is fantastic and I am amazed at that! But just wondering would Python can do if I need to extract specific tables that are located on different pages for different files?

I have more than 200 pdf files, each pdf has a different amount of pages, some have only 5 but some have 10. I need the table with the word “statement total” so that I can extract the data under “quantity” & “amount” in each of the tables.

Currently, my workflow is that (open pdf - scroll to the page that has statement total - search for a page with statement total - look for the amount under "quantity" & "Amount" - copy and paste into my excel - then close the pdf file.

Hope to seek some advice from you, thanks

[approvedtrash]

finally a tutorial where i can finally get a kitchen table out of my computer...










wait did i miss something...