title: pandas append on columns with different names
body: <p>How to append 2 different dataframes with different column names</p>
  
  <pre><code>a = pd.DataFrame({
      "id": [0,1,2,3],
      "countryid": [22,36,21,64],
      "famousfruit": ["banana", "apple", "mango", "orange"],
      "famousanimal": ["monkey", "elephant", "monkey", "horse"],
      "waterlvl": [23, 43, 41, 87]
  }).set_index("id")
  
  &gt;&gt; a
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Ld9ab.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ld9ab.png" alt="a"></a></p>
  
  <pre><code>b = pd.DataFrame({
      "id": [0,1,2,3],
      "cid": [25,27,98,67],
      "FAM_FRUIT": ["grapes", "pineapple", "avacado", "orange"],
      "FAM_ANI": ["giraffe", "dog", "cat", "horse"],
  }).set_index("id")
  
  &gt;&gt;b
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/V1Xno.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V1Xno.png" alt="b"></a></p>
  
  <p>How to append the rows on <strong>b</strong> on the respective columns(whose names are different compared to <strong>a</strong>) and produce a result like below c</p>
  
  <p><a href="https://i.stack.imgur.com/MIhXs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MIhXs.png" alt="c"></a></p>