Extracting day of week and hour in Pandas - Mini Project: Build & Apply

Extracting Day of Week and Hour from Timestamps

📖 Scenario: You work at a delivery company. You have a list of delivery times. You want to find out which day of the week and hour of the day most deliveries happen.

🎯 Goal: Create a pandas DataFrame with delivery timestamps. Then extract the day of the week and hour from these timestamps. Finally, display the new data.

📋 What You'll Learn

Create a pandas DataFrame called df with a column 'delivery_time' containing the exact timestamps given.

Create a variable called time_column and set it to the string 'delivery_time'.

Use pandas datetime properties to create two new columns in df: 'day_of_week' and 'hour', extracted from time_column.

Print the updated DataFrame df.

💡 Why This Matters

🌍 Real World

Delivery companies analyze delivery times to optimize routes and staffing. Extracting day and hour helps find busy times.

💼 Career

Data analysts and scientists often work with timestamps to find patterns in time-based data.

1

Create the DataFrame with delivery timestamps

Create a pandas DataFrame called df with one column named 'delivery_time'. The column should contain these exact timestamps as strings: '2024-06-01 08:30:00', '2024-06-02 14:45:00', '2024-06-03 19:00:00', '2024-06-04 09:15:00', and '2024-06-05 22:10:00'.

Pandas

# Create the DataFrame df with the delivery_time column and the exact timestamps
# Your code here

Need a hint?

Use pd.DataFrame and pass a dictionary with the key 'delivery_time' and the list of timestamps as values.

2

Set the time column variable

Create a variable called time_column and set it to the string 'delivery_time'.

Pandas

import pandas as pd

df = pd.DataFrame({
    'delivery_time': [
        '2024-06-01 08:30:00',
        '2024-06-02 14:45:00',
        '2024-06-03 19:00:00',
        '2024-06-04 09:15:00',
        '2024-06-05 22:10:00'
    ]
})

# Create the variable time_column and set it to 'delivery_time'
# Your code here

Need a hint?

Just assign the string 'delivery_time' to the variable time_column.

3

Extract day of week and hour from timestamps

Convert the time_column in df to datetime type. Then create two new columns in df: 'day_of_week' which holds the day of the week as an integer (Monday=0), and 'hour' which holds the hour of the day as an integer.

Pandas

import pandas as pd

df = pd.DataFrame({
    'delivery_time': [
        '2024-06-01 08:30:00',
        '2024-06-02 14:45:00',
        '2024-06-03 19:00:00',
        '2024-06-04 09:15:00',
        '2024-06-05 22:10:00'
    ]
})

time_column = 'delivery_time'

# Convert df[time_column] to datetime and create 'day_of_week' and 'hour' columns
# Your code here

Need a hint?

Use pd.to_datetime() to convert the column. Then use .dt.dayofweek and .dt.hour to get the new columns.

4

Print the updated DataFrame

Print the DataFrame df to see the new columns 'day_of_week' and 'hour'.

Pandas

import pandas as pd

df = pd.DataFrame({
    'delivery_time': [
        '2024-06-01 08:30:00',
        '2024-06-02 14:45:00',
        '2024-06-03 19:00:00',
        '2024-06-04 09:15:00',
        '2024-06-05 22:10:00'
    ]
})

time_column = 'delivery_time'

df[time_column] = pd.to_datetime(df[time_column])
df['day_of_week'] = df[time_column].dt.dayofweek
df['hour'] = df[time_column].dt.hour

# Print the DataFrame df
# Your code here

Need a hint?

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