title: join multiple csv files in one folder using pandas [MemoryError:]
body: <p>I have 5 csv files in one folder, In here I want to join all columns from each csv file into one dataframe. When I only join 2 csv files, it works well, but when I want to join 5 csv files, I faced an error. My code is following below:</p>
  
  <pre><code>In [7]:
  
  import pandas
  import os
  import numpy as np
  import glob
  
  path =r'D:/PreprocessingITRC/output/All/'
  allFiles = glob.glob(path + "/*.csv")
  dataframe = pandas.DataFrame()
  for file in allFiles:
      df = pandas.read_csv(os.path.join(file),index_col=0, header=0)
      dataframe = dataframe.join(df, how='right')
  
  dataframe
  ---------------------------------------------------------------------------
  MemoryError                               Traceback (most recent call last)
  </code></pre>