Script to add column based on historical data

Hi, I've been trying to add automatic column with py script, but without a success. So the idea is to lets say i have a table like below:         And the idea is to create a addit...