仕事が完了した
実行時間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 日