Shift Training Year

• Detects which year(s) appear in each file by scanning quoted strings
• Shifts years only inside quoted strings — this protects unquoted numeric values (StoreKey, CustomerKey, ProductKey, etc.) from accidental changes
• Handles Order Numbers (e.g., "202401011CS952" → "202501011CS952") and dates in DD/MM/YYYY format (e.g., "01/01/2024" → "01/01/2025")
• Renames files that have years in their names (e.g., contoso-online-2024.csv → contoso-online-2025.csv)

XLSX files:

• Shifts any numeric cell value that looks like a year (2000-2099 range) in columns named "Year" or similar
• Also scans all cells for standalone year values if no Year column is found
• Does not rename XLSX files (usually named generically like TargetReport.xlsx)

Important Notes

• The script processes files in reverse year order (highest year first) to prevent double-shifting when multiple years exist in the same file
• Always creates a backup (_backup/) before modifying files — the backup is placed inside the target folder
• CSV encoding is preserved (UTF-8)

Workflow

1. User provides the folder path containing training data
2. Confirm with user: which files to process and the shift amount
3. Run the script
4. Verify a sample of the output to make sure it looks correct
5. If user is satisfied, the backup folder can be deleted

Example

User: เลื่อนปีใน training data ไป 1 ปี folder C:\...\Contoso

Step 1: List files in the folder
Step 2: Confirm with user
Step 3: Run script
  python "<skill-path>/scripts/shift_year.py" "C:\...\Contoso"
Step 4: Spot-check a few rows from each file

Related Skills

• /xlsx-thepexcel — Read/edit XLSX files directly; use when year-shifted data needs further spreadsheet manipulation