Uber Nairobi Ambulance Perambulation Challenge
$6,000 USD
Can you use ML to create an optimised ambulance deployment strategy in Nairobi?
979 data scientists enrolled, 330 on the leaderboard
ConstructionTransportationHealthPredictionStructuredLocation
Kenya
17 September 2020—24 January 2021
Ends in 7 days
Considering the speed data
published 10 Dec 2020, 01:55

was wondering how can i map a 3M rows (speed data) to 6K rows (locations) in a reasonable time?

Hellooooow there friend i’m looking for team so we can do this stuff together

If you are referring to the speed data from Uber then I think one of the ways to try to merge them is to take the average for every three hours for each of the quarterly season. It may be demanding but I think it should work

i don't think looping over 3M rows is a good idea especially when it's a subset of another 6k loop

how did you map the osm way id to the segment id in the competition data?

i didn't, i only used this function to get the road names and ids https://zindi.africa/competitions/uber-nairobi-ambulance-perambulation-challenge/discussions/4276