请教一下大家,对于如下的面板数据,如何将样本期(time1~time6)中变量xyz取值全部为空值的对象(bbb),将其变量xyz取值在其整个样本期(time1~time6)中全部替换为123。
而对于样本期不全为空值的对象ccc它的变量xyz取值不做任何改变。即达到下面红色字体表格的补缺效果。
非常感谢啦^_^
number | time | Name | xyz |
1 | 1 | aaa | 516 |
1 | 2 | aaa | 892 |
1 | 3 | aaa | 439 |
1 | 4 | aaa | 762 |
1 | 5 | aaa | 395 |
1 | 6 | aaa | 109 |
2 | 1 | bbb | |
2 | 2 | bbb | |
2 | 3 | bbb | |
2 | 4 | bbb | |
2 | 5 | bbb | |
2 | 6 | bbb | |
3 | 1 | ccc | |
3 | 2 | ccc | |
3 | 3 | ccc | |
3 | 4 | ccc | |
3 | 5 | ccc | 897 |
3 | 6 | ccc | 563 |
number | time | Name | abc |
1 | 1 | aaa | 516 |
1 | 2 | aaa | 892 |
1 | 3 | aaa | 439 |
1 | 4 | aaa | 762 |
1 | 5 | aaa | 395 |
1 | 6 | aaa | 109 |
2 | 1 | bbb | 123 |
2 | 2 | bbb | 123 |
2 | 3 | bbb | 123 |
2 | 4 | bbb | 123 |
2 | 5 | bbb | 123 |
2 | 6 | bbb | 123 |
3 | 1 | ccc | |
3 | 2 | ccc | |
3 | 3 | ccc | |
3 | 4 | ccc | |
3 | 5 | ccc | 897 |
3 | 6 | ccc | 563 |