csvcut issue with Python 3

[bucweat]

Hi,

Was going through the "Examining Data" section of the tutorial. The section "2.5. Sorting with csvsort" command "" works with Python 2, but not with Python 3. From my terminal:

************* Python 2 **************
charlies-MacBook-Air:va_benefits charlie$ csvcut -c 9,1 2009.csv | csvsort -r | head -n 5
TOTAL,State Name
,
46897,CALIFORNIA
40402,TEXAS
36394,FLORIDA
charlies-MacBook-Air:va_benefits charlie$ python --version
Python 2.7.6 :: Anaconda 2.0.0 (x86_64)

************* Python 3 **************
(py3k)charlies-MacBook-Air:va_benefits charlie$ csvcut -c 9,1 2009.csv | csvsort -r | head -n 5
unorderable types: int() < str()
(py3k)charlies-MacBook-Air:va_benefits charlie$ python --version
Python 3.3.5 :: Anaconda 2.0.0 (x86_64)

I've not had a chance to troubleshoot a whole lot...figured I'd toss this one out there and see if this is a known problem or not. Column 9 in this data set is mostly quoted values with embedded commas (e.g. ...,"45,456",...).

charlie

[JoeGermuska]

Can provide the problem CSV? Or if not, can you make a simple one that demonstrates the problem?

[onyxfish]

Replicated:

csvcut -c 9,1 examples/realdata/FY09_EDU_Recipients_by_State.csv | csvsort -r | head -n 5

[onyxfish]

Traceback from csvsort:

Traceback (most recent call last):
  File "/Users/onyxfish/.virtualenvs/csvkit3/bin/csvsort", line 9, in <module>
    load_entry_point('csvkit==0.8.1', 'console_scripts', 'csvsort')()
  File "/Users/onyxfish/src/csvkit/csvkit/utilities/csvsort.py", line 59, in launch_new_instance
    utility.main()
  File "/Users/onyxfish/src/csvkit/csvkit/utilities/csvsort.py", line 48, in main
    rows.sort(key=sorter, reverse=self.args.reverse)
TypeError: unorderable types: int() < str()