Find diff between different arrays

Question

GOAL

I have two arrays where it contains different formatted information, but the data is the same, for example on ARRAY1 the CLIENTE1-00 and the same as CLIENTE1 of ARRAY2, I just need to do a DIFFto get what does not belong between array 1 for array2, which would be the failures, these arrays are filled with a SELECT, ARRAY1 -> IBM DB2 and ARRAY2 -> POSTGRES, I use their libs for this ibm_db_dbi and psycopg2.

PROBLEM

I am facing problems with the way the data is inside the arrays, and in formatting the ARRAY1 to the ARRAY2, I don’t know if the problem of formatting ARRAY1 is related to BD API, but whenever I do this intersection I get some error related to ARRAYS.

ARRAY 1

(u'CLIENT1-00', u'SRVDADOS1:OS', u'MICROSOFT WINDOWS SERVER 2008 R2 STANDARD')
(u'CLIENT2-01', u'SRVDADOS2:OS', u'MICROSOFT WINDOWS SERVER 2008 STANDARD')
(u'CLIENT3-01', u'SRVDADOS3:OS', u'MICROSOFT WINDOWS SERVER 2008 STANDARD')
(u'CLIENT4-00', u'SRVDADOS4:OS', u'LINUX CENTOS')
(u'CLIENT5-00', u'SRVDADOS7:OS', u'MAINFRAME')

ARRAY 2

('CLIENT1', 'SRVDADOS1', 'Windows')
('CLIENT2', 'SRVDADOS2', 'Windows')
('CLIENT3', 'SRVDADOS3', 'Windows')
('CLIENT4', 'SRVDADOS4', 'Linux')

UNHINGED OUTPUT

["CLIENTE5","SRVDADOS7","MAINFRAME"]

DETAILING

To COLUMN 1 DO ARRAY1 is the client name field, where the only difference between ARRAY 2 is that there will be a hyphen between them with a numbering ranging from 00 to 01.

To COLUMN 2 DO ARRAY 1 is the field containing the hostname of the server, where the only difference between ARRAY 2 is :OS (I can concatenate in select to add :OS)

To COLUMN 3 DO ARRAY1 is the field that contains the operating system, which I believe will be the biggest problem, because the difference between ARRAY 2 is that it comes along the version of the operating system, I thought to use something similar to LIKE of SQL, for whenever there is the word WINDOWS inside the ARRAY 1 it ignore the rest and look just like WINDOWS, thus being able to compare with the ARRAY 2

Developed to date...

VIEW IN IDEONE.COM

Answer 1

Friend, as your arrays have partially different values you will need to do the comparisons manually, you will not have a python ready method to help you.
If the data that are equal between the 2 arrays were equal you could do so:

array1 = ['um', 'dois', 'três', 'quatro']
array2 = ['um', 'dois']
print(list(set(array1) - set(array2))) 

The output of this command is:

['quatro', 'três']

But in your case, you will have to compare if the element of an array contains the element of the other array, it can be done this way:

array1 = [(u'CLIENT1-00', u'SRVDADOS1:OS', u'MICROSOFT WINDOWS SERVER 2008 R2 STANDARD'),
(u'CLIENT2-01', u'SRVDADOS2:OS', u'MICROSOFT WINDOWS SERVER 2008 STANDARD'),
(u'CLIENT3-01', u'SRVDADOS3:OS', u'MICROSOFT WINDOWS SERVER 2008 STANDARD'),
(u'CLIENT4-00', u'SRVDADOS4:OS', u'LINUX CENTOS'),
(u'CLIENT6-00', u'SRVDADOS6:OS', u'LINUX CENTOS'),
(u'CLIENT7-00', u'SRVDADOS7:OS', u'LINUX CENTOS')]

array2 = [('CLIENT1', 'SRVDADOS1', 'Windows'),
('CLIENT2', 'SRVDADOS2', 'Windows'),
('CLIENT3', 'SRVDADOS3', 'Windows'),
('CLIENT4', 'SRVDADOS4', 'Linux'),
('CLIENT5', 'SRVDADOS5', 'Linux')]

new_result = []
#Procura o que tem no array2 e que não tem no array1
for row2 in array2:
  for row1 in array1:
    if row1[0].upper().__contains__(row2[0].upper()) and row1[1].upper().__contains__(row2[1].upper()) and row1[2].upper().__contains__(row2[2].upper()):
      #Se encontrou então passa pro próximo.
      break
    if row1[0] == array1[len(array1)-1][0] and not(row1[0].upper().__contains__(row2[0].upper()) and row1[1].upper().__contains__(row2[1].upper()) and row1[2].upper().__contains__(row2[2].upper())):
    #Se não encontrou adiciona o valor no new_result 
      new_result.append(row2)

#Procura o que tem no array1 e que não tem no array2
for row1 in array1:
  for row2 in array2:
    if row1[0].upper().__contains__(row2[0].upper()) and row1[1].upper().__contains__(row2[1].upper()) and row1[2].upper().__contains__(row2[2].upper()):
      #Se encontrou então passa pro próximo.
      break
    if row2[0] == array2[len(array2)-1][0] and not(row1[0].upper().__contains__(row2[0].upper()) and row1[1].upper().__contains__(row2[1].upper()) and row1[2].upper().__contains__(row2[2].upper())):
      #Se não encontrou adiciona o valor no new_result
      new_result.append(row1)

print(new_result);

You can test the code above here