title: Joining 2 dataframes in pandas with different column names
body: <p>I'm trying to join 2 dataframes in a kind of strange way and was wondering if anyone has any advice. </p>
  
  <p>My first data frame looks like this, call it <code>df1</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/L1qtF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/L1qtF.jpg" alt="teamStatsDF"></a></p>
  
  <p>2nd one looks like, call it <code>df2</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/9pxa0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9pxa0.jpg" alt="teamGames"></a></p>
  
  <p>I want my final output to merge each team's stats next to their respective names in the games dataframe. A brute force way I thought of doing this was to change the name of the <code>TEAM</code> column in <code>df1</code> to <code>Home</code>, join it on that. Then, change the <code>TEAM</code> column to <code>Visitor</code> and join it on that too but I feel their should be an easier way. Can anyone give me advice on this, thanks!</p>