Adding rows above dataframe

Hello all,

In the company we use Adobe Analytics. It has certain format of tables to import, specifically: it requires double headers and also comment line above the dataset (see sample).

sample.txt

(420 Bytes)

I processed the data to upload (from line 4 and data goes down), line 3 is actually headers of last output table in workflow.

Now I’m scratching my head how to add line 1 and 2 above this table and store the file.

concatenate doesn’t work: I tried to split workflow into to streams - 1st with line 1 and 2, 2nd with the table with data. Since headers doesn’t match, I can’t jus append table under

this 1st line which is just in cell [0][0] impact the logic, so I can’t add it as header to the table with data.

If the Python is the only option, will go to try to write the code, but I’m yet quite weak in Python, so failed to design quickly.

Would appreciate advices what else I can try