unicef / magicbox-open-api

An API to serve open data aggregated by administrative boundaries
http://magicboxopenapi.azurewebsites.net/docs
BSD 3-Clause "New" or "Revised" License
25 stars 9 forks source link

Write script to tally journeys and people in mobility #36

Closed mikefab closed 6 years ago

mikefab commented 6 years ago

Current file names are 2015-02-03.csv. Example file contains: id_origin,id_destination,journeys,people col_0_44_2_santiblanko,col_0_44_2_santiblanko,266,265 col_0_44_2_santiblanko,col_0_44_5_santiblanko,5,5

Script should tally journeys and people and rename file to: 2015-02-03^5435-987.csv

mikefab commented 6 years ago

tallymobility.sh looks good. Might be useful to add an intro at the top of the file and a section in the README. We can add that as a separate issue.