各位大侠,我这有一组数据,格式如下 :
A B
12/16/11 07:10:03 824-S1
12/16/11 07:10:03 824-S2
12/16/11 07:10:03 824-S3
12/16/11 07:14:03 824-S1
12/16/11 07:14:03 824-S3
12/16/11 07:14:03 824-S2
12/16/11 07:18:03 824-S1
12/16/11 07:18:03 824-S3
12/16/11 07:18:03 824-S2
12/16/11 07:22:03 824-S1
12/16/11 07:22:03 824-S2
12/16/11 07:22:03 824-S3
12/16/11 09:06:03 824-S3
12/16/11 09:06:03 824-S2
12/16/11 09:06:03 824-S1
12/16/11 09:10:03 824-S1
12/16/11 09:10:03 824-S3
12/16/11 09:10:03 824-S2
12/16/11 09:14:04 824-S1
12/16/11 09:14:04 824-S2
12/16/11 09:14:04 824-S3
12/16/11 09:18:03 824-S2
12/16/11 09:18:03 824-S3
12/16/11 09:18:03 824-S1
12/16/11 09:22:04 824-S1
12/16/11 09:22:04 824-S2
12/16/11 09:22:04 824-S3
12/16/11 09:26:03 824-S3
12/16/11 09:26:03 824-S2
12/16/11 09:26:03 824-S1
12/16/11 09:30:05 824-S1
12/16/11 09:30:05 824-S2
12/16/11 09:30:05 824-S3
12/16/11 09:34:04 824-S3
12/16/11 09:34:04 824-S2
12/16/11 09:34:04 824-S1
12/16/11 09:38:04 824-S1
12/16/11 09:38:04 824-S3
12/16/11 09:38:04 824-S2
12/16/11 09:42:03 824-S1
12/16/11 09:42:03 824-S2
12/16/11 09:42:03 824-S3
12/16/11 09:46:04 824-S2
12/16/11 09:46:04 824-S1
12/16/11 09:46:04 824-S3
12/16/11 09:50:04 824-S1
12/16/11 09:50:04 824-S2
12/16/11 09:50:04 824-S3
12/16/11 09:54:03 824-S3
12/16/11 09:54:03 824-S1
12/16/11 09:54:03 824-S2
12/16/11 09:58:03 824-S1
12/16/11 09:58:03 824-S3
12/16/11 09:58:03 824-S2
12/16/11 10:02:04 824-S1
12/16/11 10:02:04 824-S3
12/16/11 10:02:04 824-S2
12/16/11 10:06:04 824-S2
12/16/11 10:06:04 824-S1
12/16/11 10:06:04 824-S3
12/16/11 10:10:04 824-S1
12/16/11 10:10:04 824-S2
12/16/11 10:10:04 824-S3A列是时间,B列是值。我现在想做一个筛选,就是如果B列中存在相同的值,同时如果B列值对应的时间连续间隔是3:59秒,4:00秒或4:01秒,那我只保留时间最早的那一个;如果连续间隔超过4:01秒,那我也要保留下一个....举个例子:
就这组据来看,比如前面一段:
12/16/11 07:10:03 824-S1
12/16/11 07:10:03 824-S2
12/16/11 07:10:03 824-S3
12/16/11 07:14:03 824-S1
12/16/11 07:14:03 824-S3
12/16/11 07:14:03 824-S2
12/16/11 07:18:03 824-S1
12/16/11 07:18:03 824-S3
12/16/11 07:18:03 824-S2
12/16/11 07:22:03 824-S1
12/16/11 07:22:03 824-S2
12/16/11 07:22:03 824-S312/16/11 07:10:03 824-S1, 12/16/11 07:14:03 824-S1, 12/16/11 07:18:02 824-S1,
12/16/11 07:22:04 824-S1这几条记录的值都是824-S1,但是时间间隔是3:59秒,4:00,4:01秒,所以我只要保留时间最早的那一条,也就是12/16/11 07:10:03 824-S1条.同样,对于824-S2,824-S3也是取最早的那一条.但是对于下面的
12/16/11 07:22:03 824-S1
12/16/11 07:22:03 824-S2
12/16/11 07:22:03 824-S3
12/16/11 09:06:03 824-S3
12/16/11 09:06:03 824-S2
12/16/11 09:06:03 824-S1
12/16/11 09:10:03 824-S1
12/16/11 09:10:03 824-S3
12/16/11 09:10:03 824-S2
12/16/11 09:14:04 824-S1
12/16/11 09:14:04 824-S2
12/16/11 09:14:04 824-S3里面有这样的数据:
12/16/11 07:22:03 824-S3
12/16/11 09:06:03 824-S3
虽然824-S3一样,但是由于时间间隔不是3:59,4:00,4:01秒,所以我还是需要保留12/16/11 09:06:03 824-S3,那下面的12/16/11 09:06:03 824-S3, 12/16/11 09:10:03 824-S3, 12/16/11 09:14:04 824-S3这三条由于间隔又是4分钟,我就不需要了....不知道上面的叙述清楚没有啊,呵呵
A B
12/16/11 07:10:03 824-S1
12/16/11 07:10:03 824-S2
12/16/11 07:10:03 824-S3
12/16/11 07:14:03 824-S1
12/16/11 07:14:03 824-S3
12/16/11 07:14:03 824-S2
12/16/11 07:18:03 824-S1
12/16/11 07:18:03 824-S3
12/16/11 07:18:03 824-S2
12/16/11 07:22:03 824-S1
12/16/11 07:22:03 824-S2
12/16/11 07:22:03 824-S3
12/16/11 09:06:03 824-S3
12/16/11 09:06:03 824-S2
12/16/11 09:06:03 824-S1
12/16/11 09:10:03 824-S1
12/16/11 09:10:03 824-S3
12/16/11 09:10:03 824-S2
12/16/11 09:14:04 824-S1
12/16/11 09:14:04 824-S2
12/16/11 09:14:04 824-S3
12/16/11 09:18:03 824-S2
12/16/11 09:18:03 824-S3
12/16/11 09:18:03 824-S1
12/16/11 09:22:04 824-S1
12/16/11 09:22:04 824-S2
12/16/11 09:22:04 824-S3
12/16/11 09:26:03 824-S3
12/16/11 09:26:03 824-S2
12/16/11 09:26:03 824-S1
12/16/11 09:30:05 824-S1
12/16/11 09:30:05 824-S2
12/16/11 09:30:05 824-S3
12/16/11 09:34:04 824-S3
12/16/11 09:34:04 824-S2
12/16/11 09:34:04 824-S1
12/16/11 09:38:04 824-S1
12/16/11 09:38:04 824-S3
12/16/11 09:38:04 824-S2
12/16/11 09:42:03 824-S1
12/16/11 09:42:03 824-S2
12/16/11 09:42:03 824-S3
12/16/11 09:46:04 824-S2
12/16/11 09:46:04 824-S1
12/16/11 09:46:04 824-S3
12/16/11 09:50:04 824-S1
12/16/11 09:50:04 824-S2
12/16/11 09:50:04 824-S3
12/16/11 09:54:03 824-S3
12/16/11 09:54:03 824-S1
12/16/11 09:54:03 824-S2
12/16/11 09:58:03 824-S1
12/16/11 09:58:03 824-S3
12/16/11 09:58:03 824-S2
12/16/11 10:02:04 824-S1
12/16/11 10:02:04 824-S3
12/16/11 10:02:04 824-S2
12/16/11 10:06:04 824-S2
12/16/11 10:06:04 824-S1
12/16/11 10:06:04 824-S3
12/16/11 10:10:04 824-S1
12/16/11 10:10:04 824-S2
12/16/11 10:10:04 824-S3A列是时间,B列是值。我现在想做一个筛选,就是如果B列中存在相同的值,同时如果B列值对应的时间连续间隔是3:59秒,4:00秒或4:01秒,那我只保留时间最早的那一个;如果连续间隔超过4:01秒,那我也要保留下一个....举个例子:
就这组据来看,比如前面一段:
12/16/11 07:10:03 824-S1
12/16/11 07:10:03 824-S2
12/16/11 07:10:03 824-S3
12/16/11 07:14:03 824-S1
12/16/11 07:14:03 824-S3
12/16/11 07:14:03 824-S2
12/16/11 07:18:03 824-S1
12/16/11 07:18:03 824-S3
12/16/11 07:18:03 824-S2
12/16/11 07:22:03 824-S1
12/16/11 07:22:03 824-S2
12/16/11 07:22:03 824-S312/16/11 07:10:03 824-S1, 12/16/11 07:14:03 824-S1, 12/16/11 07:18:02 824-S1,
12/16/11 07:22:04 824-S1这几条记录的值都是824-S1,但是时间间隔是3:59秒,4:00,4:01秒,所以我只要保留时间最早的那一条,也就是12/16/11 07:10:03 824-S1条.同样,对于824-S2,824-S3也是取最早的那一条.但是对于下面的
12/16/11 07:22:03 824-S1
12/16/11 07:22:03 824-S2
12/16/11 07:22:03 824-S3
12/16/11 09:06:03 824-S3
12/16/11 09:06:03 824-S2
12/16/11 09:06:03 824-S1
12/16/11 09:10:03 824-S1
12/16/11 09:10:03 824-S3
12/16/11 09:10:03 824-S2
12/16/11 09:14:04 824-S1
12/16/11 09:14:04 824-S2
12/16/11 09:14:04 824-S3里面有这样的数据:
12/16/11 07:22:03 824-S3
12/16/11 09:06:03 824-S3
虽然824-S3一样,但是由于时间间隔不是3:59,4:00,4:01秒,所以我还是需要保留12/16/11 09:06:03 824-S3,那下面的12/16/11 09:06:03 824-S3, 12/16/11 09:10:03 824-S3, 12/16/11 09:14:04 824-S3这三条由于间隔又是4分钟,我就不需要了....不知道上面的叙述清楚没有啊,呵呵
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货