output confusion in sort_values of Pandas - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: output confusion in sort_values of Pandas (/thread-19137.html) |
output confusion in sort_values of Pandas - ift38375 - Jun-14-2019 Given below is small program in python: import pandas as pd ontutD = {'Tutor': ['Tahira','Gagan','Anusha','Jacob','venkat', 'Tahira','Gagan','Anusha','Jacob','venkat', 'Tahira','Gagan','Anusha','Jacob','venkat', 'Tahira','Gagan','Anusha','Jacob','venkat'], 'Classes' : [28,36,41,32,40,36,40,36,40,46,24,30,44,40,32,36,32,36,42,38], 'Quarter' : [1,1,1,1,1,2,2,2,2,2,3,3,3,3,3,4,4,4,4,4], 'Country' : [ 'USA','UK','Japan','USA','Brazil','USA','USA','Japan', 'Brazil','USA','Brazil','USA','UK','Brazil','USA','Japan', 'Japan','Brazil','UK','USA'] } df1 = pd.DataFrame(ontutD) ks = df1.sort_values('Country') print (ks) Python 3.7.3 Output : My confusion in index number:17, it will be come at 5th position ? please correct me
RE: output confusion in sort_values of Pandas - ThomasL - Jun-14-2019 you need to specify type of sorting algorithm to be mergesort ks = df1.sort_values('Country', kind='mergesort')default is 'quicksort' which is not stable |