Pandas excel subheadings

Question

I have subheadings in my excel file and I need to replace for example a2= rt b2= final concentration.
I need to move b2 to a2 and get rid of a2.

Answer 1

You can remove rows (or columns) from a pandas dataframe with the drop() method.

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.drop.html