I merged 2 lists and created new list which is having both lists data but im struck at cleaning my nested list.I need to remove duplicates keys and merge values for that duplicate key
list1 = [('ID1', 'Name'), ('ID2, 'Name'), ('ID2', 'team')]
expected output should be:
[('ID1', 'Name'), ('ID2, 'Name,team')]
Here is the data as a dictionary which may be a bit easier to work with:
list1 = [('ID1', 'Name'), ('ID2', 'Name'), ('ID2', 'team')]
# create a dict with empty lists as keys
pivot = {i[0]: [] for i in list1}
for i in list1:
# set the value of the first item key to the second item
pivot[i[0]].append(i[1])
# converted to list of tuples, could be faster without doing the conversion
pivot_tuples = [(k, v) for k, v in pivot.items()]
print(f'dict: {pivot}')
print(f'tupl: {pivot_tuples}')
Output:
dict: {'ID1': ['Name'], 'ID2': ['Name', 'team']}
tupl: [('ID1', ['Name']), ('ID2', ['Name', 'team'])]
