Python - Higher value of a dictionary per key

Question

Good morning to all.

I need a lot of help with a project I’m doing. I’m having trouble getting only the highest values from a dictionary or a list. I’ll try to explain it better:

In AWK language I would do so for the highest values:

if (FILENAME == "..\\temp\\empregados.txt") {
    emp = substr($1, 1, 3)+0;
    i_emp = substr($1, 5)+0;

    if (i_emp > maior[emp])
        maior[emp] = i_emp

    print $0 > "..\\dados\\empregados.txt"

Here "if (i_emp > major[emp])" is the cat jump, because I create a arrey called "major and step as position of that arrey emp. With this he will tell me of the companies I have registered, which is the code of the largest employee per company.

I haven’t seen how to work with arreys of this type in Python so I can get the biggest code of each company.

Ex: I have csv file separated by "tab" asssim:

codigo_empresa codigo_empregado 2 2-201 2 2-200 2 2-305 2 2-002 3 3-305 3 3-405 3 3-105

And so it goes. I need him to keep the following values: 2 2-305 3 3-405

From now on I thank you all for your subsequent help.

Answer 1

That’s the way I found to solve my problem:

for row in read_file:
    codi = dict(row).get("CODI")
    codigo_empresa = codi[:3]
    codigo_empregado = codi[4:8]

   if codigo_empresa not in dict_empregado_maior:
       dict_empregado_maior[codigo_empresa] = codigo_empregado
   elif codigo_empregado > dict_empregado_maior[codigo_empresa]:
       dict_empregado_maior[codigo_empresa] = codigo_empregado

Answer 2

You can use the sorted with the parameter reverse=True if you want a list in descending order.

lista = 1.2, 2.8, 3.9, 4.1, 5.8

print(sorted(lista, reverse=True))

Exit:

[5.8, 4.1, 3.9, 2.8, 1.2]

Answer 3

If I understand correctly. you have a dictionary of the type below:

empr = {2:[201,200,305,2],
        3:[305,405,105]
        }

So one way to solve this is this:

selec = {}

for key in empr.keys(): # não precisa do .keys() mas fica mais intuitivo
    selec[key] = max(empr[key])


print(selec)

{2: 305, 3: 405}

Hit iterate by the key the dic generated by the table and get the maximum value.

Answer 4

Good morning you can use Python’s MAX function .

dic = {'A': 58, 'B': 100, 'C': 42, 'D': 99, 'E': 12}
dic[max(dic, key=dic.get)]

Exit:

100