title: How to parse tsv file with python?
body: <p>I have a tsv file which includes some newline data.</p>
  
  <pre><code>111 222 333 "aaa"
  444 555 666 "bb
  b"
  </code></pre>
  
  <p>Here <code>b</code> on the third line is a newline character of <code>bb</code> on the second line, so they are one data:</p>
  
  <p>The fourth value of first line:</p>
  
  <pre><code>aaa
  </code></pre>
  
  <p>The fourth value of second line:</p>
  
  <pre><code>bb
  b
  </code></pre>
  
  <p>If I use Ctrl+C and Ctrl+V paste to a excel file, it works well. But if I want to import the file using python, how to parse?</p>
  
  <p>I have tried:</p>
  
  <pre><code>lines = [line.rstrip() for line in open(file.tsv)]
  for i in range(len(lines)):
      value = re.split(r'\t', lines[i]))
  </code></pre>
  
  <p>But the result was not good:</p>
  
  <p><a href="https://i.stack.imgur.com/7Acra.png" rel="noreferrer"><img src="https://i.stack.imgur.com/7Acra.png" alt="enter image description here"></a></p>
  
  <p>I want:</p>
  
  <p><a href="https://i.stack.imgur.com/DHJEN.png" rel="noreferrer"><img src="https://i.stack.imgur.com/DHJEN.png" alt="enter image description here"></a></p>