全部订单
规则
类别中的新订单:
200 - 1000 USD
70+ USD
30+ USD
30+ USD
30+ USD
工作已完成
执行时间22 小时
指定
I have a large CSV file that I would like to filter and reduce the data in the file. I am looking for a script or EA that will import a large CSV file and export a smaller CSV file.
The data format looks like this:
| 2015.01.05 | 11:18:56 | 1.52592 | 1.52599 | 2.51 | 4.12 | |
| 2015.01.05 | 11:18:57 | 1.52592 | 1.52599 | 2.14 | 4.12 | |
| 2015.01.05 | 11:18:57 | 1.52592 | 1.52599 | 2.14 | 4.12 | |
| 2015.01.05 | 11:18:57 | 1.52592 | 1.52599 | 1.76 | 4.12 | |
| 2015.01.05 | 11:19:09 | 1.52595 | 1.52602 | 1.12 | 4.01 | |
| 2015.01.05 | 11:19:09 | 1.52596 | 1.52605 | 1.95 | 4.57 | |
| 2015.01.05 | 11:19:11 | 1.52595 | 1.526 | 1.57 | 3.75 | |
| 2015.01.05 | 11:19:12 | 1.52595 | 1.526 | 1.2 | 3.82 | |
| 2015.01.05 | 11:19:12 | 1.52595 | 1.526 | 1.2 | 3.82 | |
| 2015.01.05 | 11:19:20 | 1.52594 | 1.526 | 1 | 3.82 |
The filtering criteria is simple: Select the highest values each minute and remove all the seconds data
The resulting of the data is
| 2015.01.05 | 11:18:00 | 1.52592 | 1.52599 | 2.51 | 4.12 |
| 2015.01.05 | 11:19:00 | 1.52626 | 1.52629 | 8.25 | 7.87 |
反馈
1
等级
项目
34
76%
仲裁
0
逾期
9
26%
空闲
2
等级
项目
395
28%
仲裁
155
20%
/
52%
逾期
112
28%
空闲
项目信息
预算
10 USD
截止日期
5 天