'How to compare between lists for a partial match and create a new list from both list
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']
Solution 1:[1]
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)
Solution 2:[2]
This assumes that you have - (underscore) in your strings:
result = []
for a in accounts:
if any(b.startswith(a.split('-')[0]) for b in stats):
result.append(a)
print("Found:", result)
print("Not Found:", list(set(accounts) - set(result)))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | |
| Solution 2 | SM1312 |
