title: Pandas pd.read_csv does not work for simple sep=','
body: <p>Good afternoon, everybody. </p>
  
  <p>I know that it is quite an easy question, although, I simply do not understand why it does not work the way I expected.</p>
  
  <p>The task is as following:</p>
  
  <p>I have a file data.csv presented in this format:</p>
  
  <pre><code>id,"feature_1","feature_2","feature_3"
  00100429,"PROTO","Proprietary","Phone"
  00100429,"PROTO","Proprietary","Phone"
  </code></pre>
  
  <p>The thing is to import this data using pandas. I know that by default pandas read_csv uses comma separator, so I just imported it as following:</p>
  
  <pre><code>data = pd.read_csv('data.csv')
  </code></pre>
  
  <p>And the result I got is the one I presented at the beginning with no change at all. I mean one column which contains everything.</p>
  
  <p>I tried many other separators using regex, and the only one that made some sort of improvement was:</p>
  
  <pre><code>data = pd.read_csv('data.csv',sep="\,",engine='python')
  </code></pre>
  
  <p>On the one hand it finally separated all columns, on the other hand the way data is presented is not that convenient to use. In particular:</p>
  
  <pre><code>"id         ""feature_1""   ""feature_2""   ""feature_3"""
  "00100429   ""PROTO""       ""Proprietary"" ""Phone"""
  </code></pre>
  
  <p>Therefore, I think that somewhere must be a mistake, because the data seems to be fine. </p>
  
  <p>So the question is - how to import csv file with separated columns and no triple quote symbols?  </p>
  
  <p>Thank you.</p>