Simple Script or EA to filter a CSV file

İş tamamlandı

Tamamlanma süresi: 22 saat

İş Gereklilikleri

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

Dosyalar:

ZIP
CSV.zip
1.4 Mb

Yanıtlandı

1
Geliştirici 1
Derecelendirme
(20)
Projeler
34
76%
Arabuluculuk
0
Süresi dolmuş
9
26%
Serbest
2
Geliştirici 2
Derecelendirme
(195)
Projeler
395
28%
Arabuluculuk
155
20% / 52%
Süresi dolmuş
112
28%
Serbest

Proje bilgisi

Bütçe
10 USD
Son teslim tarihi
5 gün