camelot-dev/camelot ? reverse-engineered prompt

Build me a Python library that can extract tables from PDFs and turn them into pandas DataFrames.

I want it to handle both ruled tables and whitespace based tables, with a simple default that works on most files and a few options for trickier PDFs. It should also include a small command line tool so I can point it at a PDF and export the tables to CSV, JSON, Excel, HTML, Markdown, or SQLite.

Please make it support reading from a file path, a URL, bytes, or a file like object, and give each table a basic quality report like accuracy and whitespace so noisy results can be filtered out. If you can, include support for multi page tables and an optional stronger mode for borderless or scanned PDFs, and look up current docs online if you need to. Keep it easy to install and use from just a few lines of code.