Python Forum

Full Version: merging rows
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I want to merge/join the values of 2 rows.

Below is the original document:-
[Image: input.png]

I want:-
[Image: output.png]
This is very vague, there is no indication of how this data is stored, how you are accessing it in python and what python code you have tried so far.
Actually, I converted the PDF file containing the tables into Pandas dataframe and then Excel. Some cells in a pdf document include multiline text.
I've previously converted PDFs into Excel, but in those PDFs, the cells with multiline text had a \n at the end of the line, so I managed to make the multiline text into a single line, but in this PDF there is no \n.