Data Architect & Business Strategist (CSV Audit & Pipeline)
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
-
Caching Architect Agent Role
Prompts# 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…
-
Data Validator Agent Role
Prompts# 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…
-
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)}…
-
Architectural Expert
PromptsI 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…
-
System Architect Agent Role
Prompts# 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…
-
Unity Architecture Specialist
Prompts--- 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…