Python multi-level sorting (multi-attribute sorting) csv file,

Python multi-level sorting (multi-attribute sorting) csv file,

Multi-level or multi-attribute sorting is often used when processing csv files. You can use the following method to easily perform multi-level sorting.

Python 2.x uses the following code: first sort by column x [0] in ascending order, and then sort by column x [0] in ascending order. To sort data in descending order, add reverse = True to the sorted function.

Import sys, csv, operatordata = csv. reader (open ('C: \ test.csv '), delimiter =', ') sortedlist = sorted (data, key = lambda x: (x [0], int (x [1]) with open ("C: \ result_test.csv", "wb") as f: fileWriter = csv. writer (f, delimiter = ',') for row in sortedlist: fileWriter. writerow (row) f. close ()

Python 3.x uses the following code: first sort by column x [0] in ascending order, and then sort by column x [0] in ascending order. To sort data in descending order, add reverse = True to the sorted function.

Import sys, csv, operatordata = csv. reader (open ('C: \ test.csv '), delimiter =', ') sortedlist = sorted (data, key = lambda x: (x [0], int (x [1]) with open ("C: \ result_test.csv", "w", newline = '') as f: fileWriter = csv. writer (f, delimiter = ',') for row in sortedlist: fileWriter. writerow (row) f. close ()