I need to compare between two lists for a partial match and then create a new list based on the matching items. My current output is empty. Thanks in advance.
accounts = ['0x1212 - staff1', '0x65gs - tech01', '0x43nd - staff3', '0x89ng - tech02']
stats = ['0x1212 - (23.90)', '0x43nd - (4.70)', '0x342r - (3.76)', '0x323f - (2.76)']
data = []
for b in stats:
if any(a.startswith(b) for a in accounts):
data.append(b)
print (data)
Current Output:
[]
Needed Output:
Found: ['0x1212 - (23.90) - staff1, 0x43nd - (4.70) - staff3'] Not Found: ['0x65gs - tech01', '0x89ng - tech02']
Advertisement
Answer
You seem to only want to look at the first 6 characters of each account. Use this:
found = []
not_found = []
for b in stats:
for a in accounts:
if a[:6] == b[:6]:
found.append(b+a[6:])
break
else:
not_found.append(a)
print(found)
print(not_found)