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

Deslize para mostrar o menu

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.

Tarefa

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.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 4. Capítulo 7

Pergunte à IA

expand
ChatGPT

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

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.

Tarefa

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.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 4. Capítulo 7
Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Sentimos muito que algo saiu errado. O que aconteceu?
some-alt