occupation_mapping = {
    'Associate Professional/Technician/Asst/Supervisor/Executive/Officer - Legal': 'Associate Professional',
    'Associate Professionals, Administrative/Specialized - Administrative Officer/Executive': 'Associate Professional',
    'Associate Professionals, Administrative/Specialized - Administrative/Executive Secretaries': 'Associate Professional',
    'Associate Professionals, Administrative/Specialized - Others': 'Associate Professional',
    'Associate Professionals, Artistic and Cultural - Interior Designers/Decorators': 'Associate Professional',
    'Associate Professionals, Artistic and Cultural - Photographers': 'Associate Professional',
    'Associate Professionals, Business/Admin, Financial/Mathematical - Accounting Officer/Executive': 'Associate Professional',
    'Associate Professionals, Business/Admin, Financial/Mathematical - Credit/Loans/Financing Officers/Ex': 'Associate Professional',
    'Associate Professionals, Business/Admin, Financial/Mathematical - Securities/Finance Dealers/Stock/I': 'Associate Professional',
    'Associate Professionals, Business/Admin, Financial/Mathematical - Statistical/Mathematical/Actuarial': 'Associate Professional',
    'Associate Professionals, Business/Admin, Sale/Purchase Agents/Brokers - Business Services': 'Associate Professional',
    'Associate Professionals, Business/Admin, Sale/Purchase Agents/Brokers - Buyers': 'Associate Professional',
    'Associate Professionals, Business/Admin, Sale/Purchase Agents/Brokers - Commercial Sales': 'Associate Professional',
    'Associate Professionals, Business/Admin, Sale/Purchase Agents/Brokers - Insurance': 'Associate Professional',
    'Associate Professionals, Business/Admin, Sale/Purchase Agents/Brokers - Trade Brokers': 'Associate Professional',
    'Associate Professionals, Culinary - Chefs/Other Related': 'Associate Professional',
    'Associate Professionals, Regulatory Government - Others (Fireman/Prison/Maritime Asst. Superintenden': 'Associate Professional',
    'Associate Professionals, Regulatory Government - Police Officers (L/Corporal to Sub Inspectors)': 'Associate Professional',
    'Associate Professionals, Sports/Self-Defence/Fitness - Atheletes/Sports Players': 'Associate Professional',
    'Associate Professionals, Sports/Self-Defence/Fitness - Fitness/Recreation Instructors/Program Leader': 'Associate Professional',
    'Associate Professionals, Sports/Self-Defence/Fitness - Sports Coaches/Instructors/Officials': 'Associate Professional',
    'Associate Professionals/Assistants/Supervisors, Regulatory Government - Customs/Border Inspectors (I': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Dental and Therapists Nurse/e': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Medical Asst/radiograph/elect': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Medical Records/Health Info/L': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Nursing/Midwifery': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Others': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Physiotherapy/Electrotherapis': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Health - Traditional/Complementary Med': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Science/Engineering - Life Science/bio': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Science/Engineering - Mining/Manufactu': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Science/Engineering - Physical/Enginee': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Science/Engineering - Process Control/': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive, Science/Engineering - Ship/Aircraft/Tr': 'Associate Professional',
    'Associate Professionals/Technician/Asst/Supervisor/Executive/Officer - IT & Communication/Broadcasti': 'Associate Professional',
    'Associate Professionals/Technicians/Assistants/Supervisors - Social/Religious/Monk/Nun/Preacher/Bila': 'Associate Professional',
    'Clerical Support Workers - Numerical & Material Recording Clerks': 'Clerical Support Workers',
    'Clerical Support Workers - Other Related Clericals/Customer Services/Tellers/Money Collectors/Casino': 'Clerical Support Workers',
    'Clerical Support Workers, Customer Services/Client Information Workers - Contact/Call Centre Informa': 'Clerical Support Workers',
    'Clerical Support Workers, Customer Services/Client Information Workers - Enquiry Clerks': 'Clerical Support Workers',
    'Clerical Support Workers, Customer Services/Client Information Workers - Receptionists': 'Clerical Support Workers',
    'Clerical Support Workers, Customer Services/Client Information Workers - Telephone Switchboard Opera': 'Clerical Support Workers',
    'Clerical Support Workers, Customer Services/Tellers/Money Collectors - Bank Tellers/Cash Counter/Mon': 'Clerical Support Workers',
    'Clerical Support Workers, Office - General Office Clerks': 'Clerical Support Workers',
    'Clerical Support Workers, Office - Secretaries (General), P.A/Verbatim/Hansard Reporter': 'Clerical Support Workers',
    'Clerical Support Workers, Office/Keyboard Operators - Data Entry Clerks': 'Clerical Support Workers',
    'Professionals, Administration/Policy Analyst/Market/Business Research/Admin Exec/Registrar College/U': 'Professionals',
    'Professionals, Architects/Planners/Surveyors/Designers - Building/Interior': 'Professionals',
    'Professionals, Architects/Planners/Surveyors/Designers - Cartographers/Quantity/Building/Aerial/Land': 'Professionals',
    'Professionals, Architects/Planners/Surveyors/Designers - Landscape': 'Professionals',
    'Professionals, Architects/Planners/Surveyors/Designers - Product/Garment/Cloth': 'Professionals',
    'Professionals, Architects/Planners/Surveyors/Designers - Town/Traffic/Urban/Rural': 'Professionals',
    'Professionals, Business/Administration/Finance - Accountants/Auditor/Tax Colsultant/Liquidator/Chart': 'Professionals',
    'Professionals, Business/Administration/Finance - Financial/Investment Advisors/Planners': 'Professionals',
    'Professionals, Business/Administration/Finance - Financial/Investment Analysts/Executive': 'Professionals',
    'Professionals, Engineer (Incl. Electrotechnology) Industrial/Production/Environmental/Mechanical/Che': 'Professionals',
    'Professionals, Health - Dentists/Dental Surgeon': 'Professionals',
    'Professionals, Health - Medical Doctors, ENT/Anaesthetist/Oncologist/Psychiatrist/Cardiologist/Gynae': 'Professionals',
    'Professionals, Health - Nursing/Midwifery': 'Professionals',
    'Professionals, Health - Others/Veterinarians/Paramedical/Physiotherapist/Therapist/Chiropractor/Diet': 'Professionals',
    'Professionals, Health - Pharmacists': 'Professionals',
    'Professionals, Hospitality/Related Services/Reservation/Reception/Housekeeping/Food & Beverages Supe': 'Professionals',
    'Professionals, IT/Communication Tech - Database/Network - Security Specialist/Others': 'Professionals',
    'Professionals, IT/Communication Tech - Software/System/Application Analysts': 'Professionals',
    'Professionals, IT/Communication Tech - Software/System/Application Developers': 'Professionals',
    'Professionals, IT/Communication Tech - Software/System/Application/Communication/Database Programmer': 'Professionals',
    'Professionals, IT/Communication Tech - System/IT Administrators/Executive': 'Professionals',
    'Professionals, IT/Communication Tech - Web/Internet/Intrandet/Animation/Computer Games/Multimedia De': 'Professionals',
    'Professionals, Legal - Lawyers/Prosecutors/Solicitors/Legal Advisors/Legal Drafters/Legal Officer/Ad': 'Professionals',
    'Professionals, Mathematicians/Actuaries/Statisticians Physical/Social Science/Biometrician/Other Rel': 'Professionals',
    'Professionals, Mining/Manufacturing/Construction/Boiler/Quality Assurance/Contract/Project/Property/': 'Professionals',
    'Professionals, Other Life Science/Biologist/Zoologist/Botanist/Agronomist/Horticultural/Pharmacologi': 'Professionals',
    'Professionals, Other Ship/Aircraft/Train/Locomotive/ERL/LRT/MRT/Monorail Controller/Permanent-way in': 'Professionals',
    'Professionals, Passenger/Cargo Aircraft - Air Pilot/Controller/Flight Navigator/Instructor/Engineer/': 'Professionals',
    'Professionals, Regulatory Government - Police Inspectors/Detectives (Probationary Insp/Inspectors to': 'Professionals',
    'Professionals, Religious - Mufti/Imam/Kadi/Priest': 'Professionals',
    'Professionals, Sales/Marketing/Public Relations/Corporate Comm Exec/Publicity Agent/Sales Representa': 'Professionals',
    'Professionals, Science/Engineering - Chemists/Geochemist/Other Related': 'Professionals',
    'Professionals, Science/Engineering - Geologists/Geophysicists/Mineralogist/Petrologist/Oceanographer': 'Professionals',
    'Professionals, Science/Engineering - Metereologists/Agrometeorologist/Seismologists/Climatologist/ O': 'Professionals',
    'Professionals, Science/Engineering - Physicists, Thermodynamic/Nuclear/Atomic/Molecular/Astronomers/': 'Professionals',
    'Professionals, Ship/Ferry/Vessel Deck Officers - Ship/Ferry Deck Officers/Hovercraft Pilots/Captain/': 'Professionals',
    'Professionals, Ship/Ferry/Vessel Engineers/Controllers - Ship/Marine Engineers/Technical Superintend': 'Professionals',
    'Professionals, Social/Cultural/Authors/Journalists/Linguists - Journalist/Columnist/Political Editor': 'Professionals',
    'Professionals, Social/Cultural/Creative - Film/Stage/Related Directors & Producers/etc': 'Professionals',
    'Professionals, Social/Cultural/Creative/Performing Artists - Musicians/Singers/Composers/Instrumenta': 'Professionals',
    'Professionals, Social/Cultural/Religious - Librarians/Archivists/Curators': 'Professionals',
    'Professionals, Teaching, Lecturers/Tutors/Professor - University/College/Higher Education/Dean/Deput': 'Professionals',
    'Professionals, Teaching, Teachers - Music/Arts/Performing Arts': 'Professionals',
    'Professionals, Teaching, Teachers - Primary School/Early Childhood/Kindergarden/non-graduate teacher': 'Professionals',
    'Professionals, Teaching, Teachers - Secondary Education/Pre-university/Officer, education graduate s': 'Professionals',
    'Professionals, Teaching, Teachers - Technology Skill/Technical Trainers': 'Professionals',
    'Professionals, Teaching, Teachers/Lecturers/Tutors - Others/Home Teachers/Special Need Teachers For': 'Professionals',
    'Craft,Building Finishers/Related Trades Workers - Plumbers and Pipe Fitters': 'Craft',
    'Craft,Electrical/Electronic/Related Trades Workers - Building and Related Electricians': 'Craft',
    'Craft,Electrical/Electronic/Related Trades Workers - Electrical Mechanics/Fitters': 'Craft',
    'Craft,Electronics/Telecommunications/Related Trades Workers - IT & Communication Technology Installe': 'Craft',
    'Craft,Electronics/Telecommunications/Related Trades Workers - Mechanics and Servicers': 'Craft',
    'Craft,Food Processing/Related Trades Workers - Meat/Fish Processing/Related Food Preparers/Butchers': 'Craft',
    'Craft,Metal/Machinery/Blacksmiths/Toolmakers/Related Trades Workers - Metal Working Machine Tool Set': 'Craft',
    'Craft,Metal/Machinery/Blacksmiths/Toolmakers/Related Trades Workers - Others': 'Craft',
    'Craft,Metal/Machinery/Mechanics & Repairers/Related Trades Workers - Agricultural/Industrial Machine': 'Craft',
    'Craft,Metal/Machinery/Mechanics & Repairers/Related Trades Workers - Motor Vehicle': 'Craft',
    'Craft,Metal/Machinery/Mechanics & Repairers/Related Trades Workers - Others': 'Craft',
    'Craft,Metal/Machinery/Sheet/Structural Metal/Moulders/Welders/Related Trades Workers - Others': 'Craft',
    'Craft,Metal/Machinery/Sheet/Structural Metal/Moulders/Welders/Related Trades Workers - Welders/Flame': 'Craft',
    'Craft,Others, Garment/Related Trades Workers - Others': 'Craft',
    'Craft,Others, Garment/Related Trades Workers - Tailors/Dressmakers/Furriers/Hatters': 'Craft',
    'Craft,Painters, Building Structure Cleaners/Related Trades Workers - Painters and Related': 'Craft',
    'Craft/Related Trades Workers - Others': 'Craft',
    'Service and Sales Workers - Other Personal Services/Astrologer/Palmist/Fortune-teller/Valet/Undertak': 'Service and Sales Workers',
    'Service and Sales Workers, Other Personal Services, - Driving Instructors': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services - Cooks/Kitchen Coordinator/Food Canning & Preserving': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services - Transport/Bus Conductors/ Ticket Inspectors': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services - Travel Attendants, Air/Flight/Train/Floor Stewards/St': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services - Travel/Tourist/Art Gallery/Factory Tour/SightSeeing G': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services - Waiters/Waitress/Bartenders/Dang Pawara/Food & Bevera': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services, - Beauticians/Mak Andam/Manicurist/Pedicurist/Aestheti': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services, - Building and Housekeeping, Banquet/Hotel/Lodging/Hot': 'Service and Sales Workers',
    'Service and Sales Workers, Personal Services, - Hairdressers/Barber/Hairstylists': 'Service and Sales Workers',
    'Protective Services Workers - Fire-Fighters(Airport) /Fireman (Fire Brigade)': 'Protective Service Workers',
    'Protective Services Workers - Immigration/Custom Officers/Assistant/Civil Defence Private & Below': 'Protective Service Workers',
    'Protective Services Workers - Police Officers (Constables/Patrolman/Traffic Warden)': 'Protective Service Workers',
    'Protective Services Workers - Rangers/Wildlife Warden/Assistant,Rehabilitation Workers/Industrial In': 'Protective Service Workers',
    'Protective Services Workers - Security Guards (Departmental/Office/Industrial Guard/Concierge)': 'Protective Service Workers',
    'Elementary - Cleaners/Helpers/Laundress/Housekeeper/Chambermaid/Porter/Hotel Bellman/Washer/Tea Lady': 'Elementary',
    'Elementary, Agricultural/Forestry/Farming/Fishery Labourers - Farm/Estate/Plantation/Manuring/Vegeta': 'Elementary',
    'Elementary, Food Preparation Assistant - Other than cooking, Cold/Fast Foods/Shellfish Preparer/Slic': 'Elementary',
    'Elementary, Manufacturing - Workers/Labourers': 'Elementary',
    'Elementary, Mining/Construction - Workers/Labourers': 'Elementary',
    'Elementary, Others - Garbage/Soil Carrier/Scrap Handler/Sweeper/Messenger/Courier/Postman/Office Boy': 'Elementary',
    'Elementary, Transport/Storage - Other Labourers/Workers': 'Elementary',
    'Elementary, Transport/Storage, Animal-Drawn Machinery/Vehicle Drivers - Bullock-cart/Animal Train/Dr': 'Elementary',
    'Elementary, Transport/Storage, Hand/Pedal Vehicle - Taxi/Trishaw/Bus/Car/Van/Lorry Drivers': 'Elementary',
    'Managers, Administrative/Commercial Managers/Account/Credit/Finance/HR/Insurance/Treasury/Audit/IR/O': 'Managers',
    'Managers, Hospitality/Retail/Other Services/Concierge/Reservation/Reception/Housekeeping/Food & Beve': 'Managers',
    'Managers, IT/Communications Technology/Information Systems/Computer Services/Network/Data Processing': 'Managers',
    'Managers, Managing Directors/Chief Executives/ Chairman/President/Director Enterprise/Organization': 'Managers',
    'Managers, Other Legislators/Senior Official / Parliamentarian/Chief/Deputy/Minister/Senator/Speaker/': 'Managers',
    'Managers, Production/Manufacturing/Agriculture/Forestry/Fishery/Mining/Construction/Supply/Distribut': 'Managers',
    'Managers, Senior Government Officials/Government Secretary-General/Statutory Board/Ambassador/Consul': 'Managers',
    'Managers, Services Managers/Child Care/Nursing/Hospital/Aged Care/Social/Welfare Manager': 'Managers',
    'Outside Labour Force - Housewife/Househusband': 'Outside Labour Force',
    'Outside Labour Force - Other Outside Labour Force/Disable Persons/OKU': 'Outside Labour Force',
    'Outside Labour Force - Retiree': 'Outside Labour Force',
    'Outside Labour Force - Student': 'Outside Labour Force',
    'Plant/Machine Operators/Assemblers  - Machine-Tool Setter/Operators': 'Plant/Machine',
    'Plant/Machine Operators/Assemblers  - Mechanical Machinery Assemblers': 'Plant/Machine',
    'Plant/Machine Operators/Assemblers  - Other Assemblers': 'Plant/Machine',
    'Plant/Machine Operators/Assemblers  - Stationary Plant/Machine Operators': 'Plant/Machine',
    'Plant/Machine,  Drivers/Mobile Plant Operators/Related Workers - Car/Van/Motorcycle Drivers': 'Plant/Machine',
    'Plant/Machine,  Drivers/Mobile Plant Operators/Related Workers - Heavy Truck/Bus Drivers': 'Plant/Machine',
    'Plant/Machine,  Drivers/Mobile Plant Operators/Related Workers - Locomotive Engine Drivers': 'Plant/Machine',
    'Plant/Machine,  Drivers/Mobile Plant Operators/Related Workers - Mobile Plant Operators': 'Plant/Machine',
    'Plant/Machine,  Drivers/Mobile Plant Operators/Related Workers - Ships’ Deck Crews/Other Related': 'Plant/Machine',
    'Sales Workers - Cashiers and Ticket Clerks': 'Sales Workers',
    'Sales Workers - Others': 'Sales Workers',
    'Sales Workers - Stall/Market/Kiosk Salesperson/promoter/Florist/': 'Sales Workers',
    'Sales Workers - Street Food Salesperson/Hawker': 'Sales Workers',
    'Sales Workers, Others - Fashion & Sales Demonstrators/Telemarketer/Rollerboy/Door to Door Salesperso': 'Sales Workers',
    'Sales Workers, Shop Salespersons - Shop Keepers': 'Sales Workers',
    'Sales Workers, Shop Salespersons - Shop Sales Assistants': 'Sales Workers',
    'Sales Workers, Shop Salespersons - Shop Supervisors': 'Sales Workers',
    'Education/Social Services Workers, Child Care & Teachers Aide - Child Care Workers': 'Education/Social Services Workers',
    'Education/Social Services Workers, Personal Care Workers in Medical Centre - Health Care Assistants': 'Education/Social Services Workers',
    'Education/Social Services Workers, Personal Care Workers in Medical Centre - Others': 'Education/Social Services Workers',
    'Agricultural/Forestry/Livestock/Fishery Workers - Gardeners/Horticultural/Nursery Growers': 'Others',
    'Army -Recruit/Private to General/Field Marshal, Navy - Ordinary-COD/Seaman/Recruit to Admiral of Fle': 'Others',
    'Entertainer': 'Others',
    'SKILLED OPERATOR (NOT HANDLING': 'Others',
    'Subsistence Farmers/Fisherman/Hunters/Gatherers/Turtle Egg/Dammar/Shellfish/Seaweed/Bird Nest/Wild F': 'Others',
}

data['OCCUPATION_CLUSTER'] = data['OCCUPATION'].apply(lambda x: occupation_mapping.get(x, 'Others'))