Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Challenge: Fixing the Issues | Working with Dates and Times in pandas
Dealing with Dates and Times in Python

Sveip for å vise menyen

book
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.

1
df['col_name'].where(~(condition), inplace = True, other = values_to_replace)
copy

Using the following approach all the values in col_name will be replaced with values_to_replace if (condition) is True.

Oppgave

Swipe to start coding

  1. For all the trips with negative duration add 12 hours to dropoff_datetime column.
  2. Calculate column duration again.
  3. Print first 5 rows of updated df.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 4. Kapittel 7
Vi beklager at noe gikk galt. Hva skjedde?

Spør AI

expand
ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

book
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.

1
df['col_name'].where(~(condition), inplace = True, other = values_to_replace)
copy

Using the following approach all the values in col_name will be replaced with values_to_replace if (condition) is True.

Oppgave

Swipe to start coding

  1. For all the trips with negative duration add 12 hours to dropoff_datetime column.
  2. Calculate column duration again.
  3. Print first 5 rows of updated df.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 4. Kapittel 7
Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Vi beklager at noe gikk galt. Hva skjedde?
some-alt