Trabajo finalizado
Plazo de ejecución 22 horas
Tarea técnica
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 |
Han respondido
1
Evaluación
Proyectos
34
76%
Arbitraje
0
Caducado
9
26%
Libre
2
Evaluación
Proyectos
395
28%
Arbitraje
155
20%
/
52%
Caducado
112
28%
Libre
Información sobre el proyecto
Presupuesto
10 USD
Plazo límite de ejecución
5 día(s)