title: Sorting by Specific Column data using .csv in python
body: <p>I'm trying to order a .csv file with just over 300 entries and output it all back out ordered by the numerical values in one specific column under a dialect.
  Here's the code I've written so far but it just seems to output the data as it went in</p>
  
  <pre><code>import csv
  import itertools
  from itertools import groupby as gb
  
  reader = csv.DictReader(open('Full_List.csv', 'r'))
  
  groups = gb(reader, lambda d: d['red label'])
  result = [max(g, key=lambda d: d['red label']) for k, g in groups]
  
  
  
  writer = csv.DictWriter(open('output.csv', 'w'), reader.fieldnames)
  writer.writeheader()
  writer.writerows(result)
  </code></pre>
  
  <p>There's only 50 rows in the whole file that contain a value under the dialect "red label" and all the others are left blank. 
  It's in the Z column on the .csv(but not that last one) so I'd assume the index of the column is 25(0 being the first).
  Any help would be greatly appreciated.</p>