title: csv column values going to new line causing errors loading in pandas
body: <p>I have an issue with csv's that have a split within a column that go to a new line. I can fix the issue manually editing the .csv but there's ~200 files.</p>
  <p>The dataset contains more columns and can contain nulls, however the last column always has a value. The issue also only occurs within the same column every time. So I was thinking of finding when the last value was null and then trying to fill the values with .shift() but was hoping for an easier way.</p>
  <h3>view in vscode</h3>
  <pre><code>orderid,fruit,count,person  
  3523,apple,84,peter  
  2522,green  
  grape, 99, mary   
  1299, watermelon, 93, paul
  </code></pre>
  <h3>pandas read_csv</h3>
  <pre><code>orderid fruit       count   person
  3523    apple       84      peter
  2522    green       NaN     NaN
  grape   99          mary    NaN
  1299    watermelon  93      paul
  </code></pre>
  <h3>wanted columns</h3>
  <pre><code>orderid fruit       count   person
  3523    apple       84      peter
  2522    green grape 99      mary
  1299    watermelon  93      paul
  </code></pre>