sort csv by column

Question

I want to sort a CSV table by date  Started out being a simple task   import sys import csv  reader   csv reader open  files csv    delimiter       for id  path  title  date  author  platform  type  port in reader      print date   I used Python s CSV module to read in a file with that structure   id file description date author platform type port    The date is ISO-8601  therefore I can sort it quite easily without parsing  2003-04-22 e  g  I want to sort the by date  newest entries first How do I get this reader into a sortable data-structure  I think with some effort I could make a datelist  datelist    date  split and sort  However I have to re-identify the complete entry in the CSV table  It s not just sorting a list of things    csv doesn t seem to have a built in sorting function   The optimal solution would be to have a CSV client that handles the file like a database  I didn t find anything like that    I hope somebody knows some nice sorting magic here     Thanks   Marius

User · Accepted Answer

import operator sortedlist   sorted reader  key operator itemgetter 3   reverse True    or use lambda  sortedlist   sorted reader  key lambda row  row 3   reverse True

User · Answer

The reader acts like a generator   On a file with some fake data    gt  gt  gt  import sys  csv  gt  gt  gt  data   csv reader open  data csv   delimiter       gt  gt  gt  data  lt  csv reader object at 0x1004a11a0 gt   gt  gt  gt  data next     a     b     c    gt  gt  gt  data next     x     y     z    gt  gt  gt  data next   Traceback  most recent call last     File   lt stdin gt    line 1  in  lt module gt  StopIteration   Using operator itemgetter as Ignacio suggests    gt  gt  gt  data   csv reader open  data csv   delimiter       gt  gt  gt  import operator  gt  gt  gt  sortedlist   sorted data  key operator itemgetter 2   reverse True   gt  gt  gt  sortedlist    x     y     z      a     b     c

User · Answer

To sort by MULTIPLE COLUMN  Sort by column 1  and then sort by column 2   with open  unsorted csv  newline     as csvfile      spamreader   csv DictReader csvfile  delimiter          sortedlist   sorted spamreader  key lambda row  row  column 1   row  column 2     reverse False    with open  sorted csv    w   as f      fieldnames     column 1    column 2   column 3      writer   csv DictWriter f  fieldnames fieldnames      writer writeheader       for row in sortedlist          writer writerow row

[python] sort csv by column

Examples related to python

Examples related to csv

Examples related to sorting

Examples related to parsing