🚧 Challenge Chat: Considering the speed data

Uber Nairobi Ambulance Perambulation Challenge

Helping Kenya

$6 000 USD

Completed (~5 years ago)

Skills you will learn

Prediction

1091 joined

330 active

Info Data Chat Leaderboard

Start

Sep 17, 20

Jan 24, 21

Reveal

Jan 24, 21

omarhzm

Considering the speed data

Help · 10 Dec 2020, 01:55 · 6

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

Discussion 6 answers

ellyN_tz

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

10 Dec 2020, 06:13

Upvotes 0

josh2297

University of nigeria nsukka

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

18 Dec 2020, 13:50

Upvotes 0

omarhzm

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

replied to josh229718 Dec 2020, 14:51

Upvotes 0

mmohamed

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

18 Dec 2020, 13:57

Upvotes 0

omarhzm

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

replied to mmohamed18 Dec 2020, 14:52

Upvotes 0

mmohamed

thank you

replied to omarhzm18 Dec 2020, 18:34

Upvotes 0

Join the largest network for
data scientists and AI builders

About FAQs

Status