title: How to read two larger 5GB csv files in local system Jupyter Notebook using python pandas? how to join two dataframes for data analysis in local?
body: <p>How to upload two large (5GB) each csv file in local system Jupyter Notebook using python pandas. Please suggest any configuration to handle big csv files for data analysis ?</p>
  
  <pre><code>Local System Configuration:
  OS: Windows 10
  RAM: 16 GB
  Processor: Intel-Core-i7
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code>dpath = 'p_flg_tmp1.csv'
  pdf = pd.read_csv(dpath, sep="|") 
  
  Error:
  MemoryError: Unable to allocate array
  </code></pre>
  
  <p>or</p>
  
  <pre><code>pd.read_csv(po_cust_data, sep="|", low_memory=False)
  
  Error:
  ParserError: Error tokenizing data. C error: out of memory
  </code></pre>
  
  <p>How to handle two bigger csv file in local system for data analysis? please suggested better configuration if possible in local system using python pandas.</p>