ID | money | house |
a01 | 1200 | 75 |
a02 | 2200 | 89 |
a03 | 3300 | 99 |
B数据集市家庭中个人的调查内容,如下
ID | sex | race | age |
a01 | 1 | 1 | 34 |
a01 | 2 | 2 | 53 |
a01 | 1 | 1 | 12 |
a02 | 1 | 1 | 34 |
a02 | 2 | 3 | 34 |
a03 | 1 | 1 | 21 |
a04 | 2 | 1 | 76 |
我想把A数据集的内容给添加到B数据集中,按照ID进行匹配,形成C数据集,如下
ID | money | house | sex | race | age |
a01 | 1200 | 75 | 1 | 1 | 34 |
a01 | 1200 | 75 | 2 | 2 | 53 |
a01 | 1200 | 75 | 1 | 1 | 12 |
a02 | 2200 | 89 | 1 | 1 | 34 |
a02 | 2200 | 89 | 2 | 3 | 34 |
a03 | 3300 | 99 | 1 | 1 | 21 |
a04 | 2 | 1 | 76 |
请问如何操作?请高手指点,谢谢