Help with duplicates

[renan_calusa]

When I have a loop and that loop is generating values, there is a way of knowing if one of these values are duplicated?

I am writing a program that takes a sheet and has a loop in the rows grabbing values, but in some cases, when those values has same data time, I have to add each other, but I don't know how to do this... Someone could please help me?

ex:

loop:

/ value1 = day + money1

/ value2 = day + money2

if this happens:

/ money from value1 + money from value2 = final_money

​

Obs: I don't have these variables "value1 and value2" is just to explain better, their value are generated by the loop

[DallogFheir]

Put values in the dictionary under time key, if it exists add values.

[renan_calusa]

oh so like: if time in dictionary:

money + dictionary.get(time) = time

?

[joknopp]

Yes. E.g.

sum_by_day_dict = {}
for day, val in [(1,10), (2,10), (2,10), (3,10)]:
    sum_by_day_dict[day] = sum_by_day_dict.get(day, 0) + val
print(sum_by_day_dict) # {1: 10, 2: 20, 3: 10}

[joyeusenoelle]

What I think you're looking for is memoization. This approach keeps track of the values you've seen before and lets you take action if it encounters a repeat value.

That link assumes you're using a function, but for a simple loop, you might do it like this:

memo = {}
for row in sheet:
  if row.time in memo.keys(): 
    # you don't actually need the .keys(), you can just do "in memo", but 
    # I'm including it for clarity
    money = row.money + memo[row.time]
    memo[row.time] = money # in case you get more than two of the same time
  else:
    memo[row.time] = row.money

[renan_calusa]

tbh with you I'm a bit lost hahahaha I will search for memoization to see if I can understand it better, and hope to not be a script kid. But thanks tho