title: How to remove double quotes in csv file with Python
body: <p>I've managed to split a row of numbers separated by commas into new columns with each number in a row. However,i am not sure how to remove the double quote from the start and end of each row. </p>
  
  <p>This is my code : </p>
  
  <pre><code>import csv
  from csv import writer
  
  
  COLUMNS = 6
  
  with open("Winning No - Sheet1.csv", "r") as input:
      with open("output_file.csv", "w") as f:
          output = writer(f, delimiter=";")
          output.writerow(["Col {}".format(i+1) for i in xrange(COLUMNS)])
          for row in input:
              output.writerow(row.split(','))
  </code></pre>
  
  <p>Output that i get:</p>
  
  <pre><code>COL1 COL2 COL3 COL4 COL5 COL6 
  "22    23   25   32   33   36"
  </code></pre>
  
  <p>p/s: Need to remove the double quotes from col1 and col6.</p>
  
  <p>I edited my code into, but i still didn't get the output that i wanted :</p>
  
  <pre><code>output = writer(f, delimiter=";", quoting=csv.QUOTE_NONE, doublequote=False, escapechar=' ')
  </code></pre>