How to fill a table with pandas?

The phenomenon and background of the problem

How to use pandas modify excel form

Problem related code , Do not paste screenshots

Operation results and error reporting contents

My solution ideas and tried methods

Intended use DATAFRAME Filter out rows with null values to get the head office , I don't know how to fill the head office into the columns in front of the subsidiaries

What I want to achieve