大佬们我有这样一组数据,现在只想保留每一年中最后日期的数值,有没有好的方法啊,孩子已经试了了好多办法了
Stkcd Shrchgdt Shrtyp Nshrttl Nshrsmsshile
0 2 2003-05-22 40000 676899970.0 0
1 2 2003-05-23 3000 1353799940.0 0
2 2 2003-05-30 40000 1365405657.0 0
3 2 2003-06-30 40000 1383386596.0 0
4 2 2003-08-31 40000 1385680062.0 0
5 2 2003-09-30 40000 1394795949.0 0
6 2 2003-12-31 40000 1395849444.0 0
7 2 2004-03-31 40000 1501283209.0 0
8 2 2004-04-30 40000 1515751914.0 0
9 2 2004-05-26 3000 2273627871.0 0
10 2 2005-06-17 40000 2273964091.0 0
11 2 2005-06-28 40000 2273980474.0 0
12 2 2005-06-29 3000 3410946136.0 0
13 2 2005-06-30 40000 3410971780.0 0
14 2 2005-09-30 40000 3411020331.0 0
15 2 2005-12-02 7000 3720527606.0 2415578
16 2 2005-12-31 40000 3722687670.0 2415578
17 2 2006-03-31 40000 3936964741.0 2415578
18 2 2006-06-30 40000 3969898751.0 2415578
19 2 2006-09-04 90000 3969898751.0 2415578
20 2 2006-12-06 9 3969898751.0 2415578
21 2 2006-12-22 60 4369898751.0 2415578