Python Data Frame Sorting
To sort the data coming from a .csv file, first let us read the data from the file into a data frame using read_csv() function as:
df = pd.read_csv("D:\python\PANDAS\empdata2.csv", parse_dates=['doj'])
Here, we are loading the data from empdata2.csv file and also informing to take 'doj' as date type field using parse_dates option. Now let us display the data frame as:
To sort the rows on 'doj' column into ascending order, we can use sort_values() method as:
To sort in descending order, we should use an additional option 'ascending = False' as:
Sorting on multiple columns is also possible. This can be done using an option 'by' in the sort_values() method. For example, we want to sort on 'doj' in descending order and in that 'sal' in ascending order. That means, when two employees have same 'doj', then their salaries will be sorted into ascending order.