Sentiment Tagging from Feedback | Dataford Interview Questions

Describe how you would use Python or R to clean an unstructured dataset of user feedback and build a baseline sentiment tagger.

For this SQL implementation, clean the feedback text and assign a rule-based baseline sentiment label using the available feedback and channel data. Treat missing or empty feedback as unknown, and preserve feedback even when its channel is unmatched.

Output

One row per feedback record with feedback_id, channel_name, cleaned_feedback, and sentiment_tag
Include positive, negative, mixed, neutral, and unknown labels where applicable
Order by feedback_id ascending

Schema

user_feedback

Column	Type	Description
feedback_idPK	INT	Unique feedback record identifier
channel_id	INT	Identifier of the feedback channel
feedback_text	TEXT	Raw unstructured user feedback
submitted_at	TIMESTAMP	Timestamp when the feedback was submitted

feedback_channels

Column	Type	Description
channel_idPK	INT	Unique channel identifier
channel_name	VARCHAR(100)	Human-readable feedback channel name
channel_type	VARCHAR(50)	General type of feedback channel

Your question is Sentiment Tagging from Feedback. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem