dt accessor for datetime properties in Pandas - Mini Project: Build & Apply

Exploring Dates with dt Accessor in pandas

📖 Scenario: You work at a small event company. You have a list of event dates and want to learn more about them, like which month and day of the week each event falls on.

🎯 Goal: Build a small pandas program that creates a DataFrame with event dates, extracts the month and day of the week using the dt accessor, and prints the results.

📋 What You'll Learn

Create a pandas DataFrame with a column named event_date containing specific dates.

Create a variable called date_column that holds the event_date column from the DataFrame.

Use the dt accessor on date_column to create two new columns: month and day_of_week.

Print the final DataFrame showing the original dates and the extracted month and day of the week.

💡 Why This Matters

🌍 Real World

Event planners often need to analyze dates to schedule activities, send reminders, or find patterns in attendance.

💼 Career

Data analysts and scientists use datetime properties to prepare and explore time-based data for reports and decision-making.

1

Create the DataFrame with event dates

Create a pandas DataFrame called df with a column event_date containing these exact dates as strings: '2024-01-15', '2024-02-20', '2024-03-10', '2024-04-25', '2024-05-30'. Then convert the event_date column to datetime type using pd.to_datetime().

Pandas

import pandas as pd
# Create DataFrame df with event_date column and convert to datetime
# Your code here

Hint

Use pd.DataFrame to create the table and pd.to_datetime() to convert the date strings.

2

Create a variable for the date column

Create a variable called date_column and assign it the event_date column from the DataFrame df.

Pandas

import pandas as pd

df = pd.DataFrame({
    'event_date': ['2024-01-15', '2024-02-20', '2024-03-10', '2024-04-25', '2024-05-30']
})
df['event_date'] = pd.to_datetime(df['event_date'])
# Create date_column variable for df['event_date']
# Your code here

Hint

Assign df['event_date'] to a new variable called date_column.

3

Extract month and day of week using dt accessor

Use the dt accessor on date_column to create two new columns in df: month with the month number, and day_of_week with the day name.

Pandas

import pandas as pd

df = pd.DataFrame({
    'event_date': ['2024-01-15', '2024-02-20', '2024-03-10', '2024-04-25', '2024-05-30']
})
df['event_date'] = pd.to_datetime(df['event_date'])

date_column = df['event_date']
# Create df['month'] and df['day_of_week'] using date_column.dt
# Your code here

Hint

Use date_column.dt.month for month numbers and date_column.dt.day_name() for day names.

4

Print the final DataFrame

Write a print statement to display the DataFrame df showing the event_date, month, and day_of_week columns.

Pandas

import pandas as pd

df = pd.DataFrame({
    'event_date': ['2024-01-15', '2024-02-20', '2024-03-10', '2024-04-25', '2024-05-30']
})
df['event_date'] = pd.to_datetime(df['event_date'])

date_column = df['event_date']

df['month'] = date_column.dt.month
df['day_of_week'] = date_column.dt.day_name()
# Print the DataFrame df
# Your code here

Hint

Use print(df) to show the full table with new columns.

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