title: Add header with merged cells from one excel and insert to another excel Pandas
body: <p>I have been searching over on how to append/insert/concat a row from one excel to another but with merged cells. I was not able to find what I am looking for.</p>
  
  <p>What I need to get is this:
  <a href="https://i.stack.imgur.com/5Mucf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5Mucf.png" alt="enter image description here"></a></p>
  
  <p>and append to the very first row of this:
  <a href="https://i.stack.imgur.com/sBfrF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sBfrF.jpg" alt="enter image description here"></a></p>
  
  <p>I tried using pandas append() but it destroyed the arrangement of columns.</p>
  
  <pre><code>df = pd.DataFrame()
  
  for f in ['merge1.xlsx', 'test1.xlsx']:
      data = pd.read_excel(f, 'Sheet1')
      df = df.append(data)
  
  df.to_excel('test3.xlsx')
  </code></pre>
  
  <p>Is there way pandas could do it? I just need to literally insert the header to the top row.</p>
  
  <p>Although I am still trying to find a way, it would actually be fine to me if this question had a duplicate as long as I can find answers or advice.</p>