2009-11-12-02 570.6 2009-11-13-07 608 2009-12-24-00 392 2009-12-24-00 395 2010-02-07-22 544 2010-02-18-01 577.7 2010-03-20-14 414.6 2010-04-11-22 609.8 2010-05-24-16 581.2 2010-06-22-22 562.5 2010-07-23-22 578 2010-07-23-22 601.7 2010-07-23-22 607.1 2010-07-23-22 611.5 2010-07-23-23 640.6 2010-11-30-03 470 2011-03-10-17 510.6 2011-03-20-15 321 2011-04-03-14 551.7 2011-04-05-04 552.4 2011-05-10-15 544.6 2011-08-02-19 528.9 2011-08-11-01 496.8
如果第一列出现重复的时候,只取第一次出现的行。所以变为:
2009-11-12-02 570.6 2009-11-13-07 608 2009-12-24-00 392
2010-02-07-22 544 2010-02-18-01 577.7 2010-03-20-14 414.6 2010-04-11-22 609.8 2010-05-24-16 581.2 2010-06-22-22 562.5 2010-07-23-22 578
2010-07-23-23 640.6 2010-11-30-03 470 2011-03-10-17 510.6 2011-03-20-15 321 2011-04-03-14 551.7 2011-04-05-04 552.4 2011-05-10-15 544.6 2011-08-02-19 528.9 2011-08-11-01 496.8
谢谢啦!!
|