Extracting date components (year, month, day) in Data Analysis Python - Mini Project: Build & Apply

Extracting date components (year, month, day)

📖 Scenario: You work in a small company that keeps track of employee joining dates. You want to analyze the year, month, and day separately to find trends.

🎯 Goal: Build a small program that extracts the year, month, and day from a list of joining dates.

📋 What You'll Learn

Create a list of dates as strings in 'YYYY-MM-DD' format

Create a helper variable to store an empty list for years

Use a for loop to extract year, month, and day from each date string

Print the lists of years, months, and days

💡 Why This Matters

🌍 Real World

Extracting parts of dates helps businesses analyze trends like hiring patterns or sales by month.

💼 Career

Data analysts often need to break down dates to group and summarize data for reports.

1

Create the list of joining dates

Create a list called joining_dates with these exact date strings: '2023-01-15', '2022-12-05', '2021-07-23', '2023-03-30', '2020-11-11'.

Data Analysis Python

# Create the list joining_dates with the exact dates
# Your code here

Hint

Use square brackets [] to create a list and put the date strings inside quotes separated by commas.

2

Create empty lists for year, month, and day

Create three empty lists called years, months, and days to store the extracted parts of the dates.

Data Analysis Python

joining_dates = ['2023-01-15', '2022-12-05', '2021-07-23', '2023-03-30', '2020-11-11']
# Create empty lists years, months, and days
# Your code here

Hint

Use empty square brackets [] to create empty lists.

3

Extract year, month, and day from each date

Use a for loop with variable date to go through joining_dates. Inside the loop, extract the year as the first 4 characters, the month as characters 5 to 7, and the day as characters 8 to 10 from date. Append the year to years, the month to months, and the day to days.

Data Analysis Python

joining_dates = ['2023-01-15', '2022-12-05', '2021-07-23', '2023-03-30', '2020-11-11']
years = []
months = []
days = []
# Use a for loop to extract year, month, and day from each date
# Your code here

Hint

Use string slicing like date[0:4] to get the year part.

4

Print the extracted year, month, and day lists

Print the lists years, months, and days each on a separate line.

Data Analysis Python

joining_dates = ['2023-01-15', '2022-12-05', '2021-07-23', '2023-03-30', '2020-11-11']
years = []
months = []
days = []
for date in joining_dates:
    years.append(date[0:4])
    months.append(date[5:7])
    days.append(date[8:10])
# Print years, months, and days lists
# Your code here

Hint

Use three separate print() statements to show each list.