I have a Dataframe as follows:
A B C 1 ES221319234839157C LIST 2 ES227701354598562I LIST 3 A123123123123123123 LIST 4 B123123123123123123 LIST
There is also a list:
list_a = ['ES221319234839157C','ES227701354598562I','ES221050819256013H','CL22044337970892RG']
I need to match column B in a Dataframe with list_a, return the matching row in the Dataframe, and return the value in list_a that does not match.Any expert know how to solve it?