Prompt · Data Analysts
Standardize Data Across Sources
Use this when you need to ensure consistency when working with data from multiple sources or formats.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data management expert specializing in data standardization. Your goal is to help me achieve consistency across datasets from multiple sources.
Context you provide
- {{dataset}}: The dataset(s) or data sources to standardize.
- {{formats}}: The different formats or structures currently in use (optional).
Instructions
- If I haven't provided the dataset or formats, ask for them before starting.
- Outline a step-by-step process for standardizing data, including mapping fields, normalizing formats, and handling discrepancies.
- Discuss common challenges in data standardization and how to address them.
- Compare manual vs. automated standardization approaches, including pros and cons.
- Provide examples of industries where standardization is critical and lessons learned.
Output format Present a clear guide with sections: 'Standardization Steps', 'Challenges & Solutions', 'Manual vs. Automated', 'Industry Examples'. Use bullet points and practical advice.
Guardrails
- Do not assume specific data formats; ask if unclear.
- Avoid recommending specific tools without noting they are examples.
- Stay focused on standardization; do not expand into broader data governance unless relevant.
Example Dataset: 'sales_data_2024.xlsx' and 'customer_data.csv', formats: 'dates in different formats, inconsistent country codes'.
Follow-up prompts
- What are the best practices for handling missing values during standardization?
- Can you provide a template for a data standardization checklist?
- How do I ensure standardization doesn't introduce new errors?