Python data engineering interview problem. Difficulty: beginner. Pattern: Strings. About 10 minutes. Part of the Pro drill bank.
Support tickets arrive as messy free text. A triage job needs the single most common word so agents can tag the queue (login, refund, shipping) without reading every ticket.
From a block of ticket text, return the one most frequent word after normalizing case and dropping punctuation.
Input: most_common_word('Red red BLUE blue blue') Output: 'blue' This input follows the stated rules and produces this output.
Topics: lakebench, python, strings.
More Python interview questions · All interview problems · Learn data engineering
Interview-style drill: Given a block of ticket text, return the single most frequent word.
From a block of ticket text, return the one most frequent word after normalizing case and dropping punctuation.