title: Parse CSV in Pandas
body: <p>I currently have a .csv that I am getting from S3 and trying to read the file in using the following command:</p>
  
  <pre><code>for i in range(0, 50):
  response = s3.get_object(Bucket = b, Key = a['ColumnName'].iloc[i])
  file = response['Body'].read()
  tempdf = pd.read_csv(io.BytesIO(file), sep=r',(?!\s)')
  </code></pre>
  
  <p>The issue is that the .csv that is being parsed has text with commas in it and is throwing off the column alignment. The columns are also not blocked off with quoting and there is no option to change the raw file.</p>