I have several lists that I would like to match and operate values among them. For simplicity assume I have these two lists:
l1 = Transpose[{Range[1980, 2010, 1], Range[31]}]
l2 = {{1990, 1,100}, {2000, 2,200}, {2010, 3,300}}
I would like to divide the third column of l2 by the second column in l1 matching the year in both lists.
I should obtain:
l3 = {{1990, 1, 100/11}, {2000, 2, 200/21}, {2010, 3, 300/31}}
How can I set a function to do that?