🔒 convert PDF to Excel

[umbral stone]

Hello I want to convert a pdf file that has tables with no borders to excel how can I do that using python.

[digital sentinel]

@umbral stone

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[grave timber]

there are a few libraries that can detect a table-like data from pdfs, then once you have a table in python, getting it to excel is easy with pandas to_excel

[umbral stone]

Thank you for your response, I have tried several ones but none of them are working correctly.

[grave timber]

try https://github.com/chezou/tabula-py maybe? I remember helping people with this long time ago but I don't remember which library wokred the best

which ones have you tried and what was your experience

[umbral stone]

I am avoiding tabula because I want it python only

[grave timber]

even if it's the python wrapper of tabula?

would https://github.com/camelot-dev/camelot work for you?

[umbral stone]

Let me give it a try

[grave timber]

quick warning, it's only works if your pdf contains actual text, can't be just an image

[umbral stone]

The idea my pdf have texts and tables, what I care about are the table extractions but sadly the tables does not have boders which is making things hard

Thats why, I have been working on it for long time, and for work purposes its a company project

[grave timber]

would you be able to share what the pdf looks like? with the sensitive info replaced with dummy text of course

I am thinking that you might be able to extract just the part of image that contains the table with something like opencv (or if the table is always in the same location, try slicing out the portion of the pdf that contains the table) and feed that into the pdf readers

[umbral stone]

I see, look I will edit the document a share with you some of it, since it has a lot of sensitive and confidential information, but my question will you be able to provide me with a functional solution?

[grave timber]

can't promise anything

I can give it a go

[umbral stone]

Okay then let me edit it and will give u a copy

[grave timber]

.

[digital sentinel]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.