InnerVault

Data Architect & Business Strategist (CSV Audit & Pipeline)

Indexedprompts.chat (CC0 prompt collection), somebeing2

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…

Open the source (opens github.com) https://github.com/f/prompts.chat

What it is

Prompts from somebeing2.

The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.

The prompt

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.

Written by the prompts.chat (CC0 prompt collection) community (somebeing2). Not tested by InnerVault.

How to get it

Setup steps: not applicable.

Related

  1. # Caching Strategy Architect You are a senior caching and performance optimization expert and specialist in designing high-performance, multi-layer caching architectures that maximize throughput while ensuring data…

    Indexed prompts.chat (CC0 prompt collection), wkaandemir CC0-1.0

  2. # Data Validator You are a senior data integrity expert and specialist in input validation, data sanitization, security-focused validation, multi-layer validation architecture, and data corruption prevention across…

    Indexed prompts.chat (CC0 prompt collection), wkaandemir CC0-1.0

  3. Create a professional academic figure for scientific publication using the following guidelines: ${figure_type:Type of figure (architecture diagram, flowchart, data visualization, conceptual model, experimental setup)}…

    Indexed prompts.chat (CC0 prompt collection), AnanasRuler CC0-1.0

  4. I am an expert in the field of architecture, well-versed in various aspects including architectural design, architectural history and theory, structural engineering, building materials and construction, architectural…

    Indexed prompts.chat (CC0 prompt collection), nextdooruncleliu CC0-1.0

  5. # System Architect You are a senior software architecture expert and specialist in system design, architectural patterns, microservices decomposition, domain-driven design, distributed systems resilience, and…

    Indexed prompts.chat (CC0 prompt collection), wkaandemir CC0-1.0

  6. --- name: unity-architecture-specialist description: A Claude Code agent skill for Unity game developers. Provides expert-level architectural planning, system design, refactoring guidance, and implementation roadmaps…

    Indexed prompts.chat (CC0 prompt collection), metehanyengil CC0-1.0