Challenge: Negative Trip Duration
Well, in the last chapter you might notice that for the first 10 rows all the trips started before 13 hours (1 p.m.), and ended close to 00 hours. What if it's just AM/PM missing? Let's try to check it.
How can it be checked? Well, in our dataframe we also have trip_duration column representing the trip duration in seconds. What if we just add this duration to pickup_datetime and compare it with dropoff_datetime?
Please note, that you will need to use
timedeltaobjects in this task since you want to 'shift' yourdatetimeobject for a certain time. To convert column totimedeltatype usepd.to_timedelta()function with two arguments: column you want to convert, andunit- dimension used ('S' for seconds, 'm' for minutes, and so on).
Swipe to start coding
- Convert
trip_durationcolumn intotimedeltatype. Do not forget thattrip_durationmeasures in seconds. - Create new column
dropoff_calculatedas the result of addingpickup_datetimeandtrip_duration. - Print first 10 rows for updated dataframe.
Please, do not change column names in square brackets.
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
Awesome!
Completion rate improved to 3.23
Challenge: Negative Trip Duration
Desliza para mostrar el menú
Well, in the last chapter you might notice that for the first 10 rows all the trips started before 13 hours (1 p.m.), and ended close to 00 hours. What if it's just AM/PM missing? Let's try to check it.
How can it be checked? Well, in our dataframe we also have trip_duration column representing the trip duration in seconds. What if we just add this duration to pickup_datetime and compare it with dropoff_datetime?
Please note, that you will need to use
timedeltaobjects in this task since you want to 'shift' yourdatetimeobject for a certain time. To convert column totimedeltatype usepd.to_timedelta()function with two arguments: column you want to convert, andunit- dimension used ('S' for seconds, 'm' for minutes, and so on).
Swipe to start coding
- Convert
trip_durationcolumn intotimedeltatype. Do not forget thattrip_durationmeasures in seconds. - Create new column
dropoff_calculatedas the result of addingpickup_datetimeandtrip_duration. - Print first 10 rows for updated dataframe.
Please, do not change column names in square brackets.
Solución
¡Gracias por tus comentarios!
single