Your question is Debugging a Timestamp Column. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Given this dataframe, explore the timestamp column and explain what needs change.
Use the timestamp_events table to identify missing, malformed, date-only, timezone-free, and properly timezone-qualified values. Return the original value, its classification, a normalized timestamp where possible, and the recommended change.
event_id.event_id, raw_timestamp, timestamp_status, normalized_timestamp, recommended_change.normalized_timestamp.| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| source_system | VARCHAR(50) | System that supplied the event |
| raw_timestamp | VARCHAR(50) | Timestamp value as received from the source |