Hello everyone,
I am facing the following issue :
I have a dataset with dyadic information such as bilateral migration flows and I have monadic characteristics from the countries of origin.
I renamed these specific monadic variables varname_o and now I want to generate variables related to the destination countries varname_d.
My current dataset as this kind of shape :
And I am trying to obtain a dataset of this shape :
If anyone has any clue to help me solve this issue, I would be very grateful.
Thank you!
Raphaƫl
I am facing the following issue :
I have a dataset with dyadic information such as bilateral migration flows and I have monadic characteristics from the countries of origin.
I renamed these specific monadic variables varname_o and now I want to generate variables related to the destination countries varname_d.
My current dataset as this kind of shape :
Orig | Dest | Migration flow | varname1_o | varname2_o |
A | B | 12 | 100 | 200 |
A | C | 15 | 100 | 200 |
B | A | 2 | 50 | 100 |
C | A | 3 | 75 | 150 |
And I am trying to obtain a dataset of this shape :
Orign | Dest | Migration_flow | varname1_o | varname2_o | varname1_d | varname2_d |
A | B | 12 | 100 | 200 | 50 | 100 |
A | C | 15 | 100 | 200 | 75 | 150 |
B | A | 2 | 50 | 100 | 100 | 200 |
C | A | 3 | 75 | 150 | 100 | 200 |
Thank you!
Raphaƫl
Comment