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.
Solution
Merci pour vos commentaires !
single
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
Résumer ce chapitre
Expliquer le code dans file
Expliquer pourquoi file ne résout pas la tâche
Awesome!
Completion rate improved to 3.23
Challenge: Negative Trip Duration
Glissez pour afficher le 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.
Solution
Merci pour vos commentaires !
single