I have the following data frame named df1:
| CITY | V1 | V2 | 
|---|---|---|
| A | 2 | 0 | 
| B | 6 | 4 | 
| C | 9 | 2 | 
| D | 8 | 2 | 
| E | 9 | 5 | 
And also I have the following dataframe named df2:
| CITY | X | 
|---|---|
| C | 45 | 
| E | 9 | 
How can I add the information from df2 to df1 based on city name? The desired outcome is:
| CITY | V1 | V2 | X | 
|---|---|---|---|
| A | 2 | 0 | NA | 
| B | 6 | 4 | NA | 
| C | 9 | 2 | 45 | 
| D | 8 | 2 | NA | 
| E | 9 | 5 | 9 | 
