Clean inconsistent date formats and text categories
Turn chaotic timestamp formats and varied categorical spellings into unified standards. Use it when mismatched export values break dashboards.
You getCategorical Standardization, timestamp Fixes and SQL or Python Cleanup Snippet
Prompt
Act as a data cleaning specialist. Standardize the inconsistent date strings, timestamps, and categorical labels provided below.
- Convert all timestamps to standard ISO 8601 (YYYY-MM-DD HH:MM:SS) format, noting any ambiguous dates (such as DD/MM vs MM/DD).
- Group messy categorical values into clean, canonical categories using snake_case or proper title case.
- Provide a clean mapping dictionary or conversion rules for automated cleaning.
Output format:
1. Categorical Standardization: Table showing Original Value, Canonical Value, Rule
2. Timestamp Fixes: Table showing Original String, Inferred Format, Standardized ISO 8601 Output, Ambiguity Flag
3. SQL or Python Cleanup Snippet: Ready-to-run transformation code
The raw values are below:Example output
Paste your raw text lists, sample CSV columns, or category dumps into Claude, ChatGPT or Gemini. Follow up by asking for an equivalent Pandas or dbt SQL replacement snippet if you use a specific stack.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Differentiate structural null values from missing data
Identify whether null values represent expected business logic or export dropouts. Use it when auditing schema quality or preparing datasets for modeling.
Compare cumulative customer lifetime value across monthly cohorts
Spot whether newer customer groups spend faster or retain better than older cohorts. Use this to audit acquisition quality over time.
Estimate potential revenue recovery across funnel drop-off points
Model the financial impact of repairing conversion drop-offs across your funnel. Use this to prioritize engineering fixes by projected dollar value.
Isolate regional or platform drivers behind KPI drops
Break down aggregate product or revenue declines across platform and geographic dimensions. Use this when global numbers drop and leadership needs the root driver.
Map inconsistent export columns to target schemas
Match disparate, poorly named export headers to a structured target data schema. Use it when consolidating CSV reports from multiple platforms.
Resolve split device identities into single user records
Merge fragmented anonymous device IDs and authenticated profiles into unified user journeys. Use it when multi-device activity skews active user counts.
- Segment conversion funnel drop-offs by device and marketing channel
- Separate true anomalies from pipeline data errors
- Translate statistical model outputs into plain business decisions
- Build standardized KPI definition templates for teams
- Detect hidden assumptions in reported dashboard numbers
- Evaluate marketing channel efficiency from campaign performance data