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
Tack för dina kommentarer!
single
Fråga AI
Fråga AI
Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal
Awesome!
Completion rate improved to 3.23
Challenge: Average Metrics Across Taxi Types
Svep för att visa menyn
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
Tack för dina kommentarer!
Awesome!
Completion rate improved to 3.23single