title: Python CSV - Double-double quotes being written into CSV file?
body: <p>I'm trying to write some data into a csv file. I want only the middle column to have quotes in the csv file. I start out with the data saved in a array over arrays. Here are a few entries printed out:</p>
  
  <pre><code>['1', '"For Those About To Rock We Salute You"', 'Album']
  ['2', '"Balls to the Wall"', 'Album']
  ['3', '"Restless and Wild"', 'Album']
  ['4', '"Let There Be Rock"', 'Album']
  ['5', '"Big Ones"', 'Album']
  ['6', '"Jagged Little Pill"', 'Album']
  ...
  </code></pre>
  
  <p>As you can see the only the middle column has quotes. However when I write this to a csv file this is what I get:</p>
  
  <pre><code>1,""For Those About To Rock We Salute You"",Album
  2,""Balls to the Wall"",Album
  3,""Restless and Wild"",Album
  4,""Let There Be Rock"",Album
  5,""Big Ones"",Album
  6,""Jagged Little Pill"",Album
  ...
  </code></pre>
  
  <p>Everything is fine except that middle column! I have double-double quotes!</p>
  
  <p>I have a function that takes the data (which is saved in an array of arrays), and writes it into a csv file. I looked into the <code>QUOTE_NONE</code> method but that doesn't seem to work...</p>
  
  <pre><code>file_data = ...
  def write_node_csv():
      with open("./csv_files/albums.csv", mode='w') as csv_file:
          writer = csv.writer(csv_file, delimiter=',', quoting=csv.QUOTE_NONE, escapechar="\"")
          for data in file_data:
              writer.writerow(data)
      csv_file.close()
  </code></pre>
  
  <p>So basically I'm expecting this:</p>
  
  <pre><code>1,"For Those About To Rock We Salute You",Album
  2,"Balls to the Wall",Album
  3,"Restless and Wild",Album
  4,"Let There Be Rock",Album
  5,"Big Ones",Album
  6,"Jagged Little Pill",Album
  ...
  </code></pre>
  
  <p>but I'm getting this:</p>
  
  <pre><code>1,""For Those About To Rock We Salute You"",Album
  2,""Balls to the Wall"",Album
  3,""Restless and Wild"",Album
  4,""Let There Be Rock"",Album
  5,""Big Ones"",Album
  6,""Jagged Little Pill"",Album
  ...
  </code></pre>