title: correctly import Kaggle dataset into R
body: <p>I was trying to use R to analyze the <a href="https://www.kaggle.com/datasnaek/youtube-new/" rel="nofollow noreferrer">https://www.kaggle.com/datasnaek/youtube-new/</a> dataset. The csv file opens fine in Excel, but cannot be loaded correctly into R using </p>
  
  <pre><code>data &lt;- read.csv(
      "USvideos.csv", 
      header=TRUE, 
      sep = ",", 
      row.names = NULL, 
      quote = "\"") 
  </code></pre>
  
  <p>It turns out that there are <code>"</code> characters within the quote in a column, and there are new line characters within the quote in a column as well. </p>
  
  <p>Is there a way to let R figure out that the first and the last <code>"</code> character is the only quote character and ignore all the " characters and new line characters in the csv file as the Excel did?</p>
  
  <p>Thanks a lot!</p>