[Tutor] Please help me on Python Code

[André Pinto]

Dear.

 

I have a question and I can't solve it.

I need to average 40,000 items in a dataset and for each item I have 4
different conditioners.

I am writing the code as follows, but I am not achieving my goal which is to
classify the item according to its conditional, it should get the number 1
or the number zero and at the end the sum of them in a last column in the
dataset.

What is the best solution to this question? My code is:

 

def media6(dataset):

                val6 = 10  

if 0 < dataset['43709'].isin([dataset]).all():

                val6 = 1

elif 43709 > dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 <
dataset['Saldo_Estoque'].isin([dataset]).all():

                 val6 = 1

elif 43709 > dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 ==
dataset['Saldo_Estoque'].isin([dataset]).all() and 0 <
dataset['43739'].isin([dataset]).all():

                 val6 = 1

else:

                val6 = 0

return (val6)

 

def media5(dataset):

val5 = 9

                if 0 < dataset['43678'].isin([dataset]).all():

                 val5 = 1

                elif 43678 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 <
dataset['Saldo_Estoque'].isin([dataset]).all():

                val5 = 1

                elif 43678 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 ==
dataset['Saldo_Estoque'].isin([dataset]).all() and 0 < dataset['43709',
'43739'].isin([dataset]).all():

                val5 = 1

                else:

                val5 = 0

                return (media5)    

 

def media4(dataset):

                 val4 = 8

                if 0 < dataset['43647'].isin([dataset]).all():

                val4 = 1

                elif 43647 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 <
(dataset['Saldo_Estoque']).isin([dataset]).all():

                val4 = 1

                elif 43647 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 ==
(dataset['Saldo_Estoque']).isin([dataset]).all() and 0 < dataset['43678',
'43709', '43739'].isin([dataset]).all():

                val4 = 1

                else:

                val4 = 0

                return (media4)

 

def media3(dataset):

                val3 = 7

                if 0 < dataset['43617'].isin([dataset]).all():

                val3 = 1

                elif 43617 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 <
dataset['Saldo_Estoque'].isin([dataset]).all():

                val3 = 1

                elif 43617 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 ==
dataset['Saldo_Estoque'].isin([dataset]).all() and 0 < dataset['43647',
'43678', '43709', '43739'].isin([dataset]).all():

                val3 = 1

                else:

                val3 = 0

                return (media3)

 

def media2(dataset):

                val2 = 6

                if 0 < dataset['43678'].isin([dataset]).all():

                val2 = 1

                elif 43678 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 <
dataset['Saldo_Estoque'].isin([dataset]).all():

                val2 = 1

                elif 43678 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 ==
dataset['Saldo_Estoque'].isin([dataset]).all() and 0 < dataset['43617',
'43647', '43678', '43709', '43739'].isin([dataset]).all():

                val2 = 1

                else:

                val2 = 0

                return (media2)

 

def media1(dataset):

                val1 = 5

                if 0 < dataset['43556'].isin([dataset]).all():

                val1 = 1

                elif 43556 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 <
dataset['Saldo_Estoque'].isin([dataset]).all():

                val1 = 1

                elif 43556 >
dataset['Data_Ultima_Entrada'].isin([dataset]).all() and 0 ==
dataset['Saldo_Estoque'].isin([dataset]).all() and 0 < dataset['43678',
'43617', '43647', '43678', '43709', '43739'].isin([dataset]).all():

                val1 = 1

                else:

                val1 = 0

                return (media1)

 

dataset[‘MEDIA’] = (media6 + media5 + media4 + media3 + media2 + media1)

 

Waiting your help to solve this problem. Thank you very much.

 

 

Com os cumprimentos

Best Regards

Atentos Saludos

 

André Luís M. Pinto

* +55 (71) 98802-6841

Skype ID:  <mailto:andre.luis.m.pinto at outlook.com>
andre.luis.m.pinto at outlook.com

P Antes de imprimir pense em seu comprimisso com o Meio Ambiente.

 

 



-- 
Este email foi escaneado pelo Avast antivírus.
https://www.avast.com/antivirus