iso_selected is data set that has the names (the value of iso3num is not correct):
| iso3 | iso3num | country | countrylong |
|---|---|---|---|
| ITA | 32 | Italy | Italy |
Gravity data set that I want to merge it with iso_selected:
| iso3_o | iso3_d | iso3num_o | iso3num_d | trade_o | trade_d |
|---|---|---|---|---|---|
| ITA | SPA | 32 | 43 | 12512 | 12512 |
I would like to have the country names for iso3_o and iso3_d. Can I do that without merging two data sets twice?
I would like to have following dataset:
| iso3_o | iso3_d | country_o | country_d | trade_o | trade_d |
|---|---|---|---|---|---|
| ITA | SPA | ITALY | SPAIN | 12512 | 12512 |
I could not see any answer to this. The important thing is that I would not like to merge twice.
