How can I compare two lists and m python. - Capture the different value

Question

I am trying to compare two lists in python, one of them is a response from a rest request that I stored in a list and the other is obtained through a csv file. I need to compare them and capture the values that do not exist in the first list that is obtained from the csv that is smaller than the second list that is the response from my database.

Just to summarize, the values that are in the csv are checked to ensure that everything has been stored correctly and exists in the database.

Does this answer your question? [How to compare a list of lists/sets in python?](https://stackoverflow.com/questions/6105777/how-to-compare-a-list-of-lists-sets-in-python) — Javier Huerta, Nov 02 '21 at 15:57

Javier Huerta · Answer 1 · 2021-11-03T12:38:05.800

1

For this specific case you can do something like this,

difference = list(set(mheu_tradeCash) - set(listAccountId))

[print(f"The counterparty {i} does not exist in CDW") for i in difference]

edited Nov 03 '21 at 12:38

answered Nov 02 '21 at 14:57

Javier Huerta

118
11

1

Thanks for the reply, this helped. – Bruno Lorena Nov 02 '21 at 15:11
@BrunoLorena Why you didn't consider this as the correct answer? As here there is no need to use any external library, and this answer exactly what you needed to accomplish. – Javier Huerta Dec 01 '21 at 17:04

Kramer84 · Accepted Answer · 2021-11-05T13:17:12.147

1

If you have numpy installed, you can also use the setdiff1d function, which returns the unique values in the first 1D numpy array that are not in the second array.

import numpy as np
difference = np.setdiff1d(np.array(mheu_tradeCash), np.array(listAccountId))

The conversion to numpy arrays may not be necessary.

edited Nov 05 '21 at 13:17

answered Nov 03 '21 at 12:58

Kramer84

47
6

How can I compare two lists and m python. - Capture the different value

2 Answers2