Chapter 82 Sentiment analysis by Inspection Text

We examine the positive and the negative Text.We filtered out messages that had fewer than five words that contributed to sentiment.

sentiment_messages <- FoodInspectionsReduced %>%
  unnest_tokens(word, Violations) %>%
  filter(!word %in% stop_words$word) %>%
  inner_join(get_sentiments("afinn"), by = "word") %>%
  group_by(Results, InspectionID) %>%
  dplyr::summarize(sentiment = mean(score),
            words = n()) %>%
  ungroup() %>%
  filter(words >= 5)

FoodInspectionsReduced2 = FoodInspections %>%
  mutate(InspectionID = `Inspection ID`) %>%
  mutate(DBAName = `DBA Name`) %>%
  select(InspectionID,Violations,Results,DBAName)

The Messages having top Ten positive sentiments are

DBAName	Results.x	Text
LA CENTRAL BAKERY V	Pass	WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: MUST CLEAN WALL AT PREP TABLE NEXT TO OVEN IN KITCHEN. REMOVE DUST FROM FAN COVERS IN WALK-IN COOLER. SEAL HOLES AROUND PIPES UNDERNEATH HANDSINKS IN WASHROOMS. | 36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED - Comments: ONE SET OF LIGHTS IN KITCHEN HAVE SHIELDS BUT NO END CAPS; PROVIDE END CAPS FOR LIGHTS. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: VENTILATION FAN IN WOMENS WASHROOM NOT WORKING; REPAIR FAN.
WHITE CASTLE SYSTEM, INC	Pass	VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: INSTRUCTED TO REPAIR THE VENTILATION INSIDE THE BATHROOMS. ALSO INSTRUCTED TO CLEAN FAN INSIDE THE WALK IN COOLER. | 43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTHS PROPERLY STORED - Comments: NOTED ICE SCOOP ON TOP OF ICE MACHINE NOT PROPERLY STORED. INSTRUCTED TO STORE ICE SCOOP IN A CLEAN SCOOP HOLDER OR CONTAINER.
JAMBA JUICE	Pass	FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: CLEAN INTERIOR OF FRONT REFRIGERATOR. CLEAN FAN GUARD COVER IN REAR PREP REFRIGERATOR TO REMOVE DUST OBSERVED. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: SOME AREAS OF FLOOR STICKY; MOP AREAS. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: SOME DUST ON CEILING VENTILATION FAN IN WASHROOM; REMOVE. REMOVE DUST ON FAN COVERS IN WALK-IN COOLER.
TUSCAN HEN FOODS	Pass	FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: OBSERVED SLIGHT CALCIUM BUILD UP INSIDE ICE MACHINE. MUST CLEAN AND MAINTAIN INTERIOR OF ICE MACHINE. | 43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTHS PROPERLY STORED - Comments: OBSERVED ICE SCOOP IMPROPERLY STORED INSIDE ICE MACHINE WITH ICE SCOOP HANDLE NOT UPWARD. INSTRUCTED MANAGER TO PROVIDE CLEAN CONTAINER FOR ICE SCOOP. | 40. REFRIGERATION AND METAL STEM THERMOMETERS PROVIDED AND CONSPICUOUS - Comments: NO THERMOMETER INSIDE BASEMENT REFRIGERATOR. INSTRUCTED MANAGER TO PROVIDE WORKING THERMOMETER FOR SAID COOLER. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: BASEMENT EMPLOYEES WASHROOM CEILING VENTILATION FAN NOT WORKING. INSTRUCTED MANAGER TO PROVIDE WORKING WASHROOM CEILING VENTILATION FAN.
TAQUERIA LA OAXAQUENA	Pass	FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: DRAIN RACK OVER THREE COMPARTMENT SINK HAVE BUILD UP OF GRIME. MUST CLEAN. | 43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTHS PROPERLY STORED - Comments: ICE DISPENSING SCOOP INSIDE ICE MACHINE. MUST PROVE CONTAINER FOOD ICE SCOOP. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: FLOORS AROUND BASEBOARDS/COVE HAVE BUILD OF GRIME/GREASE MUST DETAIL CLEAN. | 37. TOILET ROOM DOORS SELF CLOSING: DRESSING ROOMS WITH LOCKERS PROVIDED: COMPLETE SEPARATION FROM LIVING/SLEEPING QUARTERS - Comments: WOMEN TOILET DOOR NEED SELF CLOSING DEVICE . | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: VENTILATION COVERS IN DING AREA HAVE BUILD UP OF DUST. MUST CLEAN.
BUZZ KILLER ESPRESSO	Pass	FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: CLEAN INTERIOR OF REFRIGERATION UNIT BY THE THREE COMP SINK. CLEAN INTERIOR OF ICE MACHINE AND MAINTAIN. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: A COVER IS NEEDED FOR THE VENTILATION FAN IN THE FIRST FLOOR WASHROOM. REMOVE DUST FROM VENTILATION FAN COVER IN THE SECOND FLOOR WASHROOM.
BUDACKIS DRIVE-IN HOT DOGS	Pass	LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED - Comments: Light not provided in dining room front storage room. Instructed to install bulb and/or light fixture. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: Exhaust fan in toilet room not working. Instructed to repair exhaust fan. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: Floor along wallbase and behind heavy equipment not cleaned. Instructed to detail clean daily. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: Light and ventilation covers not cleaned. Instructed to detail clean. | 37. TOILET ROOM DOORS SELF CLOSING: DRESSING ROOMS WITH LOCKERS PROVIDED: COMPLETE SEPARATION FROM LIVING/SLEEPING QUARTERS - Comments: Toilet room door not self closing. Instructed to replace self closing device or keep door closed.
O’DONNELLS	Pass	FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: OBSERVED LITTER/BOTTLE CAPS ON FLOOR AT BAR AND STANDING WATER ON BASEMENT FLOOR. INSTRUCTED MANAGER TO CLEAN/KEEP DRY FLOOR. | 32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: BAR 2-DOOR COOLER RUBBER GASKET RIPPED. INSTRUCTED MANAGER TO REPAIR/REPLACE DOOR GASKET. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: BAR 3-COMPARTMENT SINK HOT/COLD WATER LEAKING AT BASE OF FAUCET ALSO NO BACKFLOW PREVENTION DEVICE AT ICE MACHINE. INSTRUCTED MANAGER TO REPAIR SINK ALSO MUST PROVIDE/MAKE VISIBLE BACK FLOW PREVENTION DEVICE FOR ICE MACHINE. | 43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTHS PROPERLY STORED - Comments: OBSERVED ICE SCOOP IMPROPERLY STORED ON TOP OF ICE MACHINE. INSTRUCTED MANAGER TO PROVIDE CLEAN CONTAINER FOR ICE SCOOP.
ASIAN OUTPOST	Pass	WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: OBSERVED HOOD VENTS WITH ACCUMULATED GREASE. INSTRUCTED TO CLEAN AND MAINTAIN THE HOOD VENTS. | 31. CLEAN MULTI-USE UTENSILS AND SINGLE SERVICE ARTICLES PROPERLY STORED: NO REUSE OF SINGLE SERVICE ARTICLES - Comments: OBSERVED SINGLE SERVICE FOOD TRAYS STORED IMPROPERLY. INSTRUCTED TO STORE SINGLE SERVICE ITEMS COVERED OR INVERTED. | 43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTHS PROPERLY STORED - Comments: OBSERVED BOWLS USED TO SCOOP FOOD PRODUCTS. INSTRUCTED TO USE A SCOOP WITH A HANDLE AND HAVE THE HANDLE UP.
STARS FOOD MARKET INC	Pass	FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: MUST ELEVATE ALL FOOD ITEMS FROM THE FLOOR IN THE WALK-IN COOLER. CLEAN FLOORS IN CORNER AREAS OF PREP AREA, STORAGE ROOM, WASHROOM AND WALK-IN COOLER. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: OBSERVED HEAVY DUST ON THE VENTILATION FAN ON THE CEILING OF THE WASHROOM; CLEAN FAN TO REMOVE DUST OBSERVED. OBSERVED WATER STAINED AND DAMAGED CEILING TILES IN THE WASHROOM AND THE SELLING FLOOR OF THE STORE; MUST REPLACE ALL CEILING TILES WHERE NEEDED. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: OBSERVED LEAKING FROM THE FIRST AND SECOND COMPARTMENTS (UNDERNEATH) OF THE THREE COMP SINK; MUST REPAIR LEAKS FROM THE SINK. MUST PROVIDE THREE METAL DRAIN STOPPERS FOR THE THREE COMP SINK TO PROPERLY SET UP SINK FOR WASH RINSE AND SANITIZING.
DAILY FOOD & LIQUOR	Pass	WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: MUST CLEAN THE FAN COVERS IN THE WALK-IN COOLER WHERE THE BEER IS STORED TO REMOVE DUST OBSERVED. MUST CLEAN THE INTERIOR OF THE VENTILATION FAN IN THE WASHROOM ON THE CEILING TO REMOVE DUST OBSERVED. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: NO BACKFLOW PREVENTOR DEVICE FOUND AT THE UTILITY SINK; MUST INSTALL A BACKFLOW PREVENTOR DEVICE. | 37. TOILET ROOM DOORS SELF CLOSING: DRESSING ROOMS WITH LOCKERS PROVIDED: COMPLETE SEPARATION FROM LIVING/SLEEPING QUARTERS - Comments: NO SELF CLOSING DEVICE FOUND ON THE WASHROOM DOOR; MUST INSTALL A SELF CLOSING DEVICE.
Benjyehuda	Pass	WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: VENTILATION FAN NOT CLEAN,(DUSTY) ABOVE MOP SINK AND IN WASHROOM.MUST CLEAN/MAINTAIN. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: VENTILATION FAN IN WASHROOM NOT WORKING.MUST REPAIR.
HOTEL CHICAGO	Pass	FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: OBSERVED GREASE/FOOD BUILD UP ON FLOOR UNDER COOKING EQUIPMENT. MUST CLEAN FLOOR UNDER AND AROUND COOKING EQUIPMENT AND MAINTAIN. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: OBSERVED DUST/FOOD DEBRIS ON WALLS CEILING TILES AT DISHWASH AND PREP AREA. MUST CLEAN WALLS AND CEILING TILES. | 43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTHS PROPERLY STORED - Comments: METAL ICE SCOOP CRACKED BY HANDLE. MUST REPLACE DAMAGED ICE SCOOP.

The Messages having top Ten NOT so positive sentiments are

DBAName	Results.x	Text
DePriest Elementary	Pass	VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: CORRECTED. | 32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: OBSERVED THE GASKET AROUND THE INTERIOR OF THE ICE MACHINE DOOR IS IN POOR REPAIR; REPLACE GASKET. OBSERVED TWO OF THE THREE GASKETS AT THE THREE DOOR COOLER NEXT TO THE ICE MACHINE LOOSE; REATTACH LOOSE GASKETS OR REPLACE TO AVOID ESCAPING AIR.
TORTOISE CLUB	Fail	FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: OBSERVED SMALL LOW TEMP DISH MAHCINE AT BAR WITH HEAVY LIME BUILD UP UNDERNEATH. DELIME AND MAINTAIN. | 22. DISH MACHINES: PROVIDED WITH ACCURATE THERMOMETERS, CHEMICAL TEST KITS AND SUITABLE GAUGE COCK - Comments: OBSERVED GAUGE COCK ON HOT WATER DISH MACHINE READING 160F. HIGH TEMP TEST STRIPS WERE USED TO INDICATE HOT WATER DISH MACHINE IS SANITIZING AT 180F. NEW GUAGE COCK MUST BE INSTALLED AND MAINTAINED TO MONITOR DISH MACHINE. SERIOUS VIOALTION 7-38-030 | 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING EQUIPMENT PROPERLY STORED - Comments: OBSERVED 6 PACK OF SODA ON FLOOR OF BAR AND BUCKET OF LIMES AND LEMONS ON FLOOR OF BAR. ALL FOOD ITEMS NEED TO BE STORED AT LEAST 6 INCHES OFF FLOOR AT ALL TIMES.
NORTH LAWNDALE SCHOOL COLLEGE PREP	Fail	FACILITIES TO MAINTAIN PROPER TEMPERATURE - Comments: OBSERVED WALK-IN COOLER IN POOR REPAIR, NOT HOLD AT 40’F AND BELOW, COOLER READING 60’F, INSTRUCTED TO RESTRICT USE, COOLER TAGGED, MUST FAX LETTER FOR RE-INSPECTION, ONCE REPAIR, CRITICAL VIOLATION: 7-38-005A | 3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATURE REQUIREMENT DURING STORAGE, PREPARATION DISPLAY AND SERVICE - Comments: OBSERVED POTENTIALLY HAZARDOUS FOODS STORED IN WALK-IN COOLER AT IMPROPER TEMPS, (2) ROLLS OF GROUND BEEF, COOKED CHICKEN, (4) BAGS OF ROAST BEEF, AND (1) BAG OF YOGURT, ALL READING BETWEEN 50’F-58’F, ALL PRODUCT DUMPED AND DENATURED AT A COST OF ABOUT $1,000.00 AND ABOUT 30 POUNDS, CRITICAL VIOLATION: 7-38-005A | 29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-42-090 - Comments: CONTINUED NON COMPLIANCE ON PREVIOUS ORDER ISSUED, DATED 05/12/2016, REPORT #1770612, VIOLATION LISTED BELOW: 34 FLOORS IN POOR REPAIR IN KITCHEN AREA, CRACKED FLOOR TILE NEEDS REPLACED, 35 WALLS IN POOR REPAIR IN DINING AREA, HOLES AND BROKEN PLASTER, INSTRUCTED TO REPAIR, AND BETTER MAINTAIN, SERIOUS VIOLATION: 7-42-090
COOPER ELEMENTARY	Pass	FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: REPAIR LOOSE RUBBER GASKET AT THREE DOOR COOLER IN KITCHEN WHERE LOOSE (UNIT HOLDING AT PROPER TEMPERATURE AT THIS TIME). | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: REPLACE CRACKED FLOOR TILE IN BATHROOM OF ROOM 106. REPLACE CRACKED FLOOR TILE IN BASEMENT OUTSIDE OF ROOM LEADING TO BOYS BATHROOM. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: PEELING PAINT OBSERVED ON WALLS OF LUNCHROOM STAFF WASHROOM, IN HALLWAYS OF BUILDING ON WALLS AND CEILINGS; REMOVE PEELING PAINT AND PAINT AREAS WHERE NEEDED. WALLBASES IN BASEMENT HALLWAY IN POOR REPAIR; REPAIR WHERE NEEDED. REPLACE COVER ON WALL OF GIRLS WASHROOM IN STALL ONE OVER FLUSH BUTTON FOR TOILET; PANEL LOOSE AND HANGING FROM WALL. SEAL AROUND TOILETS AND URINALS TO SEAL HOLES OBSERVED IN BOYS AND GIRLS WASHROOM IN BASEMENT AND THIRD FLOOR WHERE NEEDED.
MARQUETTE	Pass	FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: INTERIOR DOORS OF ALL MILK COOLERS AT SERVING LINES IN POOR REPAIR, MISSING AND LOOSE GASKETS. REPLACE SAME. UNUSED, NON-WORKING HOT HOLDING UNITS ON SITE WITH MISSING GAUGES. INSTD TO REPAIR SAME OR REMOVE. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: LOOSE THRESHOLD AT CAFETERIA EXIT DOOR A. REPAIR SAME AND HAVE TIGHT FITTING.
SUPERMERCADO LA FIESTA #2, INC.	Pass	FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: INTERIOR PANEL OF ICE MACHINE WITH CALCIUM BUILD-UP. INSTD TO CLEAN SAME. WALK-IN COOLER DOOR GASKETS IN POOR REPAIR, MISSING IN SECTIONS, LOOSE. REPAIR SAME AND HAVE TIGHT FITTING. IMPROPER LARGE PLASTIC CONTAINERS BEING USED TO STORE CHICKEN. INSTD TO USE PROPER FOOD GRADE CONTAINERS. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: URINAL IN TOILET ROOM IN POOR REPAIR. REPAIR SAME. REPAIR LOOSE PIPE UNDER UTILITY SINK.
CERMAK PRODUCE #5 LTD	Pass	FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: BASEMENT WALK IN COOLER FLOOR HAS BUILD UP OF DEBRIS. MUST DETAIL CLEAN BASEMENT WALK-IN COOLER FLOOR. TILES IN FRON OF PRODUCE DISPLAY COUNTER ARE MISSING OR DAMAGE . MUST REPLACE MISSING AND DAMAGE TILES. | 36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED - Comments: LIGHT SHIELDS ARE MISSING ON DISPLAY COLD HOLD UNITS THUR OUT THE STORE. MUST INSTALL LIGHT SHIELDS ON COLD HOLD DISPLAY UNITS.