How get PDF data to excel

I would greatly appreciate your assistance in extracting the data from the PDF into my pandas DataFrame. Additionally, could you please provide me with the complete code for retrieving data from an image to a DataFrame? Thank you in advance for your help. My PDF file is attached below.

see sampl pdf

Hi, I transformed your question into a ChatGPT prompt, and its answer is great to me. My top 2 pdf tables to dataframe Python libraries are Camelot and pdfplumber (for image-free pdf tables).

It not only created code, it also OCRed it, and ran it, and the data row is correct. It even changes the typo of ‘vecant’ to ‘vacant’. The only inconvenient there is that empty cells are not being returned, but it looks like an easy fix.

Check the ChatGPT response and code here.