Stack Overflow
Stack Overflow

Questions tagged [python-camelot]

Camelot is a Python library that makes it easy for anyone to extract tabular data from PDF files.

image

Official web site

Camelot is a Python library that makes it easy for anyone to extract tabular data from PDF files.

Why Camelot?

  • You are in control. Unlike other libraries and tools which either give a nice output or fail miserably (with no in-between), Camelot gives you the power to tweak table extraction. (This is important since everything in the real world, including PDF table extraction, is fuzzy.)
  • Bad tables can be discarded based on metrics like accuracy and whitespace, without ever having to manually look at each table.
  • Each table is a pandas DataFrame, which seamlessly integrates into ETL and data analysis workflows.
  • Export to multiple formats, including JSON, Excel and HTML.

See comparison with other PDF table extraction libraries and tools.

197 questions
0
votes
3 answers

Problem extracting tabular data from a pdf

I'm trying to extract table from a pdf that had a lot of name of media sources. The desired output is a comprehensive csv file with a column with all the sources listed. I'm trying to write a simple python script to extract table data from a pdf.…
signorz
  • 1
  • 2
0
votes
0 answers

concurrent.futures.as_completed(...) left hanging after jobs have been submitted to ProcessPoolExecutor

My code is similar to the example below. jobs1 and jobs2 would be calls do different functions: one is camelot-py::read_pdf and another is a call to a library that makes a (blocking) request. from concurrent import futures import time n =200 t0 =…
mesquita
  • 1
  • 1
0
votes
1 answer

Trying to Avoid Using Two Package Managers (pip and Poetry) for the Same Project

After a fair bit of thrashing, I successfully installed the Python Camelot PDF table extraction tool (https://pypi.org/project/camelot-py/) and it works for the intended purpose. But in order to get it to work, aside from having to correct a…
robcat26
  • 3
  • 1
0
votes
1 answer

How do I capture the full dimensions of a pdf table and convert it using Camelot in Python?

pdf linkI have been trying to use the Camelot library and trying to capture a table (that isn't really formatted as a table) by setting the flavor parameter to 'stream'. However, it is not detecting the entire table. So what I decided to do is try…
Jagwire
  • 1
  • 1
0
votes
0 answers

Substituting variables in a Camelot equation

I am using Camelot to parse tables that are not exactly identical across pages. I have used the "lattice" function to get the table regions for each page and want to substitute those into the function used by Camelot. The equation is: tables =…
Neil
  • 3
  • 2
0
votes
0 answers

Lattice option not working for column header in tabula-py

I am using tabula-py for extracting table from pdf. Where I am using lattice for parsing the file. It is doing good for all rows except the first one. code: df = read_pdf("filename.pdf", pages=21, multiple_tables=True, lattice=True) Table in…
Pruthvi Batta
  • 1
  • 2
0
votes
0 answers

How to extract specific table from word or PDF using python

I am working on a project where I have about a thousand word files or PDFs. In these documents there's a specific table I want to extract. In the heading or the text of the document I should have the word results and I want to extract the table…
Romh
  • 1
0
votes
1 answer

data extraction using camelot

I am encountering ghostscript error : fatal while extracting data from a pdf using camelot in jupyter notebook. import camelot.io as cam tables = cam.read_pdf("monotogomry 6th edtn.pdf", pages ='81')
Xcorpion Xyed
  • 11
  • 3
0
votes
0 answers

Unable to install Camelot - receiving errors or won't stop loading

I have been trying to install camelot onto my computer to use via VS Code. I have tkinter and ghostscript installed, but I'm unable to install camelot. I accidentally ran !pip install camelot, so I'm unable to use read_pdf since it isn't the correct…
user20275872
  • 13
  • 3
0
votes
1 answer

Unable to extract tables from tabula or Camelot

Tried to extract the below table using Tabula, but it was returning null dataframe. It was working fine for other kinds of similar tables. Tried using Camelot as well but it didn't work as well. Any suggestions about how can I extract…
Pravin
  • 241
  • 2
  • 14
0
votes
0 answers

Camelot ghostscript issue

I am using camelot for pdf table extraction using the below code: tables=camelot.read_pdf("abc.pdf",pages='all',flavor='stream') in my system using virtual environment. But in case of others system that virtual environment throwing error for…
Rishav Banerjee
  • 23
  • 3
0
votes
0 answers

can't read pdf files by using camelot

import camelot from google.colab import files uploaded = files.upload() file = "foo.pdf" tables = camelot.read_pdf(file) print("Total tables extracted:", tables.n) tables = camelot.read_pdf(file) print("Total tables extracted:",…
Vasavi Sreerama
  • 1
  • 1
0
votes
1 answer

How to extract multi table from pdf with their page number by using camelot?

I have one pdf file, it has 40 tables in different pages. I want to extract each table with its page number. I have tried to use this code: import camelot tables = camelot.read_pdf('2003.pdf', flavor='stream', pages='8,9,10,14,15,18,24...',…
abdullah Haidari
  • 1
0
votes
1 answer

Python - Extract data inside a Rectangle Box from a PDF file to CSV file

I want to extract data present inside a rectangle box in a PDF file to a CSV file with corresponding columns and rows. I tried using Camelot, PyPdf2, Tabula libraries etc, but I couldn't get the desired outcome in a CSV file. Could anyone help me…
Mech_Saran
  • 157
  • 1
  • 2
  • 9
0
votes
1 answer

Camelot-py - Changing the matplotlib figure size on the camelot.plot method

When running camelot-py method camelot.plot() to plot grid lines of the pdf, the output is too small to read. tables = camelot.read_pdf(pdf_path, pages='165', flavor='stream', flag_size=True, table_areas=['65, 760, 600,…
Drew Sanislo
  • 77
  • 6
1 2 3
…
13 14