title: ValueError: array is too big
body: <p>I am trying to merge two excel files using the following code and encountering the error of <code>ValueError: array is too big; arr.size * arr.dtype.itemsize is larger than the maximum possible size.</code></p>
  
  <pre><code>import pandas as pd
  
  file1 = pd.read_excel("file1.xlsx")
  file2 = pd.read_excel("file2.xlsx")
  
  file3 = file1.merge(file2, on="Input E-mail", how="outer")
  
  file3.to_excel("merged1.xlsx")
  </code></pre>
  
  <p>File size is ~100MB+~100MB, Available Ram is 9GB (of 16GB)</p>