title: How to use delimiter for CSV in Python?
body: <p>I'm having trouble with figuring out how to use the delimiter for <code>csv.writer</code> in Python.
  I have a CSV file in which the strings separated by commas are in single cell and I need to have each word in each individual cell, e.g:</p>
  <pre class="lang-none prettyprint-override"><code>100 , 2559  ,,Main, St,LEOMA,LEOMA,498,498, AK,AK
  140 , 425   ,,Main, St,LEOMA,LEOMA,498,498, AK,AK
  100 , 599   ,,Main, St,LEOMA,LEOMA,498,498, AK,AK
  </code></pre>
  <p>should have each word in an individual cell:</p>
  <pre class="lang-none prettyprint-override"><code>100 2559    Main    St  LEOMA   LEOMA   498 498 AK  AK
  140 425     Main    St  LEOMA   LEOMA   498 498 AK  AK
  100 599     Main    St  LEOMA   LEOMA   498 498 AK  AK
  </code></pre>
  <p>I tried:</p>
  <pre class="lang-py prettyprint-override"><code>import csv
  workingdir = &quot;C:\Mer\Ven\sample&quot;
  csvfile = workingdir+&quot;\test3.csv&quot;
  f=open(csvfile,'wb')
  
  csv.writer(f, delimiter =' ',quotechar =',',quoting=csv.QUOTE_MINIMAL)
  </code></pre>