title: How to merge pandas dataframes from two separate lists of dataframes
body: <p>I have two lists of dfs</p>
  
  <pre><code>List1 = [df1,df2,df3]
  List2 = [df4,df5,df6]
  </code></pre>
  
  <p>I want to merge the first df from List1 with the corresponding df from List 2. ie df1 with df4 and df2 with df5, etc.</p>
  
  <p>The dfs share a common column, 'Col1'. I have tried the following code</p>
  
  <pre><code>NewList = []
  for i in len(List1),len(List2):
      NewList[i]=pd.merge(List1[i],List2[i],on='Col1') 
  </code></pre>
  
  <p>I get the error 'list index out of range'.</p>
  
  <p>I realise that this seems to be a common problem, however I cannot apply any of the solutions that I have found on Stack to my particular problem.</p>
  
  <p>Thanks in advance for any help</p>