Skip to content

Instantly share code, notes, and snippets.

@phihag

phihag/RawDataeDataTest.csv

Created October 18, 2013 09:30
Show Gist options
  • Save phihag/7039021 to your computer and use it in GitHub Desktop.
Save phihag/7039021 to your computer and use it in GitHub Desktop.
Download ZIP
Demonstration of csv sorting
Raw
output.csv
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass2 text text
text text text 11/03/12 text text text UniqueNameClass2 text text
text text text 11/03/12 text text text UniqueNameClass3 text text
text text text 11/03/12 text text text UniqueNameClass4 text text
text text text 11/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass3 text text
text text text 12/03/12 text text text UniqueNameClass3 text text
text text text 12/03/12 text text text UniqueNameClass4 text text
text text text 12/03/12 text text text UniqueNameClass4 text text
text text text 12/03/12 text text text UniqueNameClass4 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 13/03/12 text text text UniqueNameClass1 text text
text text text 13/03/12 text text text UniqueNameClass2 text text
text text text 13/03/12 text text text UniqueNameClass2 text text
text text text 13/03/12 text text text UniqueNameClass2 text text
text text text 13/03/12 text text text UniqueNameClass3 text text
text text text 13/03/12 text text text UniqueNameClass4 text text
text text text 13/03/12 text text text UniqueNameClass5 text text
Raw
RawDataeDataTest.csv
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass2 text text
text text text 11/03/12 text text text UniqueNameClass4 text text
text text text 11/03/12 text text text UniqueNameClass3 text text
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass2 text text
text text text 11/03/12 text text text UniqueNameClass5 text text
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 11/03/12 text text text UniqueNameClass1 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass3 text text
text text text 12/03/12 text text text UniqueNameClass4 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass3 text text
text text text 12/03/12 text text text UniqueNameClass5 text text
text text text 12/03/12 text text text UniqueNameClass4 text text
text text text 12/03/12 text text text UniqueNameClass4 text text
text text text 13/03/12 text text text UniqueNameClass5 text text
text text text 13/03/12 text text text UniqueNameClass4 text text
text text text 13/03/12 text text text UniqueNameClass2 text text
text text text 13/03/12 text text text UniqueNameClass1 text text
text text text 13/03/12 text text text UniqueNameClass3 text text
text text text 13/03/12 text text text UniqueNameClass2 text text
text text text 13/03/12 text text text UniqueNameClass2 text text
Raw
test.py
import csv
with open('RawDataeDataTest.csv', 'rb') as csvf:
data = list(csv.reader(csvf))
data.sort(key=lambda row: (row[3], row[7]))
print(u'\n'.join(u','.join(row) for row in data))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment