Wanting to sort between integer and float, with integer sorted lowest to highest

Question

I have a file that contains the following data:

1,0.00008118
1,0.00008101
12,0.00008122
5,0.00008091
8,0.00008092
1,0.00008109
2,0.00008100
260,0.00008087
248,0.00007982
69,0.00007958
71,0.00007954
51,0.00007910
20,0.00007932

I'd like to be able to sort the file so that the integer values are sorted lowest to highest. When sorting using the sorted function, it appears to be sorting numerically instead.

a_s = sorted(List)
for i in a_s:
    print(i)

So the output is:

1,0.00008101
1,0.00008109
1,0.00008118
12,0.00008122
2,0.00008100
20,0.00007932
248,0.00007982
260,0.00008087
5,0.00008091
51,0.00007910
69,0.00007958
71,0.00007954
8,0.00008092

How would i get it so that the numerical values are sorted the lowest to highest value?

Many Thanks,

This has been answered here before, check out this link https://stackoverflow.com/questions/3426108/how-to-sort-a-list-of-strings-numerically — Martin Wangen-Eriksen, Jul 06 '20 at 14:18
The data shown does not describe a list; naively interpreting it as a list of integer, float tuples does not provide the output shown. Please [edit] your question to contain a [mcve]. See the [ask] page how to best help us help you. — MisterMiyagi, Jul 06 '20 at 14:24

score 3 · Accepted Answer · answered Jul 06 '20 at 14:27

Try this:

with open('test.txt') as fp:
    data = [line.strip().split(',') for line in fp]

res = '\n'.join([','.join(x) for x in sorted(data, key=lambda x: int(x[0]))])
print(res)

Output:

1,0.00008118
1,0.00008101
1,0.00008109
2,0.00008100
5,0.00008091
8,0.00008092
12,0.00008122
20,0.00007932
51,0.00007910
69,0.00007958
71,0.00007954
248,0.00007982
260,0.00008087

Wanting to sort between integer and float, with integer sorted lowest to highest

1 Answers1