Sorting csv files using python

Veröffentlicht am: 25 November 2020
auf dem Kanal: IMSRS

8,330

This is a short video on how to sort a "comma separated values file" aka csv file using python.
I've used csv module for this.
Why it is difficult to sort a csv file in python?
Basically csv file is read using csv.reader() method.
This method returns the csv class object. When we convert the csv class object into a list then the resultant list will be "list of lists".
Here comes the main problem. We know how to sort a list using sort method which belongs to list class, but when it comes to list of lists sorting becomes trickier as the value we have to sort according to, will not be readily available in the list. It will be inside the list's list. I know it sounds crazy just look at the list of list given below:
x = [ ["Rollno 1", "ABC 1", 69], [ "Rollno 2", "ABC 2", 78], [ "Rollno 3", "ABC 3", 58 ] ]
if we use "x.sort()" the result would be :
[['Rollno 1', 'ABC 1', 69], ['Rollno 2', 'ABC 2', 78], ['Rollno 3', 'ABC 3', 58]]
That's why sort() is just not enough.
We have to use a key which returns the value through which we want to sort the file. this can be done by using:

i)
import operator
x = sorted(x, key=operator.itemgetter(3), reverse=True)# or just use x.sort( key=operator.itemgetter(3), reverse=True)
ii) you can replace key by
key=lambda row: row[3]

So by the following method we can sort x:
step (i)
x.sort(key = lambda l: l[-1], reverse = True)
step (ii)
x
[['Rollno 2', 'ABC 2', 78], ['Rollno 1', 'ABC 1', 69], ['Rollno 3', 'ABC 3', 58]]

references:
https://stackoverflow.com/questions/2...
code:
https://github.com/theunhackable/sort...

Meet me on::
/ srsp1116
https://github.com/theunhackable/

Auf dieser Seite können Sie das Online-Video Sorting csv files using python mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer IMSRS 25 November 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 8,330 Mal angesehen und es wurde von 76 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!