Camelot: PDF Table Extraction for Humans

Camelot is a Python library that makes it easy for anyone to extract tables from PDF files!

Here's how you can extract tables from PDF files. Check out the PDF used in this example here.

>>> import camelot
>>> tables = camelot.read_pdf('foo.pdf')
>>> tables
<TableList n=1>
>>> tables.export('foo.csv', f='csv', compress=True) # json, excel, html
>>> tables[0]
<Table shape=(7, 7)>
>>> tables[0].parsing_report
{
    'accuracy': 99.02,
    'whitespace': 12.24,
    'order': 1,
    'page': 1
}
>>> tables[0].to_csv('foo.csv') # to_json, to_excel, to_html
>>> tables[0].df # get a pandas DataFrame!

Cycle Name	KI (1/km)	Distance (mi)	Percent Fuel Savings
			Improved Speed	Decreased Accel	Eliminate Stops	Decreased Idle
2012_2	3.30	1.3	5.9%	9.5%	29.2%	17.4%
2145_1	0.68	11.2	2.4%	0.1%	9.5%	2.7%
4234_1	0.59	58.7	8.5%	1.3%	8.5%	3.3%
2032_2	0.17	57.8	21.7%	0.3%	2.7%	1.2%
4171_1	0.07	173.9	58.1%	1.6%	2.1%	0.5%

There's a command-line interface too!

Note: Camelot only works with text-based PDFs and not scanned documents. (As Tabula explains, "If you can click and drag to select text in your table in a PDF viewer, then your PDF is text-based".)

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.

Installation

After installing the dependencies (tk and ghostscript), you can simply use pip to install Camelot:

$ pip install camelot-py[all]

Alternatively

After installing the dependencies, clone the repo using:

$ git clone https://www.github.com/socialcopsdev/camelot

and install Camelot using pip:

$ cd camelot
$ pip install ".[all]"

Note: Use a virtualenv if you don't want to affect your global Python installation.

Documentation

Great documentation is available at http://camelot-py.readthedocs.io/.

Development

The Contributor's Guide has detailed information about contributing code, documentation, tests and more. We've included some basic information in this README.

Source code

You can check the latest sources with:

$ git clone https://www.github.com/socialcopsdev/camelot

Setting up a development environment

You can install the development dependencies easily, using pip:

$ pip install camelot-py[dev]

Testing

After installation, you can run tests using:

$ python setup.py test

Versioning

Camelot uses Semantic Versioning. For the available versions, see the tags on this repository. For the changelog, you can check out HISTORY.md.

License

This project is licensed under the MIT License, see the LICENSE file for details.

Release files for camelot-py 0.2.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for camelot-py 0.2.2
File	Size	Uploaded
camelot-py-0.2.2.tar.gz	25.0 kB	Oct 7, 2018	Details

Built distribution (wheel)

Table of built distributions (wheels) for camelot-py 0.2.2
File	Interpreter	ABI	Platform	Reset
camelot_py-0.2.2-py2.py3-none-any.whl 30.5 kB Oct 7, 2018	Python 2, Python 3	none	any	Details

Total release size: 55.5 kB

Release files / camelot-py-0.2.2.tar.gz

Download URL	camelot-py-0.2.2.tar.gz
Size	25.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`c5c341310c7271502de65c68a0eddd11bb4f2e55f528f76f3af31930bfcc6e7d`
BLAKE2b-256 checksum How to use checksums	`3f58c484401792eb5a3807337aa4f1f43a2a023fa97c8de7376b6b5ba45e3e9f`
Upload date	Oct 7, 2018
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.12.1 pkginfo/1.4.2 requests/2.19.1 setuptools/40.4.3 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.5`

Release files / camelot_py-0.2.2-py2.py3-none-any.whl

Download URL	camelot_py-0.2.2-py2.py3-none-any.whl
Size	30.5 kB
Tags	Python 2 Python 3
SHA-256 checksum How to use checksums	`6d8506363eade1fefce4f67e7c1c544b2fbecdb72a758b7109c7ddf3f69b9437`
BLAKE2b-256 checksum How to use checksums	`1416b163dffdb5a3b5e60bbaba6c6d2d52c0c69b3c5b7cebd7f07894d0e9f335`
Upload date	Oct 7, 2018
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.12.1 pkginfo/1.4.2 requests/2.19.1 setuptools/40.4.3 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.5`