#!/usr/bin/env python3 """ Correct extraction of calendar data from the actual calendar images """ import pandas as pd from datetime import datetime import os def extract_correct_2026_events(): """ Extract the CORRECT events from the actual calendar images Based on the real calendar structure shown """ # CORRECT events for 2026 - based on actual calendar data all_events = { # January 2026 (from original image - these are correct) '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', # July 2026 - CORRECTED based on your feedback '2026-07-17': 'SCRAMBLE', '2026-07-19': 'COURSE CLOSED', '2026-07-20': 'COURSE CLOSED', '2026-07-21': 'COURSE CLOSED', # Note: I need you to provide the correct events for each month # since my previous extraction was wrong } return all_events def categorize_events_correctly(): """ Categorize events correctly """ event_types = {} all_events = extract_correct_2026_events() for date, event_name in all_events.items(): if 'SCRAMBLE' in event_name: event_types[date] = 'Regular Event' elif 'EPIC' in event_name: event_types[date] = 'Regular Event' elif 'MENS' in event_name and 'LADIES' in event_name: event_types[date] = 'Regular Event' elif 'MATCHPLAY' in event_name: event_types[date] = 'Match Play' elif 'COURSE CLOSED' in event_name: event_types[date] = 'Course Maintenance' elif 'QUALIFIERS' in event_name: event_types[date] = 'Qualifier' elif 'TEAM' in event_name: event_types[date] = 'Team Event' elif 'CHRISTMAS' in event_name or 'NEW YEARS' in event_name: event_types[date] = 'Special Event' else: event_types[date] = 'Regular Event' return event_types def create_corrected_calendar(): """ Create a corrected calendar with only the verified events """ # Get correct events all_events = extract_correct_2026_events() event_types = categorize_events_correctly() # Create calendar structure 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 # Create DataFrame df = pd.DataFrame(calendar_data) # Update with CORRECT events only 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 corrected calendar output_file = '/var/www/html/wordpress6/wordpress/EP/2026_CORRECTED_CALENDAR.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) print(f"Corrected calendar created: {output_file}") print(f"Total days: {len(calendar_data)}") print(f"Events populated: {len(all_events)}") return output_file if __name__ == "__main__": print("Creating CORRECTED 2026 calendar...") print("Note: This version only includes verified correct events") print("January events are correct (from original image)") print("July events are corrected based on your feedback") print("Other months need to be verified and corrected") # Create corrected calendar excel_file = create_corrected_calendar() print(f"\nāœ… CORRECTED calendar created: {excel_file}") print("\nThis version contains:") print("āœ… January 2026: 24 events (verified correct)") print("āœ… July 2026: 4 events (corrected)") print("ā³ Other months: Need verification") print("\nTo complete the calendar correctly:") print("1. Please verify the events for each month") print("2. Provide corrections for any wrong events") print("3. I'll update the calendar with the correct data")