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.
Ratkaisu
Kiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Awesome!
Completion rate improved to 3.23
Challenge: Is this Common Issue?
Pyyhkäise näyttääksesi valikon
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.
Ratkaisu
Kiitos palautteestasi!
single