title: Reading a csv file into pandas dataframe with quotation in some entries
body: <p>I have a csv file like</p>
  <blockquote>
  <p>id,body,category,subcategory,number,smstype,smsflag</p>
  <p>50043,&quot;Dear Customer,Thank you for registering&quot;,,,DM-YEBA,inbox,0</p>
  <p>30082,Congrats! Your account has been activated.,,,DM-SBAW,inbox,0</p>
  </blockquote>
  <p>when i'm using <code>pd.read_csv()</code> then the whole first observation is included in the <code>id</code> column and is not separated among other columns due to the double quotes used for the message body, while in second observation the line is properly separated among the columns.</p>
  <p>What should I do such that the first observation is seperated among all columns like in this image
  <a href="https://i.stack.imgur.com/1kfbM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1kfbM.png" alt="enter image description here" /></a></p>
  <p>see what actually pd.read_csv is doing. It's taking the whole observation in id column
  <a href="https://i.stack.imgur.com/3NHpu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3NHpu.png" alt="vhjn" /></a></p>
  <p>when i am opening the csv file in notepad it's adding extra quotation marks to the whole row which is eventually causing the fiasco and the quotation mark already in the file are escaped with another ' &quot; ' as shown below.</p>
  <blockquote>
  <p>id,body,category,subcategory,number,smstype,smsflag</p>
  <p>&quot;50043,&quot;&quot;Dear Customer,Thank you for registering&quot;&quot;,,,DM-YEBA,inbox,0&quot;</p>
  <p>30082,Congrats! Your account has been activated.,,,DM-SBAW,inbox,0</p>
  </blockquote>