dt accessor for datetime properties in Pandas - Step-by-Step Execution

Concept Flow - dt accessor for datetime properties

Start with datetime Series

↓

Use .dt accessor

↓

Access datetime property

↓

Get new Series with property values

↓

Use result for analysis or display

You start with a pandas Series of dates, use the .dt accessor to reach datetime properties, then get a new Series with those property values.

Execution Sample

Pandas

import pandas as pd
s = pd.Series(pd.to_datetime(['2023-01-01', '2023-06-15', '2023-12-31']))
s_month = s.dt.month
print(s_month)

This code creates a Series of dates, extracts the month from each date using .dt.month, and prints the month numbers.

Execution Table

Step	Action	Input	Output
1	Create Series s	['2023-01-01', '2023-06-15', '2023-12-31']	Datetime Series with 3 dates
2	Access s.dt.month	Datetime Series	Series with values [1, 6, 12]
3	Print s_month	Series [1, 6, 12]	Output: 0 1 1 6 2 12 dtype: int64

💡 All dates processed, months extracted for each date

Variable Tracker

Variable	Start	After Step 1	After Step 2	Final
s	undefined	Datetime Series ['2023-01-01', '2023-06-15', '2023-12-31']	Same	Same
s_month	undefined	undefined	Series [1, 6, 12]	Same

Key Moments - 3 Insights

Why do we use .dt before accessing month?

The .dt accessor tells pandas we want to work with datetime properties. Without it, pandas doesn't know to treat the Series as dates. See execution_table step 2.

What type of data does s_month hold?

s_month is a Series of integers representing months extracted from each date. This is shown in execution_table step 2 output.

Can we use .dt on a Series that is not datetime?

No, .dt only works on Series with datetime dtype. Otherwise, pandas will raise an error. This is why step 1 converts strings to datetime.

Visual Quiz - 3 Questions

Look at the execution_table step 2. What is the value of s_month at index 1?

A 12

B 1

C 6

D 15

💡 Hint

Check the Output column in step 2 showing the Series values [1, 6, 12]

At which step is the datetime Series created?

A Step 3

B Step 1

C Step 2

D Before Step 1

💡 Hint

Look at the Action column in execution_table where Series s is created

If the Series s was not converted to datetime, what would happen when accessing s.dt.month?

A It would raise an error

B It would return the month numbers anyway

C It would return None values

D It would convert automatically

💡 Hint

Refer to key_moments about .dt usage only on datetime Series

Concept Snapshot

Use pandas .dt accessor to get datetime properties from a Series.
Example: s.dt.month returns month numbers.
Works only if Series dtype is datetime.
Returns a new Series with the property values.
Useful for extracting year, month, day, weekday, etc.

Full Transcript

This visual trace shows how to use pandas .dt accessor to get datetime properties. We start with a Series of date strings converted to datetime. Then we use s.dt.month to get the month number for each date. The execution table shows each step: creating the Series, accessing the month property, and printing the result. The variable tracker shows how s and s_month change. Key moments clarify why .dt is needed and what data type results. The quiz tests understanding of values and steps. The snapshot summarizes the concept simply.

Practice

1.

What does the dt accessor in pandas allow you to do?

easy

A. Extract parts like year, month, and day from datetime columns

B. Convert strings to numbers

C. Sort data alphabetically

D. Create new columns with random values

Solution

1. Step 1: Understand the purpose of dt accessor

   The dt accessor is used with datetime columns to access their components like year, month, day, etc.

2. Step 2: Compare options with this purpose

   Only Extract parts like year, month, and day from datetime columns describes extracting parts of datetime, which matches the dt accessor's use.

3. Final Answer:

   Extract parts like year, month, and day from datetime columns -> Option A

4. Quick Check:

   dt accessor = extract datetime parts [OK]

Hint: Remember: dt means date-time parts extraction [OK]

Common Mistakes:

• Thinking dt converts strings to numbers
• Confusing dt with sorting functions
• Assuming dt creates random data

2.

Which of the following is the correct syntax to get the month from a pandas datetime column df['date']?

df['date']?.month

easy

A. df['date'].month()

B. df['date'].dt.month

C. df['date'].dt('month')

D. df['date'].month.dt

Solution

1. Step 1: Recall correct dt accessor syntax

   To access datetime parts, use .dt followed by the property without parentheses.

2. Step 2: Check each option

   df['date'].dt.month uses .dt.month correctly. df['date'].month() wrongly uses parentheses. df['date'].dt('month') uses wrong syntax. df['date'].month.dt reverses order.

3. Final Answer:

   df['date'].dt.month -> Option B

4. Quick Check:

   Use .dt.property syntax [OK]

Hint: Use .dt before datetime property without parentheses [OK]

Common Mistakes:

• Calling month as a function with ()
• Using dt as a function
• Reversing dt and property order

3.

Given the following code, what will be the output?

import pandas as pd

dates = pd.Series(pd.to_datetime(['2023-01-15', '2023-07-20', '2023-12-31']))
months = dates.dt.month
print(months.tolist())

medium

A. [15, 20, 31]

B. ['January', 'July', 'December']

C. [1, 7, 12]

D. [2023, 2023, 2023]

Solution

1. Step 1: Understand the code

   The code creates a Series of datetime objects for three dates, then extracts the month number using dt.month.

2. Step 2: Determine the month numbers

   January is month 1, July is 7, December is 12, so the list is [1, 7, 12].

3. Final Answer:

   [1, 7, 12] -> Option C

4. Quick Check:

   dt.month extracts month numbers [OK]

Hint: dt.month returns month numbers as integers [OK]

Common Mistakes:

• Confusing day with month
• Expecting month names instead of numbers
• Printing year instead of month

4.

What is wrong with this code snippet?

import pandas as pd

dates = pd.Series(['2023-01-15', '2023-07-20'])
print(dates.dt.day)

medium

A. The Series is not converted to datetime before using dt accessor

B. The dt accessor does not have a day property

C. The print statement syntax is incorrect

D. The dates list is empty

Solution

1. Step 1: Check the data type of the Series

   The Series contains strings, not datetime objects, so dt accessor cannot be used directly.

2. Step 2: Identify the error cause

   Without converting to datetime using pd.to_datetime(), accessing dt.day raises an error.

3. Final Answer:

   The Series is not converted to datetime before using dt accessor -> Option A

4. Quick Check:

   Convert to datetime before using dt [OK]

Hint: Always convert to datetime before using dt accessor [OK]

Common Mistakes:

• Assuming dt works on string Series
• Thinking dt.day does not exist
• Ignoring data type requirements

5.

You have a DataFrame df with a datetime column 'timestamp'. You want to create a new column 'is_weekend' that is True if the date is Saturday or Sunday, and False otherwise. Which code correctly does this?

df['is_weekend'] = df['timestamp'].dt.weekday > 4

hard

A. df['is_weekend'] = df['timestamp'].dt.weekday in [5, 6]

B. df['is_weekend'] = df['timestamp'].dt.day > 4

C. df['is_weekend'] = df['timestamp'].dt.weekday == 5 or 6

D. df['is_weekend'] = df['timestamp'].dt.weekday > 4

Solution

1. Step 1: Understand weekday numbering

   In pandas, dt.weekday returns 0 for Monday up to 6 for Sunday. Weekend days are 5 (Saturday) and 6 (Sunday).

2. Step 2: Check each option's logic

   df['is_weekend'] = df['timestamp'].dt.weekday > 4 uses > 4, which means days 5 and 6 are True. df['is_weekend'] = df['timestamp'].dt.day > 4 checks day of month, not weekday. df['is_weekend'] = df['timestamp'].dt.weekday == 5 or 6 uses incorrect syntax for or. df['is_weekend'] = df['timestamp'].dt.weekday in [5, 6] uses 'in' which is invalid for Series.

3. Final Answer:

   df['is_weekend'] = df['timestamp'].dt.weekday > 4 -> Option D

4. Quick Check:

   Weekend days have weekday > 4 [OK]

Hint: Weekend days have weekday numbers 5 or 6, so > 4 works [OK]

Common Mistakes:

• Using day instead of weekday
• Wrong boolean logic with or
• Using 'in' with pandas Series