Organizing Data in Dictionary

[Ranjirock]

Hello All,

I'm trying to pull the data from excel and organize it inside the dictionary for further usage. some how I'm failing, please help.

Input File is like:
No Ticket User
1 P12334 Raju
2 P12335 Usha
3 P12336 Suri
4 P12337 Ben
5 P12338 Raju
6 P12339 Roy
7 P12340 Ben
8 P12341 Raju
9 P12342 Roy
10 P12343 Usha
11 P12344 Ben
12 P12345 Roy
13 P12346 Usha

I need output as:
In a dictionary
Raju - P12334, P12337, P12338
Ben - P12340, P12343
Usha - P12350, P12351, P12327

But I'm not getting it, the dictionary is having only one ticket information for each user (key). I'm unable to append or add values. Could you please help?

1 2 3 4 5 6 7 8 9 10

values = {} for i in range(sheet.nrows):     row = sheet.row_values(i)     print(row[2])     values[row[2]]={         'Backlogs':row[1]     }   #pprint.pprint(values) print(values)

[woooee]

There is no reason to have "Backlogs" in the dictionary if it is the one and only entry. To have more than on entry per user, use a list.

1 2 3 4 5 6 7 8 9 10 11

values = {} for i in range(sheet.nrows):     row = sheet.row_values(i)     this_value=row[2]  ## save looking up row[2] multiple times     print(this_value)     if this_value not in values:         values[this_value] = []     values[this_value].append(row[1])    #pprint.pprint(values) print(values)

[perfringo]

Another possibility is to use .setdefault method (instead of rows 6-8):

1	values.setdefault(this_value, []).append(row[1])

[Ranjirock]

Thank you both of you. It worked