My program processes the output of an OCR scan of a table and generates a dataframe. However, sometimes the rows get merged, resulting in compressed cells that include content intended for the cell below, thus shortening the column. I need to change this content from A to B.
edit: I forgot to mention that I already have a function that can detect merged cells. What I need help with is how to split these cells and adjust the dataframe accordingly.
| A | B |
|---|---|
| a | a |
| b c | b |
| d | c |
| - | d |
I haven't been able to find a solution that allows me to shift only a specific part of the column down instead of shifting the entire column. Any assistance would be greatly appreciated!