Hi all,
I'm not too familiar with using gravity data, so I am not sure what my dataset should look like.
I currently have two datasets. Dataset 1 shows a characteristic (var_1) for a given country in each of 3 years.
Dataset 1:
Dataset 2 is the gravity dataset and shows bilateral variables for pairs of countries in each of the years.
Dataset 2:
I'm not sure how the two datasets will merge.
In dataset 1, ALB takes the value x1 for var_1 in 2017. In the merged dataset, will this value x1 be repeated in every row that concerns ALB and 2017?
e.g (This is my thoughts)
Is this what the merged dataset will be?
I hope I have managed to explain this okay
Any help is much appreciated,
Thanks!
I'm not too familiar with using gravity data, so I am not sure what my dataset should look like.
I currently have two datasets. Dataset 1 shows a characteristic (var_1) for a given country in each of 3 years.
Dataset 1:
| Country | Year | var_1 | ... |
| ALB | 2017 | x1 | ... |
| ALB | 2018 | x2 | ... |
| ALB | 2019 | x3 | ... |
| ... | |||
| ZIM | 2017 | xn-2 | ... |
| ZIM | 2018 | xn-1 | ... |
| ZIM | 2019 | xn | ... |
Dataset 2:
| Country | Partner | Year | Bilateral Variable 1 | ... |
| ALB | ARM | 2017 | k1 | |
| ALB | AUS | 2017 | k2 | |
| ALB | AZE | 2017 | k3 | |
| ... | ||||
| ZIM | UGA | 2019 | ku | |
| ZIM | UZB | 2019 | kv | |
| ZIM | ZAM | 2019 | kw |
In dataset 1, ALB takes the value x1 for var_1 in 2017. In the merged dataset, will this value x1 be repeated in every row that concerns ALB and 2017?
e.g (This is my thoughts)
| Country | Partner | Year | Bilateral Variable 1 | var_1 | |
| ALB | ARM | 2017 | k1 | x1 | |
| ALB | AUS | 2017 | k2 | x1 | |
| ALB | AZE | 2017 | k3 | x1 | |
| ALB | BEL | 2017 | k4 | x1 | |
| ALB | BLR | 2017 | k5 | x1 | |
| ALB | BRA | 2017 | k6 | x1 | |
| ... | ... | ... | ... |
I hope I have managed to explain this okay
Any help is much appreciated,
Thanks!
