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.
Soluzione
Grazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 3.23
Challenge: Negative Trip Duration
Scorri per mostrare il menu
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.
Soluzione
Grazie per i tuoi commenti!
single