title: How to read_csv with incorrectly formatted file
body: <p>I have a text file as sample below:</p>
  <pre><code>col A,col B,col C,col D,col E
  val A1,val B1,val C1,val D1,val E1, val E2, val E3
  val A2,val B2, val C2,val D2, val E4
  </code></pre>
  <p>Please note that some values in col E has multiple values which contains &quot;,&quot; e.g <strong>val E1, val E2, val E3</strong></p>
  <p>When I use <code>df = pd.read_csv(r'path/text_file.txt',  sep=&quot;\t&quot;)</code>, it reads as one column instead of multiple columns as below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>col A,col B,col C,col D,col E</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>val A1,val B1,val C1,val D1,val E1, val E2, val E3</td>
  </tr>
  <tr>
  <td>val A2,val B2, val C2,val D2, val E4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The expected dataframe as below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>col A</th>
  <th>col B</th>
  <th>col C</th>
  <th>col D</th>
  <th>col E</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>val A1</td>
  <td>val B1</td>
  <td>val C1</td>
  <td>val D1</td>
  <td>val E1, val E2, val E3</td>
  </tr>
  <tr>
  <td>val A2</td>
  <td>val B2</td>
  <td>val C2</td>
  <td>val D2</td>
  <td>val E4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried replacing the delimiter with &quot;,&quot; instead of &quot;\t&quot; but it wouldn't work since in col E, I have multiple values which is separated by &quot;,&quot;.</p>