tabula | Tabula is a tool for liberating data tables | Document Editor library

I am attempting to merge two cells together. The reason for this is due to the fact that every unit under 'Chassis' should be an alphanumeric (ABCD123456) however the PO provided occasionally shifts the last number to the next row (no other data on said row) making the data look like this Example I initially tried to create a statement that looked at the cell, confirmed it was less one number, then would look at the next cell, and merge the two. Never got that to even come close to manifesting any results. I then decided to replicate the data frame, shift the second data frame(so the missing number is on the same row), and merge them together. This is where I am now. Error Msg This is my first real bit of code in Python so I am fairly certain I am doing inefficient things so by all means let me know where I can improve.

Currently I have this...

End Goal is this...

I have a table with wrapped text in a pdf file

I used tabula to extract table from the pdf file

I'm writing a program to scrape through a folder of PDFs, extracting a table from each that contains the same data fields. Sample screenshot of the table in one of the PDFs:

The goal of the program is to produce a spreadsheet with all of the data from each PDF in a single row with the date of the PDF, and the common fields as the column headers. The date in the first column should be the date in the PDF filename. It should look like this:

When I extract out the data into a dataframe and add column headers for "Field" and the date of the report, it looks like this:

I would like to export tables from a PDF in a dataframe or take a csv file. But I cannot read a PDF file with Python. What do I need to do? I tried reading the PDF with Python tabula:

i try to use the tabula-module with python and have this code:

I have a Pandas DataFrame that was created by reading a table from a PDF with tabula. The PDF isn't parsed perfectly, so I end up with a few table columns smushed into one column in the resulting DataFrame. The issue is that one of the table columns in the PDF is text, so there are sometimes one word and sometimes two words that compose the column. Example:

I want to know how to extract particular table column from pdf file in python.

My code so far

Essentially, I've created a vigenere cipher. Vigenere Cipher matrix

It's a method used for coding messages. I've created the 2D array for the Vigenere cipher array. I receive a message in a form of a .txt file to be encoded. I then convert this into a regular '1D character array'. Essentially reading the text and putting every single character into a new array.

I then also get input from the user for the key, this key is then taken and repeated to match the length of the character array. So now I have a 'key array'.

How a Vingere Cipher works is that the key's first letter and the texts first letter is matched. So on the X-Axis is the 'message' and on the Y-Axis is the 'key'.

For example, if I do key: road

and message: cars

the encrypted message would be: torv,

I would get T, because I started with R on the Y-Axis and matched it to C on the X-axis.

This is how I setup my Vigenere Cipher. where 'alphabet' is this. I'm just having trouble 'matching' the characters of the two arrays (encryption key) and (message) to my Vigenere Cipher, then saving that input as an array inside a method to be used later on. Currently, I'm not too worried about capital letters and so on.

Vigenere cipher code:

Is there a way to extract data from every arrays in a pdf using python?

I've tested tabula, camelot, pdfplumber but none can extract everything or correctly.

An example:

I would like to work on these using matrix, dataframe, ...

Should I opt for OCR for better recognition ?

EDIT :

I am trying to retrieve this table from a pdf using tabula-py.

My script :