Challenge: Average Metrics Across Taxi Types
Great! As for now, we have our dataset cleared from abnormally long rides and rides with ending time preceded starting. As we investigated, it happened because of misusage of 12 and 24-hour formats.
Let's try to find out some interesting insights from this dataset.
Swipe to start coding
- Apply
.total_seconds()
function toduration
column usingmap
andlambda
functions. - Group observations by taxi type (
vendor_id
column). Then, choose columnsdist_meters
,duration
, and calculate mean. Then apply functionavg_m
todist_meters
andavg_dur
toduration
. The functions are defined in the code.
Løsning
Tak for dine kommentarer!
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Opsummér dette kapitel
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 3.23
Challenge: Average Metrics Across Taxi Types
Stryg for at vise menuen
Great! As for now, we have our dataset cleared from abnormally long rides and rides with ending time preceded starting. As we investigated, it happened because of misusage of 12 and 24-hour formats.
Let's try to find out some interesting insights from this dataset.
Swipe to start coding
- Apply
.total_seconds()
function toduration
column usingmap
andlambda
functions. - Group observations by taxi type (
vendor_id
column). Then, choose columnsdist_meters
,duration
, and calculate mean. Then apply functionavg_m
todist_meters
andavg_dur
toduration
. The functions are defined in the code.
Løsning
Tak for dine kommentarer!
Awesome!
Completion rate improved to 3.23single