(I’m very new to coding)
I’m trying to create an excel from a list of dictionaries, the excel should contain
name, email, location.
the dictionary has duplicates of names and emails but locations are one time only used.
i want to build an excel where the name and email have their own row but all the location where the names are used are assigned to a single name
the dict items look like this, and i have ~2000 of them.
dict_list=[{‘UserName’: ‘name’, ‘Email’: ’email@email.com’, ‘location’: ‘x’}
end result should be
name | email@email.com | x ,y,c |
how should i build a list/dict that i can print to excel.
I’ve tried playing around with loop in a loop to check all the values against all the values of the second empty list, so if the entry doesn’t exist, it copies it from the first one.
filtered_List = []
dict_list=[{'UserName': 'name', 'Email': 'email@email.com', 'location': 'x'}]
for user in dict_list:
for filtered_users in filtered_List:
if user['UserName'] == filtered_users['UserName']:
filtered_users['location'].append(user['location'])
continue
else:
filtered_List.append(user)
break
You need to sign in to view this answers
Leave feedback about this