Sorting a table in python with alphabet and numbers

I have the following table: Column1 Column2 99 QA 65 CD 134 LL N12 OO 127 KK Q23 MM 1 AA A10 KL K9 MA I would like to sort the table such that the numbers are sorted in descending order …

How to groupby 2 columns but order descending by count()

i have a dataframe and want to group 2 columns, which is working fine. df.groupby([“Sektor, CustomerID”]).count().head(10) _Order_ID_ Order_timezone Order_weight …

txt file sorting(key:value in every line) – a problem with ‘n’

I am trying to sort txt file which looks like that : byr:1983 iyr:2017 pid:796082981 cid:129 eyr:2030 ecl:oth hgt:182cm iyr:2019 cid:314 eyr:2039 hcl:#cfa07d hgt:171cm ecl:#0180ce byr:2006 pid:…

case-insensitive treeview sorting

I am using below code to sort the treeview column but it is case sensitive i.e. if the column value is [a,c,A] the sorted value will be [a,c,A]but i want it as [a,A,c] and even the number sorting is …

Sort dataframe by multiple columns while ignoring case

I want to sort a dataframe by multiple columns like this: df.sort_values( by=[ ‘A’, ‘B’, ‘C’, ‘D’, ‘E’ ], inplace=True ) However i found out that python first sorts the uppercase values and then the …

Why “None Type” is returned while Selection Sort implementation in Python? [closed]

I’m trying to implement Selection Sort Algorithm in Python and for some reason Sorted Array is returned as None . Here’s the Code: #Selection Sort def selection_sort(array): for i in range(len(…

Why is print not printing my array sorted

This is my original array: a = [0, 4, 7, 8, 1, 3, 5, 2, 6] and this is what it prints: [0, 4, 7, 0, 0, 0, 5, 0, 0] Answer As @’Lee Jun Wei’ it doesn’t look like your algo is right. But there may be a few other things to point out. These two lines look off. i and j are taking on the value of the elements of a not the index values. I think you mean The reason you get zeros is because min is initialized to 0. Note that it is zero not because

Order CSV with two digit numbers

I’m trying to create a leaderboard for a game, where after the game has been played, the python script accesses a CSV file (not ordered) and prints out the top 5 people with the highest score. Python seems to do this fine with single-digit numbers, but I can’t get it to work with 2 digit numbers. Here is the code: and here is the output: (I just used placeholder names for now) and here is the original leaderboard file: How do I get it to order the numbers properly? Answer I suggest simply reading the file with file.readlines() and then

Python sorted not sorting Counter output properly

I am trying to sort out min page load time and max page load time from Apache access log file. After parsing the log file and sorting using sorted I am seeing weird sorting. The above code sorting thousandths and only then sorting hundreds: As you see 455 and 677 are at the end, but if you look separately at thousandths and hundreds sorting is going correctly. Can someone shed light into this please? BTW, if I don’t use map to tuple I am getting “TypeError: unhashable type: ‘list’” error for “Counter”, thus need to work with tuple. Sorting using

Sort lists of dictionaries within dictionary

EDIT: I’m editing the whole post as it wasn’t as clear as I thougt. I have this dictionary (list of dictionaries within a dictionary) and I need to sort it by the values of “Position” and “Team”, meaning that I need to get all the values from those two keys and print them as I show below. I know how to get each value, but I don’t know how to get them and sort them. I tried this piece of code, but I still can’t get it to work. My actual dictionary is much bigger than this one, and I