How to dynamically remove formatting information from pandas dataframe?
Sometimes you have to deal with Excel Files that have been automatically generated by a Third Party system. These files may contain some formatting information, which is either irrelevant or may even distort your calculation. This formatting information needs to be removed. In this video I ll show you a way to flexibly only return all relevant rows before the formatting starts using pandas iloc, str.contains and idxmax functions.