Challenge: Is this Common Issue?
In the previous chapter, we found out that issues with negative durations happened because of misusage of 12-h and 24-h formats. We printed the first 10 rows and saw that in all of these rides dropoff_calculated has the same minute and second (accurate to 1 second), but hours differ by 12.
Let's continue our investigation!
Swipe to start coding
- Filter the observations in
dfdataframe to only with negativeduration. Save it indf_negvariable. - Iterate over rows of
df_ned. If minute indropoff_datetimeanddropoff_calculatedis not the same, you need to print this row. - Within the same
forloop count number of rows having an hour indropoff_datetimegreater or equal than 12.
Lösung
Danke für Ihr Feedback!
single
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen
Awesome!
Completion rate improved to 3.23
Challenge: Is this Common Issue?
Swipe um das Menü anzuzeigen
In the previous chapter, we found out that issues with negative durations happened because of misusage of 12-h and 24-h formats. We printed the first 10 rows and saw that in all of these rides dropoff_calculated has the same minute and second (accurate to 1 second), but hours differ by 12.
Let's continue our investigation!
Swipe to start coding
- Filter the observations in
dfdataframe to only with negativeduration. Save it indf_negvariable. - Iterate over rows of
df_ned. If minute indropoff_datetimeanddropoff_calculatedis not the same, you need to print this row. - Within the same
forloop count number of rows having an hour indropoff_datetimegreater or equal than 12.
Lösung
Danke für Ihr Feedback!
single