delete part of a row in pandas / shift up part of a row ? Align Column Headings
<p>So I have a data frame where the headings I want do not currently line up:</p>

<pre><code>    In [1]: df = pd.read_excel('example.xlsx')
            print (df.head(10))

    Out [1]:                                 Portfolio  Asset        Country   Quantity  
         Unique Identifier Number of fund       B24     B65             B35      B44   
          456               2                General  Type A  UNITED KINGDOM        1   
          123               3                General  Type B              US        2   
          789               2                General  Type C  UNITED KINGDOM        4   
          4852              4                General  Type C  UNITED KINGDOM        4   
          654               1                General  Type A          FRANCE        3   
          987               5                General  Type B  UNITED KINGDOM        2   
          321               1                General  Type B         GERMANY        1   
          951               3                General  Type A  UNITED KINGDOM        2   
          357               4                General  Type C  UNITED KINGDOM        3   
</code></pre>

<p>As we can see; above the first 2 column headings there are 2 blank cells and below the next 4 column headings are "B" numbers which I don't care about.</p>

<p>So 2 questions; How can I shift up the first 2 columns without having a column heading to identify them with (due to the blank cells above)?</p>

<p>And how can I delete just Row 2 of the remaining columns and have the data below move up to take the place of the "B" numbers?</p>

<p>I found some similar questions already asked <a href="https://stackoverflow.com/questions/20095673/python-shift-column-in-pandas-dataframe-up-by-one">python: shift column in pandas dataframe up by one</a> but nothing that solves the particular intricacies above I don't think.</p>

<p>Also I'm quite new to Python and Pandas so if this is really basic I apologise!</p>