Tâche terminée
Temps d'exécution 22 heures
Spécifications
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 |
Répondu
1
Évaluation
Projets
34
76%
Arbitrage
0
En retard
9
26%
Gratuit
2
Évaluation
Projets
395
28%
Arbitrage
155
20%
/
52%
En retard
112
28%
Gratuit
Informations sur le projet
Budget
10 USD
Délais
5 jour(s)