title: Read csv file in R with double quotes
body: <p>Suppose I have a csv file looks like this:</p>
  
  <pre><code>Type,ID,NAME,CONTENT,RESPONSE,GRADE,SOURCE
  A,3,"","I have comma, ha!",I have open double quotes",A,""
  </code></pre>
  
  <p>desired output should be:</p>
  
  <pre><code>df &lt;- data.frame(Type='A',ID=3, NAME=NA, CONTENT='I have comma, ha!',
                   RESPONSE='I have open double quotes\"', GRADE=A, SOURCE=NA)
  df
    Type ID NAME           CONTENT                   RESPONSE GRADE SOURCE
  1    A  3   NA I have comma, ha! I have open double quotes"     A     NA
  </code></pre>
  
  <p>I tried to use <code>read.csv</code>, since the data provider uses quote to escape comma in the string, but they forgot to escape double quotes in string with no comma, so no matter whether I disable quote in <code>read.csv</code> I won't get desired output.</p>
  
  <p>How can I do this in R? Other package solutions are also welcome. </p>