title: List to csv delimited by comma and new line python
body: <p>I have a list which I want to write to a CSV file and i want it to be delimited by comma followed by a newline.
  I have tried writerows but this splits all the characters.
  I have tried writerow but this gives me all in one row delimited by comma but no newline for each entry.</p>
  <p><strong>My attempt</strong></p>
  <pre><code>import  csv
  
  mylist = ['AFCIEUR ID', 'CSCIB25 LX' , 'GAMCOIE ID']
  
  writer = open(&quot;my_EQ_IDs.csv&quot;, 'w+')
  writer_out = csv.writer(writer,delimiter='\n')
  fields = ['SYMBOL']
  writer_out.writerow(fields)
  writer_out.writerows(mylist)
  </code></pre>
  <p>This gives me</p>
  <pre><code>SYMBOL
  
  A
  F
  C
  I
  E
  U
  R
   
  I
  D
  
  C
  S
  C
  I
  B
  2
  5
   
  L
  X
  
  G
  A
  M
  C
  O
  I
  E
   
  I
  D
  </code></pre>
  <p>If I use <code>writerow</code> instead of <code>writerows</code> i get the below</p>
  <pre><code>SYMBOL
  
  AFCIEUR ID
  CSCIB25 LX
  GAMCOIE ID
  </code></pre>
  <p>This is close to what i want but it's not separated by comma as I need. I have tried adding delimiter as <code>delimiter=',\n'</code> but this gives me an error <code>TypeError: &quot;delimiter&quot; must be a 1-character string</code></p>
  <p><strong>I need (Expected Output)</strong></p>
  <pre><code>SYMBOL
  
  AFCIEUR ID,
  CSCIB25 LX,
  GAMCOIE ID
  </code></pre>
  <p>Can someone tell me what i'm doing wrong and point me in the right direction?</p>
  <p>Much appreciated!</p>