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 todurationcolumn usingmapandlambdafunctions. - Group observations by taxi type (
vendor_idcolumn). Then, choose columnsdist_meters,duration, and calculate mean. Then apply functionavg_mtodist_metersandavg_durtoduration. The functions are defined in the code.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Resumir este capítulo
Explicar el código en file
Explicar por qué file no resuelve la tarea
Awesome!
Completion rate improved to 3.23
Challenge: Average Metrics Across Taxi Types
Desliza para mostrar el menú
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 todurationcolumn usingmapandlambdafunctions. - Group observations by taxi type (
vendor_idcolumn). Then, choose columnsdist_meters,duration, and calculate mean. Then apply functionavg_mtodist_metersandavg_durtoduration. The functions are defined in the code.
Solución
¡Gracias por tus comentarios!
single