现有两列数据,第一列数据如下:
fdcd | Stamager |
1 | 2004/2/27 |
1 | 2005/10/29 |
1 | 2010/1/16 |
11 | 2004/6/30 |
11 | 2006/5/24 |
21 | 2006/11/15 |
21 | 2010/1/16 |
31 | 2009/1/5 |
31 | 2010/2/4 |
41 | 2007/10/9 |
51 | 2009/6/26 |
61 | 2009/12/18 |
1001 | 2004/2/28 |
1001 | 2010/2/4 |
| |
| |
| |
| |
| |
| |
第二列数据如下:
Fdcd | Repdt | Totnetast |
000001 | 2003-12-31 | 3.08E+09 |
000001 | 2004-06-30 | 3.03E+09 |
000001 | 2004-12-31 | 2.8E+09 |
000001 | 2005-06-30 | 2.06E+09 |
000001 | 2005-12-31 | 2.03E+09 |
000001 | 2006-06-30 | 2.17E+09 |
000001 | 2006-12-31 | 2.32E+09 |
000001 | 2007-06-30 | 1.08E+10 |
000001 | 2007-12-31 | 1.28E+10 |
000001 | 2008-06-30 | 9.62E+09 |
000001 | 2008-12-31 | 6.92E+09 |
000001 | 2009-06-30 | 1.21E+10 |
000001 | 2009-12-31 | 1.18E+10 |
000001 | 2010-06-30 | 1.03E+10 |
000001 | 2010-12-31 | 1.06E+10 |
000001 | 2011-06-30 | 1.06E+10 |
000001 | 2011-12-31 | 8.68E+09 |
| | |
000011 | 2005-06-30 | 9.57E+08 |
000011 | 2005-12-31 | 7.04E+08 |
000011 | 2006-06-30 | 1.15E+09 |
我的目标是,将第二个数据表中变量Totnetas数据合并到第一个数据表中。要求是按照基金以及相应的stamager之前最近的半年公布的Repdt基金资产净值数据来合并