Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Apprendre Challenge: Average Metrics Across Taxi Types | Working with Dates and Times in pandas
Dealing with Dates and Times in Python
course content

Contenu du cours

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?

book
Challenge: Average Metrics Across Taxi Types

Great! As for now, we have our dataset cleared from abnormally long rides and rides with ending time preceded starting. As we investigated, it happened because of misusage of 12 and 24-hour formats.

Let's try to find out some interesting insights from this dataset.

Tâche

Swipe to start coding

  1. Apply .total_seconds() function to duration column using map and lambda functions.
  2. Group observations by taxi type (vendor_id column). Then, choose columns dist_meters, duration, and calculate mean. Then apply function avg_m to dist_meters and avg_dur to duration. The functions are defined in the code.

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 4. Chapitre 8
toggle bottom row

book
Challenge: Average Metrics Across Taxi Types

Great! As for now, we have our dataset cleared from abnormally long rides and rides with ending time preceded starting. As we investigated, it happened because of misusage of 12 and 24-hour formats.

Let's try to find out some interesting insights from this dataset.

Tâche

Swipe to start coding

  1. Apply .total_seconds() function to duration column using map and lambda functions.
  2. Group observations by taxi type (vendor_id column). Then, choose columns dist_meters, duration, and calculate mean. Then apply function avg_m to dist_meters and avg_dur to duration. The functions are defined in the code.

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 4. Chapitre 8
Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Nous sommes désolés de vous informer que quelque chose s'est mal passé. Qu'est-il arrivé ?
some-alt