自定义周数转日期计数程序开发需求：含跟进数逻辑处理

Core Logic Overview #

• Identify Entry Type: Distinguish between follow-up numbers (numeric values) and week labels (e.g., "1周").
• Normalize Values: Convert week labels to numeric counts (e.g., "1周" → 1).
• Convert to Date: Calculate the target date based on the numeric count (use your custom yellow cell dates as reference points).
• Aggregate Counts: Sum up all valid follow-up week counts.

Step-by-Step Implementation (Python Example) #

1. Parse & Normalize Entries #

First, process each entry in the column to extract the numeric week count:

import re
from datetime import datetime, timedelta

def parse_week_entry(entry):
    # Handle numeric follow-up numbers directly
    if isinstance(entry, (int, float)):
        return int(entry)
    # Extract numeric value from week labels like "1周"
    week_match = re.search(r'(\d+)周', str(entry))
    if week_match:
        return int(week_match.group(1))
    # Return 0 for invalid entries (adjust logic as needed)
    return 0

2. Convert Count to Date #

Use your custom yellow cell date as the reference to calculate the target date:

def count_to_date(week_count, custom_reference_date="2024-01-01"):
    ref_date = datetime.strptime(custom_reference_date, "%Y-%m-%d")
    target_date = ref_date + timedelta(weeks=week_count)
    return target_date.strftime("%Y-%m-%d")

3. Full Workflow Execution #

Process your column data and compute results:

# Replace with your actual column data
column_data = ["1周", 3, "跟进数2", "5周", 1]

total_follow_up_weeks = 0
processed_results = []

for entry in column_data:
    week_count = parse_week_entry(entry)
    total_follow_up_weeks += week_count
    target_date = count_to_date(week_count)
    processed_results.append({
        "original": entry,
        "count": week_count,
        "date": target_date
    })

# Output results
print(f"Total follow-up weeks: {total_follow_up_weeks}")
for res in processed_results:
    print(f"{res['original']} → Count: {res['count']} → Date: {res['date']}")

Key Adjustments #

• Custom Reference Dates: Update custom_reference_date to match your yellow cell dates. If entries use different reference dates, modify the function to accept per-entry reference values.
• Edge Case Handling: Add logic in parse_week_entry to handle non-standard entries (e.g., empty cells, invalid text) based on your data.

内容的提问来源于stack exchange，提问作者Woordvoerder