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.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Summarize this chapter
Explain the code in file
Explain why file doesn't solve the task
Awesome!
Completion rate improved to 3.23
Challenge: Average Metrics Across Taxi Types
Swipe to show menu
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.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 3.23single