Challenge: Fixing the Issues
Well, in the last chapter you saw, that there were only two rides with negative durations where minutes in both columns were different. But if paid your attention to seconds, you might notice, that that were the minute ending and starting (59 seconds, and 00 respectively). It means that all the inconsistencies can be interpreted as misuages of 12 and 24-hour formats.
Since we have investigated the real reason for the issue, we can now fix it! Let me remind you of one of the ways to replace values in dataframe based on some condition - .where function.
1df['col_name'].where(~(condition), inplace = True, other = values_to_replace)
Using the following approach all the values in col_name will be replaced with values_to_replace if (condition) is True.
Swipe to start coding
- For all the trips with negative
durationadd 12 hours todropoff_datetimecolumn. - Calculate column
durationagain. - Print first 5 rows of updated
df.
Løsning
Takk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Awesome!
Completion rate improved to 3.23Challenge: Fixing the Issues
Sveip for å vise menyen
Well, in the last chapter you saw, that there were only two rides with negative durations where minutes in both columns were different. But if paid your attention to seconds, you might notice, that that were the minute ending and starting (59 seconds, and 00 respectively). It means that all the inconsistencies can be interpreted as misuages of 12 and 24-hour formats.
Since we have investigated the real reason for the issue, we can now fix it! Let me remind you of one of the ways to replace values in dataframe based on some condition - .where function.
1df['col_name'].where(~(condition), inplace = True, other = values_to_replace)
Using the following approach all the values in col_name will be replaced with values_to_replace if (condition) is True.
Swipe to start coding
- For all the trips with negative
durationadd 12 hours todropoff_datetimecolumn. - Calculate column
durationagain. - Print first 5 rows of updated
df.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
single
