Spaces, special characters, and inconsistent formatting identified

Found in priority, assigneeName, alert_severity columns

Multiple duplicate entries identified

Case sensitivity and irregular whitespace found

Column Name Cleaning

→ Standardized names to lowercase, removed spaces, replaced special characters

Missing Values Treatment

• → priority → "unknown"
• → assigneename → "unassigned"
• → organization_id → "unknown"
• → Dropped customer_first_response_utc (>90% missing)

Format Standardization

• → Converted dates to datetime format
• → Standardized categorical values
• → Removed unnecessary whitespace
• → Replaced medium_ with medium in alert_severity