Prompt to Prompt: CSV Audit and Cleaning Pipeline
Prompt to Prompt: CSV Audit and Cleaning Pipeline is a verified PROMPT blueprint on Promptally in System & Base Contexts optimized for leading AI models. Curated Data prompt from awesome-prompts library split. Available to explore, customize with pre-filled variables, and copy with zero authentication required.
Created by @promptallyTechnical Specifications
| Specification | Value |
|---|---|
| Artifact type | PROMPT (System & Base Contexts) |
| Compatible engines | Universal / Model Agnostic |
| Input variables | None (pre-filled) |
| Approximate tokens | 344 |
| Source file | prompt-prompt-csv-audit-and-cleaning-pipeline.txt |
| Access tier | Free public (MIT) |
Pre-Filled Template
I want you to act as a Senior Data Science Architect and Lead Business Analyst. I am uploading a CSV file that contains raw data. Your goal is to perform a deep technical audit and provide a production-ready cleaning pipeline that aligns with business objectives. Please follow this 4-step execution flow: Technical Audit & Business Context: Analyze the schema. Identify inconsistencies, missing values, and Data Smells. Briefly explain how these data issues might impact business decision-making (e.g., Inconsistent dates may lead to incorrect monthly trend analysis). Statistical Strategy: Propose a rigorous strategy for Imputation (Median vs. Mean), Encoding (One-Hot vs. Label), and Scaling (Standard vs. Robust) based on the audit. The Implementation Block: Write a modular, PEP8-compliant Python script using pandas and scikit-learn. Include a Pipeline object so the code is ready for a Streamlit dashboard or an automated batch job. Post-Processing Validation: Provide assertion checks to verify data integrity (e.g., checking for nulls or memory optimization via down casting). Constraints: Prioritize memory efficiency (use appropriate dtypes like int8 or float32). Ensure zero data leakage if a target variable is present. Provide the output in structured Markdown with professional code comments. I have uploaded the file. Please begin the audit.
How to use this prompt
- Review the pre-filled example and source files above.
- Copy the template or download
prompt-prompt-csv-audit-and-cleaning-pipeline.txt, then use it in your model, IDE, or workflow tool. - Compare your result with the sample output when one is provided.
Frequently Asked Questions
How do I use Prompt to Prompt: CSV Audit and Cleaning Pipeline?
Open the prompt on Promptally, review the pre-filled example, then copy the template or download prompt-prompt-csv-audit-and-cleaning-pipeline.txt and paste it into your model, IDE or workflow tool. Prompt to Prompt: CSV Audit and Cleaning Pipeline is a static blueprint with no dynamic variables. Copy it and use it as-is.
Is Prompt to Prompt: CSV Audit and Cleaning Pipeline free?
Yes. Prompt to Prompt: CSV Audit and Cleaning Pipeline is free to view, copy and download on Promptally without creating an account. It is published under the MIT license.
What variables does Prompt to Prompt: CSV Audit and Cleaning Pipeline need?
Prompt to Prompt: CSV Audit and Cleaning Pipeline is a static blueprint with no dynamic variables. Copy it and use it as-is.