title: When I save as CSV, the file contains two separators which are comma and pipe
body: <p>I have two tables named result and result1 respectively. The only difference between those is with 'TITLE' columns, that one is str and another is str with the double quote. 
  <a href="https://i.stack.imgur.com/f0b0F.jpg" rel="nofollow noreferrer">table: result and result1</a></p>
  
  <p>My computer excel default is sep by ','. And the python to_csv default is also ','. And now when I check my result and result1 in CSV file by using the filter.</p>
  
  <p>I want my whole file looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/9UVrv.jpg" rel="nofollow noreferrer">result.csv sample</a></p>
  
  <p>But: There are some line looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/rcKPs.jpg" rel="nofollow noreferrer">result.csv bad lines</a></p>
  
  <p>Have a closer look, I found out some line is separated by pipe?????:</p>
  
  <p><a href="https://i.stack.imgur.com/Ef7YG.jpg" rel="nofollow noreferrer">result.csv bad lines closer look</a></p>
  
  <p>My questions become like:</p>
  
  <p>1.why when I save as csv, the file is contain two separators which is comma and pipe. </p>
  
  <p>2.How can I solve this problem? I check my data on python, it is all good.</p>
  
  <p>Anybody can help?? I would be soooo appreciated!</p>