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øsning
Tak for dine kommentarer!
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Awesome!
Completion rate improved to 3.23
Challenge: Is this Common Issue?
Stryg for at vise menuen
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øsning
Tak for dine kommentarer!
single