Dan
Dan

Reputation: 5

python sort csv column as integer

Trying to sort a csv integer column but it get sorted alphabetically.

This sorts alphabetically not numerically

sortedChanels = sorted(reader, key=operator.itemgetter(4), reverse=False)

Tried

sortedChanels = sorted(reader, key=lambda t: int(t(4)))

get error

TypeError: 'list' object is not callable

Upvotes: 0

Views: 1644

Answers (1)

Hugh Bothwell
Hugh Bothwell

Reputation: 56674

sortedChanels = sorted(reader, key=lambda row: int(row[4]), reverse=False)

Upvotes: 3

Related Questions