title: dealing with commas in strings in csv
body: <p>I'm practicing some text mining with python using this dataset
   <a href="https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat" rel="nofollow noreferrer">https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat</a></p>
  
  <p>Everything is nicely formatted but some entries like:</p>
  
  <pre><code>6898,"RAAF Williams, Laverton Base","Laverton","Australia",\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"   
  6899,"Nowra Airport","Nowra","Australia","NOA","YSNW",-34.94889831542969,150.53700256347656,400,10,"O","Australia/Sydney","airport","OurAirports"
  </code></pre>
  
  <p>have commas in their names and that makes irregular lists, since it creates multiple elements of the same core element (name)</p>
  
  <p>My code for assigning each line to a list:</p>
  
  <pre><code>with open (filename) as txt:
  for line in txt:
      linea = line.split(',')
      linea[3]=linea[3].strip('"')
  </code></pre>
  
  <p>My main problem is that <code>linea[3]</code> should be the country <code>australia</code> in this case, but it returns <code>Laverton</code>.</p>
  
  <p>I also tried the csv library with little to no difference.</p>
  
  <p>Also relevant: my code returns this for that entry</p>
  
  <pre><code>['6898', 'RAAF Williams, Laverton Base', 'Laverton', 'Australia', '\\N', 'YLVT', '-37.86360168457031', '144.74600219726562', '18', '10', 'O', 'Australia/Hobart', 'airport', 'OurAirports']
  </code></pre>