I have two following dataframes df1 and df2:
df1:
| ID | number | Result | 
|---|---|---|
| 13256 | 99 | NaN | 
| 15556 | 100 | NaN | 
| 14556 | 100 | NaN | 
df2:
| 13256 | 15556 | 14556 | number | 
|---|---|---|---|
| 12 | 1 | 4 | 99 | 
| 10 | 2 | 5 | 100 | 
| 11 | 3 | 6 | 101 | 
Basically, I want to get the values from df2 where values in the number columns match and the name of the column in df2 matches the row value of ID column in df1. The values I get, I want to add them in column Result in df1.
So the expected output is:
| ID | number | Result | 
|---|---|---|
| 13256 | 99 | 12 | 
| 15556 | 100 | 2 | 
| 14556 | 100 | 5 | 
I tried something like this but still couldn't succeed it:
    for index, row in df1.iterrows():
        if ((row['ID'] in df2.columns) and (df2.loc[0, 'number'] == row['number'])):
    
            value = row['number']
            print(value)
I appreciate any help!
