title: Pandas : Joining two dataframes on a common column name and re-ordering the column order
body: <p>First DataFrame : prac1 and second one : prac_dates
  <a href="https://i.stack.imgur.com/nBNbF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nBNbF.png" alt="DataFrame"></a></p>
  
  <p>After writing the following code it gives the userwarning:</p>
  
  <pre><code>pracs = prac_dates.join(prac1,how='inner',on = "Month")
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/1fNbn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1fNbn.png" alt="Joined Dataframe"></a></p>
  
  <p>What I wish to achieve is to<br/> 1)Remove the  user warning and reorder the column sequence to ('Month','ShipName','ComoQty')and,<br/>
  2) Rename the (shipname,01),(shipname,02)... column to (shipcount,01),(shipcount,02)...</p>