← LeaderboardThe Skill Leaderboard

streamline-analyst-guide

End-to-end data analysis AI agent with Streamlit UI

Published by brycewang-stanford ↗brycewang-stanford/Auto-Empirical-Research-Skills

Try your first task

streamline-analyst-guide

Start a fresh conversation. Replace the highlighted placeholders.

Use streamline-analyst-guide to analyze [dataset] to answer [analysis goal], using interactive data cleaning, exploratory analysis, and—if applicable—a baseline predictive model; deliver an HTML findings report, cleaned dataset, and documented evaluation results.

Required inputs

  • [dataset]
  • [analysis goal]

User-approved starter prompt based on a pinned source version; check current skill requirements before running. Task evidence ↗

SKILL.md

name: streamline-analyst-guidedescription: "End-to-end data analysis AI agent with Streamlit UI"metadata:   openclaw:     emoji: "📈"    category: "analysis"    subcategory: "wrangling"    keywords: ["data analysis", "Streamlit", "automated EDA", "machine learning", "data science", "AI analyst"]    source: "https://github.com/Wilson-ZheLin/Streamline-Analyst"

Streamline Analyst Guide

Overview

Streamline Analyst is an end-to-end data analysis AI agent with a Streamlit web interface. Upload a dataset and describe your analysis goal in natural language — the agent handles data cleaning, EDA, feature engineering, model training, evaluation, and report generation. Provides an interactive UI for reviewing each step and adjusting parameters.

Installation

git clone https://github.com/Wilson-ZheLin/Streamline-Analyst.git
cd Streamline-Analyst
pip install -r requirements.txt
streamlit run app.py

Workflow

Upload Dataset (CSV, Excel, Parquet)
         ↓
   Data Profiling
   ├── Column types and distributions
   ├── Missing value analysis
   ├── Correlation matrix
   └── Outlier detection
         ↓
   Data Cleaning (interactive)
   ├── Handle missing values
   ├── Remove/fix outliers
   ├── Type conversions
   └── Feature encoding
         ↓
   EDA (automated + custom)
   ├── Univariate analysis
   ├── Bivariate relationships
   ├── Statistical tests
   └── Custom visualizations
         ↓
   Modeling (if applicable)
   ├── Train/test split
   ├── Model selection + training
   ├── Hyperparameter tuning
   └── Evaluation metrics
         ↓
   Report Generation

Features

# Streamline Analyst provides:

# 1. Smart data profiling
# - Auto-detect column types (numeric, categorical, datetime)
# - Distribution analysis per column
# - Missing value patterns (MCAR, MAR, MNAR hints)
# - Correlation analysis with significance

# 2. Interactive cleaning
# - Imputation strategies (mean, median, mode, KNN, model)
# - Outlier handling (IQR, Z-score, isolation forest)
# - Encoding (one-hot, label, target, ordinal)
# - Scaling (standard, minmax, robust)

# 3. Automated EDA
# - Distribution plots (histogram, KDE, box, violin)
# - Relationship plots (scatter, pair, heatmap)
# - Time series decomposition
# - Statistical tests (t-test, ANOVA, chi-square, Mann-Whitney)

# 4. Model pipeline
# - Classification: LR, RF, GBM, SVM, MLP
# - Regression: LR, RF, GBM, SVR, ElasticNet
# - Cross-validation with confidence intervals
# - Feature importance visualization
# - SHAP explanations

# 5. Report
# - HTML report with all plots and findings
# - Downloadable cleaned dataset
# - Model artifacts (pickle)

Natural Language Interface

### Example Prompts
- "Show me the distribution of all numeric columns"
- "Is there a significant difference in income between genders?"
- "Build a classifier to predict churn using all features"
- "What are the top 5 most important features for prediction?"
- "Clean the data: fill missing values and remove outliers"
- "Generate a summary report of this dataset"

Use Cases

  1. Quick EDA: Rapid exploration of unfamiliar datasets
  2. Data cleaning: Interactive preprocessing with AI guidance
  3. Baseline models: Quick ML prototyping without coding
  4. Report generation: Automated analysis reports
  5. Teaching: Interactive data science demonstrations

References