Group Unique Values from Multiple Attribute Fields

JaredPilbeam2

I'm working with a table with tons of unique values crammed into a field. Is there a pythonic way to group unique values from multiple attribute fields? That way I'd have one symbol for its respective values instead of there being repetitive values. 

So, i'd like the table to be organized into something like this:

I'm able to do something similar with Arcade, but it's limited.  How To: Group unique values from multiple attribute fields in ArcGIS Pro 

Creating a list in Arcade can be verified in the Expression builder, but there are no results. My thread using Arcade: Arcade If Statement for Multiple Unique Values 

XanderBakker

Hi Jared Pilbeam ,

Find below the Python standalone script to do the same. 

<SPAN class="comment token">#-------------------------------------------------------------------------------</SPAN>
<SPAN class="comment token"># Name:        categories.py</SPAN>
<SPAN class="comment token"># Purpose:</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="comment token"># Author:      xbakker</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="comment token"># Created:     24/06/2020</SPAN>
<SPAN class="comment token">#-------------------------------------------------------------------------------</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">import</SPAN> arcpy

    <SPAN class="comment token"># configuration</SPAN>
    fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\GeoNet\Jared\Default.gdb\RecyclingLocations_full'</SPAN>  <SPAN class="comment token"># point to your datasource</SPAN>
    fld_kw <SPAN class="operator token">=</SPAN> <SPAN class="string token">"USER_Keywo"</SPAN>  <SPAN class="comment token"># your input field</SPAN>
    fld_res <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Category2"</SPAN>  <SPAN class="comment token"># your output string field</SPAN>

    <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>fld_kw<SPAN class="punctuation token">,</SPAN> fld_res<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
            keyword_txt <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
            finalgroup <SPAN class="operator token">=</SPAN> GetPredominantGroup<SPAN class="punctuation token">(</SPAN>keyword_txt<SPAN class="punctuation token">)</SPAN>
            row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> finalgroup
            curs<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">GetPredominantGroup</SPAN><SPAN class="punctuation token">(</SPAN>keyword_txt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    sep <SPAN class="operator token">=</SPAN> <SPAN class="string token">";"</SPAN>
    keywords <SPAN class="operator token">=</SPAN> keyword_txt<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN>sep<SPAN class="punctuation token">)</SPAN>
    dct_groups <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
    <SPAN class="keyword token">for</SPAN> keyword <SPAN class="keyword token">in</SPAN> keywords<SPAN class="punctuation token">:</SPAN>
        group <SPAN class="operator token">=</SPAN> GetGroup<SPAN class="punctuation token">(</SPAN>keyword<SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> group <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">if</SPAN> group <SPAN class="keyword token">in</SPAN> dct_groups<SPAN class="punctuation token">:</SPAN>
                dct_groups<SPAN class="punctuation token">[</SPAN>group<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
            <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
                dct_groups<SPAN class="punctuation token">[</SPAN>group<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

    cntmax <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
    finalgroup <SPAN class="operator token">=</SPAN> None
    <SPAN class="keyword token">for</SPAN> group<SPAN class="punctuation token">,</SPAN> cnt <SPAN class="keyword token">in</SPAN> dct_groups<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> cnt <SPAN class="operator token">></SPAN> cntmax<SPAN class="punctuation token">:</SPAN>
            finalgroup <SPAN class="operator token">=</SPAN> group
            cntmax <SPAN class="operator token">=</SPAN> cnt

    <SPAN class="keyword token">return</SPAN> finalgroup


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">GetGroup</SPAN><SPAN class="punctuation token">(</SPAN>keyword<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    groups <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'Appliance Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Air Conditioner;Appliance;Refrigerator;Dishwasher;Dryer;Oven;Stove;Washer;Water Heater'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Asbestos Info / Removal Service'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Asbestos'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Automobile & Boat Reuse Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Airplane; Automobile;Boat;Car;Recreation Vehicle;RV;Truck'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Awards & Recognition'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Awards (Eco-Award)'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Batteries'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Lead-Acid Batteries;Single Use AA, AAA, C, D, 9-Volt;Batteries - Rechargeable, BackUp;Lead-Acid Batteries;Rechargebale;Disposable Batteries;Rechargeable;Automotive Batteries;Boat Batteries;Lithium Batteries;Button Batteries'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Bicycle Reuse Donation'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Bicycles'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Book Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Books - Hardcover Recycling;Books - Softcover Recycling'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Cellular Telephone Reuse & Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Cell Phone - Retail Drop-Off;Cell Phone - Electronic Drop Off'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Clean - Up Services'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Clean-Up of Properties;'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Clothing, Linens & Shoe Reuse & Recycling-Drop-Off Locations'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Clothing;Gym Shoes / Sneakers / HighTops;Linens / Blankets / Tableclothes /  Towels;Textile / Fabrics / Drapes / Curtains;Shoes / Boots;Purse or Handbag'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Commercial Hazardous Waste'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Hazardous Waste Services;Chemical Business Waste'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Composting Facilities/Landscape Waste transfer Stations'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Composting Facilities/Landscape Waste transfer Stations;Landscape Material Recycling'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Computer Reuse & Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Business Electronic Devices'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Construction & Demolition Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Asphalt;Brick;Building Construction & Demolition Debris;Carpet;Carpet Padding;Concrete;Dirt;Drywall;Gravel;Padding;Roofing Materials;Shingles;Soil;Stone;Vinyl Siding;Windows;Wood-Untreated;Pallets'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Cooking Oil/Grease Recycling & Trap Service'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Cooking Oil;Grease Recycling;Grease Trap Services'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Crayon Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Crayons'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Curbside Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> 'Aerosol Cans <SPAN class="punctuation token">(</SPAN>empty<SPAN class="punctuation token">)</SPAN> Curbside<SPAN class="punctuation token">;</SPAN>Aluminum Can Curbside<SPAN class="punctuation token">;</SPAN>Aluminum Foil Curbside<SPAN class="punctuation token">;</SPAN>Cardboard <SPAN class="operator token">&</SPAN> Chipboard Curbside<SPAN class="punctuation token">;</SPAN>Curbside Recycling<SPAN class="punctuation token">;</SPAN>Glass Bottles <SPAN class="operator token">&</SPAN> Jars Curbside<SPAN class="punctuation token">;</SPAN>Juice Boxes<SPAN class="operator token">/</SPAN>Drink Pouches Curbside<SPAN class="punctuation token">;</SPAN>Paper <SPAN class="punctuation token">(</SPAN>magazines<SPAN class="punctuation token">,</SPAN> phone bks<SPAN class="punctuation token">,</SPAN> etc<SPAN class="punctuation token">)</SPAN> Curbside<SPAN class="punctuation token">;</SPAN>Plastic <SPAN class="comment token">#1 (PET) & #2 (HDPE) Containers;Plastic #3, #4, #5, #7, Containers Curbside;Six-Pack Rings Curbside;Tin / Steel Cans (soup,cofffee, etc) Curbside',</SPAN>
    <SPAN class="string token">'Demolition Material Recycling & Disposal'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Construction Material Reuse;Demolition Material Reuse / Recycling'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Disposable Batteries'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Batteries - Single Use AA, AAA, C, D, 9-Volt'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Donation'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Books - Hardcover;Computer Reuse/Donation;Couch;Sofa;Toys'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Drum & Cylinder Disposal or Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Cylinders;Drums'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Dry Cleaners (Green)'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Dry Cleaning'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Electronics'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Adding Machines;Answering Machines;Calculators;Cameras;Cassettes;CB\'s/Two-way radios;CD Players / Laser Disc Players;CD ROM Drives;CDs, DVDs;Cell Phone - Electronic Drop-Off;Computer Recycling;Computer Recycling Drop-Off;Copy Machine;Cords & Cables;Digital Clocks;DVD Machine;Electronic Mice;Electronics;Fax Machines;Floppy Disks;Hand Held Games;Hard Drives;Joysticks/Game controls;Keyboards;Microwaves;Modems;Monitors;Pagers;Palm Organizers;Paper shredders;Portable Radio; Postage Machines;Printers;Scanner Machines;Speakers/Stereo Systems;String Lights /  Holiday String Lights;Sump Pump;Tape Drives;Telephone;Televisions;Thermometers (digital);Typewriters/Word Processors;UPS Battery Backups;VCR Machine;VHS Tapes;Video Game Players; Zip Drives'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Eye Glass Reuse'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Eye Glasses'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Fire Extinguisher Refilling or Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Fire Extinguishers'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Fluorescent Lights'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'CFLs;Compact Fluorescent Light Bulbs;Fluorescent Lights'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Food Donation'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Food Donation'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Furniture & Office Equipment '</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Book Cases;Cubical Walls;Desks;File Cabinets;Furniture & Office Equipment;Office Chairs'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Geothermal Energy'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Geothermal'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Gift Cards'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Gift Cards (merchant plastic money card)'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Green Energy Supplier'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Energy Supplier'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Grocery Bag'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Grocery Bags'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Heating Oil Tank Removal'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Heating Oil Tank Removal'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Household Hazardous Waste (HHW)'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Aerosol Products;Antifreeze;Automotive Batteries;Automotive Fluid;Boat Batteries;Button Batteries;Cleaning Chemicals;Compact Fluorescent Light Bulbs - HHW Drop-Off;Drain Cleaners;Driveway Sealer;Fertilizers;Fluorescent Light Bulbs;Gasoline-Oil Mix;Hazardous Household Materials;HHW;Household Chemicals;Lawn & garden chemicals;Lithium Batteries;Medication (old or unwanted);Mercury / Mercury Products;Motor Oil;Nail Polish Remover;Oil Filters;Oil-based Paint / Stain / Varnish;Old Gasoline;Paint Thinners;Pesticides;Pool Chemicals;Rechargeable Batteries;Solvents;Thermometers (glass);Used Oil;Medication (old or unwanted);Thermometers (glass);Cough Medicine;Inhalers;Medicated Shampoo;Ointment / Medicated Ointment;Over-the-Counter Medication;Pills, Pharmaceuticals, Medication;Prescription Medication;Sunscreen;Vitamins'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Landfill & Transfer Stations'</SPAN><SPAN class="punctuation token">:</SPAN> 'Landfills <SPAN class="operator token">&</SPAN> Transfer Stations<SPAN class="punctuation token">;</SPAN>Beverage Carrier Straps<SPAN class="punctuation token">;</SPAN>Six<SPAN class="operator token">-</SPAN>Pack Rings<SPAN class="punctuation token">;</SPAN>Plastic <SPAN class="comment token">#1, PET;Plastic #2, HDPE;Plastic #3, PVC;Plastic #4, LDPE;Plastic #5, PP;Plastic #7, Other Container;Aerosol Cans (empty) Drop-Off;Aluminum Can Recycling Drop-Off ;Aluminum Foil Recycling Drop-Off;Glass Bottles and Jars Drop-Off;Juice Boxes / Drink Pouches  Drop-Off;Tin / Steel Cans (soup, coffee, etc) Drop-Off;',</SPAN>
    <SPAN class="string token">'Latex Paint'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Latex Paint'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Lead-base Paint Concerns'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Lead Paint'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Manure'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Manure'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Matress Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Matress & Box Springs'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Medical Equipment (durable)'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Canes;Crutches;Portable Toliets;Shower Chairs;Wheelchairs'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Medication Drop-Off'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Cough Medicine;Inhalers;Medicated Shampoo;Ointment / Medicated Ointment;Over-the-Counter Medication;Pills, Pharmaceuticals,Medication;Prescription Medication;Sunscreen;Vitamins'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Metal Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Scrap Metal;Aluminum / Aluminum Can Scrap;Brass;Copper;Iron;Steel Scrap;'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Motor Oil - Bulk'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Motor Oil in Buk Drums'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Motor Oil Recycling (DIY)'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Motor Oil - DIY'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Packaging Materials'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Packing Peanut ;Styrofoam Peanuts;Cardboard Boxes'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Pallet Reuse or Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Pallets'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Paper Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Cardboard;Chipboard;Colored Paper;Construction Paper;Junk Mail;Magazines;Newspaper;Office Paper;Paper Recycling;Shredding Services;Clored Paper'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Plastic Carrier Strap Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Beverage Carrier Straps;Six-Pack Rings'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Plastic Container Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> 'Plastic <SPAN class="comment token">#1, PET;Plastic #2, HDPE;Plastic #3 PVC;Plastic #4, LDPE;Plastic #5, PP;Plastic #7, Other Container',</SPAN>
    <SPAN class="string token">'Pop-Tab Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Pop-Tab'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Printer/Toner Cartridge & Ribbon Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Inkjets (Ribbons);Printer/Toner Cartridges'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Propane Tank Disposal or Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Propane Tanks'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Rechargeable Battery'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Batteries - Rechargeable, BackUp, Lead-Acid;Rechargeable'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Recycling and Waste Collection Companies'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Recycling Collection Company;Garbage Collection Company;Waste Collection Company'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Repair Services'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Sharpening Services'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Reuse & Resale Shops'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Reuse/Resale'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Smoke Detectors '</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Smoke Detectors '</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Solar Energy'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Solar Energy'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Styrofoam or Polystyrene Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> 'Plastic <SPAN class="comment token">#6, PS, Polystyrene;Styrofoam',</SPAN>
    <SPAN class="string token">'Tire Recycling'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Tire'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Water Conservation'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Rain Barrels;Rain Garden'</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="string token">'Wind Energy'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Small Wind'</SPAN><SPAN class="punctuation token">}</SPAN>

    <SPAN class="keyword token">for</SPAN> group<SPAN class="punctuation token">,</SPAN> keywords <SPAN class="keyword token">in</SPAN> groups<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> keywords<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN>keyword<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">return</SPAN> group

    <SPAN class="keyword token">return</SPAN> None


<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
    main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Although it does exactly the same as the Arcade expression, it may result in different results. Isn't that fun? 

The reason for this is that when you loop through a dictionary in Python it will not be sorted and the Arcade object will. So if you have two groups with the same amount of counts, it may return a different group. I still think that it might requiere some additional thinking on how to treat features that could belong to multiple groups.