How to Extract a Table From a PDF and Convert it to a CSV DataFrame with Tabula in Python

• Report this article

Christopher Cala

Christopher Cala

Helping ISVs Innovate, Build & Co-Sell Cloud SaaS solutions for Public Sector | Partner Account Manager, Amazon Web Services (AWS)

Published Dec 15, 2019

+ Follow

There's often lots of tabular data locked into PDF format that I'd like to be able to work on directly in a Python Pandas DataFrame.

With a couple lines of Python code and the Tabula package, you can do just that.

Here's the Link to the Google Collaboratory Notebook to play around with the code.

To view or add a comment, sign in

More articles by Christopher Cala

• Thank you for the last decade of inspiraton

  Jan 2, 2022

  Thank you for the last decade of inspiraton

  After 10 years and 11 months, today marks my last day at Air Liquide. I would like to thank everyone at Air Liquide who…

  78

  46 Comments
• Scraping the latest Covid-19 data & time-series forecasting with ARIMA and Prophet

  Mar 11, 2020

  Scraping the latest Covid-19 data & time-series forecasting with ARIMA and Prophet

  covid-19-scrape-timeseries forecasts Covid-19 statistics webscraping in Time Series Analysis with ARIMA & PROPHET…

  4
• Python code to webscrape the IMDb into a DataFrame using Requests, BeautifulSoup, & Pandas libraries. IronHack class project.

  Feb 23, 2020

  Python code to webscrape the IMDb into a DataFrame using Requests, BeautifulSoup, & Pandas libraries. IronHack class project.

  At the IronHack Paris class on 18 February with Sandeep Singh, we had fun working on Python code to scrape the…

  6
• Predicting Medical Appointment No-shows using Google Dataset Search & Python

  Feb 2, 2020

  Predicting Medical Appointment No-shows using Google Dataset Search & Python

  The Google Dataset Search allows you to find datasets to do your data wrangling and test predictive models on, such as…

  1
• Using Python & Plotly to combine & visualise two INSEE data sets on business creation & failure over two decades

  Jan 19, 2020

  Using Python & Plotly to combine & visualise two INSEE data sets on business creation & failure over two decades

  With the recent publication of INSEE data on business creation and failure, I thought it could be cool to clean and…

  2
• Paris Tweet Sentiment Analysis with Tweepy & Flair in Python

  Jan 18, 2020

  Paris Tweet Sentiment Analysis with Tweepy & Flair in Python

  With over a month of strikes in Paris over retirement reform, I was curious to see what the twitter sentiment analysis…

  4
• Fun making a self-driving robot with CamJam, Raspberry Pi & ultrasonic distance detector

  Jan 12, 2020

  Fun making a self-driving robot with CamJam, Raspberry Pi & ultrasonic distance detector

  I wanted to have a robot at home that could navigate around furniture and check up on things for me. With the CamJam…

  3
• Finding Shapes in Video Images with OpenCV in Python

  Jan 5, 2020

  Finding Shapes in Video Images with OpenCV in Python

  While on the home bike trainer working on new year resolutions, I thought it'd be cool to be able to track bike speed…

  2
• Managing URL favorites for Later Reading via Google Drive with Python

  Dec 28, 2019

  Managing URL favorites for Later Reading via Google Drive with Python

  I often find interesting articles that I'd like to save in one place to search through and read later. Existing…

  1

  2 Comments
• How to Extract Text from an Image with Pytesseract in Python

  Dec 21, 2019

  How to Extract Text from an Image with Pytesseract in Python

  After getting text and tables out of PDFs, it could also be interesting to get the text out of images, like photos…

  5

Show more

See all articles