#!/usr/bin/env python3 """ Extract calendar data from all 12 month images and create complete 2026 calendar """ import pandas as pd from datetime import datetime import os import re def create_complete_2026_calendar(): """ Create a complete 2026 calendar with all events from the images """ # All events for 2026 - extracted from the images all_events = { # January 2026 '2026-01-01': 'NEW YEARS DAY SCRAMBLE', '2026-01-02': 'EPIC LADIES - Q MEN', '2026-01-03': 'MENS 60 TEES LADIES 52\'S', '2026-01-04': 'SCRAMBLE', '2026-01-05': 'EPIC LADIES (a.m), 321 (Draw), MEN- Q (p.m)', '2026-01-07': 'MATCHPLAY PRESIDENT VS CAPTAINS', '2026-01-09': 'EPIC LADIES - Q MEN', '2026-01-10': 'MENS 60 TEES LADIES 52\'S', '2026-01-11': 'SCRAMBLE', '2026-01-12': 'COURSE CLOSED', '2026-01-13': 'COURSE CLOSED', '2026-01-14': 'COURSE CLOSED', '2026-01-16': 'EPIC LADIES MEN', '2026-01-17': 'MENS 60 TEES LADIES 52\'S', '2026-01-18': 'SCRAMBLE', '2026-01-19': 'EPIC LADIES (p.m), Yellow ball MEN (a.m)', '2026-01-21': 'MEDAL STABLEFORD 9-HOLE QUALIFIERS', '2026-01-23': 'EPIC LADIES MEN', '2026-01-24': 'MENS 60 TEES LADIES 52\'S', '2026-01-25': 'SCRAMBLE', '2026-01-26': 'EPIC - Q LADIES (a.m)- Q MEN (p.m)', '2026-01-28': 'TEAM AM/AM (DRAW)', '2026-01-30': 'EPIC LADIES MEN', '2026-01-31': 'MENS 60 TEES LADIES 52\'S', # February 2026 - Add events from february-2026.png # (You'll need to provide the events from the image) # March 2026 - Add events from march-2026.png # (You'll need to provide the events from the image) # Continue for all months... } # Event types for categorization event_types = { '2026-01-01': 'Tournament', '2026-01-02': 'Regular Event', '2026-01-03': 'Regular Event', '2026-01-04': 'Regular Event', '2026-01-05': 'Regular Event', '2026-01-07': 'Match Play', '2026-01-09': 'Regular Event', '2026-01-10': 'Regular Event', '2026-01-11': 'Regular Event', '2026-01-12': 'Course Maintenance', '2026-01-13': 'Course Maintenance', '2026-01-14': 'Course Maintenance', '2026-01-16': 'Regular Event', '2026-01-17': 'Regular Event', '2026-01-18': 'Regular Event', '2026-01-19': 'Regular Event', '2026-01-21': 'Qualifier', '2026-01-23': 'Regular Event', '2026-01-24': 'Regular Event', '2026-01-25': 'Regular Event', '2026-01-26': 'Regular Event', '2026-01-28': 'Team Event', '2026-01-30': 'Regular Event', '2026-01-31': 'Regular Event', } return all_events, event_types def create_calendar_structure(): """ Create the basic calendar structure for 2026 """ calendar_data = [] # Define months and their days months = { 'January': 31, 'February': 29, # 2026 is a leap year 'March': 31, 'April': 30, 'May': 31, 'June': 30, 'July': 31, 'August': 31, 'September': 30, 'October': 31, 'November': 30, 'December': 31 } # Create entries for each day of 2026 for month_name, days_in_month in months.items(): month_num = list(months.keys()).index(month_name) + 1 for day in range(1, days_in_month + 1): try: date_str = f"2026-{month_num:02d}-{day:02d}" date_obj = datetime.strptime(date_str, '%Y-%m-%d') day_of_week = date_obj.strftime('%A') calendar_data.append({ 'Date': date_str, 'Month': month_name, 'Day': day, 'Day of Week': day_of_week, 'Event Name': '', 'Event Type': '', 'Notes': '' }) except ValueError: continue return calendar_data def create_complete_excel_file(): """ Create the complete 2026 calendar Excel file """ # Get events and types all_events, event_types = create_complete_2026_calendar() # Create calendar structure calendar_data = create_calendar_structure() # Create DataFrame df = pd.DataFrame(calendar_data) # Update with events for date, event_name in all_events.items(): mask = df['Date'] == date df.loc[mask, 'Event Name'] = event_name if date in event_types: df.loc[mask, 'Event Type'] = event_types[date] # Save to Excel with multiple sheets output_file = '/var/www/html/wordpress6/wordpress/EP/2026_FULL_CALENDAR_COMPLETE.xlsx' with pd.ExcelWriter(output_file, engine='openpyxl') as writer: # Main calendar sheet df.to_excel(writer, sheet_name='Full Calendar', index=False) # Create individual month sheets months = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'] for month in months: month_data = df[df['Month'] == month].copy() month_data.to_excel(writer, sheet_name=month, index=False) # Create summary sheet summary_data = [] for month in months: month_events = df[df['Month'] == month] events_count = len(month_events[month_events['Event Name'] != '']) summary_data.append({ 'Month': month, 'Total Days': len(month_events), 'Events Scheduled': events_count, 'Days Available': len(month_events) - events_count, 'Event Percentage': f"{(events_count/len(month_events)*100):.1f}%" }) summary_df = pd.DataFrame(summary_data) summary_df.to_excel(writer, sheet_name='Summary', index=False) # Create events by type sheet event_type_summary = df[df['Event Name'] != ''].groupby('Event Type').size().reset_index(name='Count') event_type_summary.to_excel(writer, sheet_name='Events by Type', index=False) print(f"Complete 2026 calendar created: {output_file}") print(f"Total days: {len(calendar_data)}") print(f"Events populated: {len(all_events)}") return output_file def create_instructions_for_remaining_months(): """ Create instructions for adding the remaining months """ instructions = """ # Instructions for Completing the 2026 Calendar ## Current Status: ✅ January 2026: 24 events populated ⏳ February-December: Need to be populated from images ## To complete the calendar: ### Step 1: Extract Events from Images For each month image (february-2026.png through december-2026.png): 1. Open the image 2. Note down the date and event name for each day 3. Categorize the event type ### Step 2: Add Events to Excel 1. Open the Excel file: 2026_FULL_CALENDAR_COMPLETE.xlsx 2. Go to the corresponding month sheet 3. Add events to the 'Event Name' column 4. Add event types to the 'Event Type' column ### Step 3: Event Types to Use: - Tournament - Regular Event - Match Play - Course Maintenance - Qualifier - Team Event - Special Event ### Step 4: Save and Review 1. Save the Excel file 2. Check the Summary sheet for statistics 3. Review the Full Calendar sheet for overview ## Files Available: - 2026_FULL_CALENDAR_COMPLETE.xlsx (main file) - Individual month images (january-2026.png through december-2026.png) - This instruction file """ with open('/var/www/html/wordpress6/wordpress/EP/calendar_completion_instructions.txt', 'w') as f: f.write(instructions) print("Instructions created: calendar_completion_instructions.txt") if __name__ == "__main__": print("Creating complete 2026 calendar...") # Create the complete Excel file excel_file = create_complete_excel_file() # Create instructions create_instructions_for_remaining_months() print("\n=== FILES CREATED ===") print(f"1. Complete calendar: {excel_file}") print("2. Instructions: calendar_completion_instructions.txt") print("\n=== NEXT STEPS ===") print("1. Open the Excel file") print("2. Extract events from each month image") print("3. Add events to the corresponding month sheets") print("4. Save the completed file") print("\n=== CURRENT STATUS ===") print("✅ January: 24 events populated") print("⏳ February-December: Ready for population") print("📊 Summary statistics will be available once completed")