title: Unable to join to dataframe in pandas
body: <p>I have two df. The first df is a multiindex and the other one is typical single index.</p>
  
  <p><a href="https://i.stack.imgur.com/QHi2E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QHi2E.png" alt="enter image description here"></a></p>
  
  <p>Figure 1: Multiindex df</p>
  
  <p>and</p>
  
  <p><a href="https://i.stack.imgur.com/YuzxN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YuzxN.png" alt="enter image description here"></a></p>
  
  <p>Figure 2: Single indexing</p>
  
  <p>Upon join these two df, I got the following error</p>
  
  <blockquote>
    <p>cannot join with no overlapping index names</p>
  </blockquote>
  
  <p>I suspect, this error due to the index column <strong>name</strong> in the first df (Figure 1).</p>
  
  <p>Even, swaping the index name and typical numeric value also does not help</p>
  
  <p><a href="https://i.stack.imgur.com/yTvv3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yTvv3.png" alt="enter image description here"></a></p>
  
  <p>Figure 2: Multiindex df</p>
  
  <p>May I know how to address this error?</p>
  
  <p>Thanks in advance for the time taken</p>