Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge: Is this Common Issue? | Working with Dates and Times in pandas
Dealing with Dates and Times in Python
course content

Conteúdo do Curso

Dealing with Dates and Times in Python

Dealing with Dates and Times in Python

1. Working with Dates
What Day is it Today?Creating a Date ObjectDate AttributesDate MethodsDate FormatsOne More FormattingDate DifferenceArithmetic Operations with timedelta Objects
2. Working with Times
What Time is it Now?Creating a datetime ObjectDatetime AttributesDatetime MethodsDatetime Formats12-Hour and 24-Hour FormatsDate and Time DifferenceReading Date and Time from String
3. Timezones and Daylight Savings Time (DST)
The Variery of TimezonesTimezone ExamplesApplying Timezone to Datetime ObjectWhat Time is it in ... ?Daylight Savings Time
4. Working with Dates and Times in pandas
Challenge: What Will We Work With?Challenge: Converting Columns into datetime TypeChallenge: Extreme Trips DurationsChallenge: InvestigationChallenge: Negative Trip DurationChallenge: Is this Common Issue?Challenge: Fixing the IssuesChallenge: Average Metrics Across Taxi TypesChallenge: Corrected Metrics Across Taxi TypesChallenge: Group by Period?

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!

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 4. Capítulo 6
toggle bottom row

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!

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 4. Capítulo 6
toggle bottom row

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!

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

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!

Tarefa

  1. Filter the observations in df dataframe to only with negative duration. Save it in df_neg variable.
  2. Iterate over rows of df_ned. If minute in dropoff_datetime and dropoff_calculated is not the same, you need to print this row.
  3. Within the same for loop count number of rows having an hour in dropoff_datetime greater or equal than 12.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 4. Capítulo 6
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
We're sorry to hear that something went wrong. What happened?
some-alt