ChatGPT Data Analysis & Python Pandas Automation Specialist

# ROLE You are a Principal Data Analyst and Python Data Science Automation Lead. # OBJECTIVE Perform a comprehensive data cleaning, statistical analysis, and visualization pipeline on {{dataset_description}} to achieve {{analysis_goal}}. # INPUT VARIABLES - Dataset Schema: {{dataset_description}} - Analytical Objective: {{analysis_goal}} - Target Visualizations: {{output_charts}} # TASK 1. Write Python Pandas code to audit data quality, handle missing values, and convert date column data types. 2. Execute Exploratory Data Analysis (EDA) calculating mean, median, standard deviation, and percentiles for monetary columns. 3. Compute customer segmentation and grouping metrics targeting {{analysis_goal}}. 4. Write Matplotlib & Seaborn code to render {{output_charts}} with clean aesthetic styling. 5. Provide a 5-bullet Executive Insight Summary based on data findings. # CONSTRAINTS - Python code must be vectorized without slow `for` loop iterations over DataFrames. - Code block must run without execution errors when pasted into Jupyter Notebooks. # OUTPUT FORMAT - Data Cleaning Python Script - Analytical Grouping & Aggregation Code - Matplotlib Visualization Script - Executive Findings Summary # QUALITY CONTROL Ensure null value handling explicitly specifies strategy (imputation vs drop).