Python Data Analysis Script

Generate a complete Python data analysis pipeline with cleaning, visualization, and insights.

๐Ÿ“ The Prompt

Write a Python script to analyze [DATASET]. Data: - Format: [CSV/JSON/Excel] - Key columns: [LIST] - Size: [ROWS] - Goals: [INSIGHTS WANTED] Script should: 1. **Load and clean** โ€” Missing values, duplicates, types 2. **Explore** โ€” Summary stats, distributions 3. **Calculate** โ€” [SPECIFIC METRICS] 4. **Visualize** โ€” [CHART TYPES] with matplotlib/seaborn 5. **Insights** โ€” Print key findings 6. **Export** โ€” Save results Use pandas, matplotlib/seaborn. PEP 8. Docstrings. Error handling.

๐Ÿ’ก Tips for Better Results

Share sample data rows for accurate column handling.

๐ŸŽฏ Use Cases

Data analysts, data scientists, business analysts, researchers.

๐Ÿ”— Related Prompts

๐Ÿ“Š Data & Analytics intermediate

Write Complex SQL Queries

Generate optimized SQL queries for complex analysis with CTEs, JOINs, and performance tips.

๐Ÿ“Š Data & Analytics intermediate

Build an RFM Customer Segmentation Model for Targeted Marketing

Create a complete RFM customer segmentation model with scoring logic, code implementation, and marketing strategies.

๐Ÿ“Š Data & Analytics advanced

Design a Robust ETL Pipeline Architecture for Your Data Platform

Design a complete ETL pipeline architecture with extraction, transformation, loading strategies, error handling, and governance.

๐Ÿ“Š Data & Analytics intermediate

Create a Comprehensive Data Quality Checklist for Your Dataset

Generate a tailored data quality checklist with SQL validation queries, severity levels, and a scoring framework for any dataset.

๐Ÿ“Š Data & Analytics advanced

Analyze and Interpret A/B Test Results with Statistical Rigor

Get a complete A/B test analysis with statistical significance, power analysis, validity checks, and a clear ship decision.

๐Ÿ“Š Data & Analytics advanced

Design a Scalable ETL Pipeline Architecture for Your Data Platform

Design a production-ready ETL pipeline architecture with tool recommendations, error handling, and scalability strategies.