Home Original page

tabular data

Bill Wilkinson bwilk_97 at yahoo.com
Sat Apr 8 18:11:58 EDT 2000 
<<<For example, say that I have the following tabular data: [(2,1,"REC02"),
<<<(1,3,"REC03"),(3,1,"REC01")], and I want to obtain: [(1,3,"REC03"),
<<<(2,1,"REC02"),(3,1,"REC01")], that is, the tabular data should be
<<<sorted on the first and then the second column.

You can get lists.py from:
http://starship.python.net/crew/lemburg/

It has this routine, which is attributed to Guido and others.

def sortedby(list,*indices):
   nlist = map( lambda x,indices=indices:
   map( lambda i,x=x: x[i], indices) + [x],
   list)
    nlist.sort()
    return map( lambda l: l[-1], nlist)

The list in not sorted in place though.

<<<By the way, should I represent rows by tuples or by embedded lists?

They need to be lists if you want to edit them... In my opinion, a list of
dictionaries is the best way to go.....

<<<Another problem: to visually represent/edit tabular data, I need an
<<<editable grid widget (with possibly comboboxes as cell editors).
<<<TkInter does not seem to have an appropriate grid widget.

wxPython has a grid that is ok... There is a new grid that will be available
soon that will be a bit better.
More information about the Python-list mailing list