DF1:
| Month | Region | OBS.COUNT | AVG.TEMP |
|---|---|---|---|
| 1 | South | 51 | |
| 2 | West | 41 | |
| 3 | South | 70 | |
| 4 | South | 59 | |
| ... | ... | ... | |
| 12 | South | 59 |
DF2:
| Month | Region | AVG.TEMP |
|---|---|---|
| 1 | South | 42 |
| 1 | West | 41 |
| 2 | South | 29 |
| 2 | West | 54 |
| 3 | South | 62 |
| 3 | West | 23 |
| ... | ... | ... |
| 12 | South | 68 |
| 12 | West | 54 |
I have two data frames similar to those shown about and am looking to pull the AVG.TEMP from DF2 into the AVG.TEMP column in DF1 that corresponds with that data in DF1. For example, since the avg temp in the south in January is 42, then 42 should be added to the AVG.TEMP column in DF1 in the first row. Ultimately, the goal would be a data set like this:
Goal Dataset:
| Month | Region | OBS.COUNT | AVG.TEMP |
|---|---|---|---|
| 1 | South | 51 | 42 |
| 2 | West | 41 | 54 |
| 3 | South | 70 | 62 |
| 4 | South | 59 | |
| ... | ... | ... | |
| 12 | South | 59 | 69 |
