data-analysis-cellcog

name	data-analysis-cellcog
description	AI data analysis and visualization powered by CellCog. Data cleaning, exploratory analysis, hypothesis testing, statistical reports, ML model evaluation, dataset profiling, charts, dashboards. Upload CSVs and get analysis back with full Python access.
metadata	{"openclaw":{"emoji":"🔢","os":["darwin","linux","windows"],"requires":{"bins":"[Truncated]","env":"[Truncated]"}}}
author	CellCog
homepage	https://cellcog.ai
dependencies	["cellcog"]

Data Analysis - Your Data Has Answers, CellCog Finds Them

Data analysis and visualization from uploaded files.

Most AI tools return code when you ask about data. CellCog returns answers — actual charts, clean datasets, statistical reports, and visual dashboards. Upload messy CSVs with a minimal prompt, and CellCog's coding agent explores your data, finds the patterns, and presents them beautifully. Full Python access for everything from data cleaning to ML model evaluation.

How to Use

For your first CellCog task in a session, read the cellcog skill for the full SDK reference — file handling, chat modes, timeouts, and more.

OpenClaw (fire-and-forget):

result = client.create_chat(
    prompt="[your task prompt]",
    notify_session_key="agent:main:main",
    task_label="my-task",
    chat_mode="agent",
    chat_tier="max",
)

All agents except OpenClaw (blocks until done):

from cellcog import CellCogClient
client = CellCogClient(agent_provider="openclaw|cursor|claude-code|codex|...")
result = client.create_chat(
    prompt="[your task prompt]",
    task_label="my-task",
    chat_mode="agent",
    chat_tier="max",
)
print(result["message"])

---

What Makes Data-Cog Different

Code as Tool, Not as Output

Other AI tools give you Python code and say "run this." CellCog runs the code for you and delivers the results:

Other AI Tools	Data-Cog
"Here's a pandas script to analyze your data"	Here are your actual insights with charts
"Run this matplotlib code to see the chart"	Here's the chart, annotated with findings
"This SQL query will find outliers"	Found 23 outliers, here's what they mean
"You'll need scikit-learn for this"	Model trained, here's accuracy and feature importance

You upload data. You get answers. The code runs behind the scenes.

---

What Data Work You Can Do

Exploratory Data Analysis

Understand your data fast:

• Dataset Profiling: "Analyze this CSV — distributions, missing values, outliers, correlations, and data quality summary"
• Pattern Discovery: "What patterns and trends exist in this sales data? Surprise me."
• Anomaly Detection: "Find unusual patterns in this server log data — what looks abnormal?"
• Relationship Analysis: "What factors most strongly correlate with customer churn in this dataset?"

Example prompt:

"Analyze this dataset: <SHOW_FILE>/path/to/customer_data.csv</SHOW_FILE>

I don't know much about this data yet. Give me:

• Overview: rows, columns, data types, missing values
• Key distributions and summary statistics
• Most interesting correlations
• Any outliers or data quality issues
• 3-5 insights that jump out

Present findings as an interactive HTML report with charts."

Data Cleaning & Transformation

Wrangle messy data into shape:

• Clean Messy Data: "Clean this CSV — fix inconsistent date formats, handle missing values, remove duplicates, standardize column names"
• Data Transformation: "Pivot this transaction data into a monthly summary by product category"
• Data Merging: "Join these three CSV files on customer_id and create a unified dataset"
• Feature Engineering: "Create useful features from this raw data for predicting house prices"

Example prompt:

"Clean and transform this dataset: <SHOW_FILE>/path/to/messy_data.csv</SHOW_FILE>

Issues I know about:

• Dates are in mixed formats (MM/DD/YYYY and YYYY-MM-DD)
• 'Revenue' column has some values with $ signs and commas
• Duplicate rows exist
• Missing values in 'Region' column

Clean it up and give me back a clean CSV plus a summary of what you changed."

Statistical Analysis

Rigorous analysis with real numbers:

• Hypothesis Testing: "Is there a statistically significant difference in conversion rates between our A and B variants?"
• Regression Analysis: "What factors predict employee salary in this HR dataset? Build a regression model."
• Time Series Analysis: "Analyze this monthly revenue data — trend, seasonality, and forecast next 6 months"
• Cohort Analysis: "Create a cohort analysis showing user retention by signup month"

Example prompt:

"I ran an A/B test on our checkout page: <SHOW_FILE>/path/to/ab_test_results.csv</SHOW_FILE>

Columns: user_id, variant (A or B), converted (0/1), revenue, timestamp

Tell me:

• Is variant B statistically better? (p-value, confidence interval)
• Conversion rate difference
• Revenue per user difference
• Sample size adequacy check
• My recommendation: ship B or keep testing?

Present with clear charts and a plain-English conclusion."

Visualization & Reporting

Turn data into visual stories:

• Chart Generation: "Create a set of charts showing our quarterly performance from this data"
• Dashboard Reports: "Build an interactive dashboard from this sales dataset with filters by region and product"
• Presentation-Ready Visuals: "Create publication-quality charts from this research data"
• Comparison Visuals: "Visualize how our metrics compare to industry benchmarks"

Machine Learning

Applied ML without the setup:

• Classification: "Predict which customers will churn based on this dataset — train a model, show feature importance"
• Clustering: "Segment these customers into groups based on behavior — how many natural clusters exist?"
• Forecasting: "Forecast next quarter's sales using this historical data"
• Model Evaluation: "I trained a model — here are the predictions. Evaluate: accuracy, precision, recall, confusion matrix, ROC curve"

Example prompt:

"Predict customer churn from this dataset: <SHOW_FILE>/path/to/customer_features.csv</SHOW_FILE>

Target column: 'churned'

• Train a model, try at least 2 algorithms
• Show feature importance — what drives churn?
• Confusion matrix and ROC curve
• Plain-English summary: 'The top 3 reasons customers churn are...'
• Actionable recommendations based on findings

I want insights, not just metrics."

---

Supported Data Formats

Format	How to Send
CSV	Upload via SHOW_FILE
Excel (XLSX)	Upload via SHOW_FILE
JSON	Upload via SHOW_FILE
Parquet	Upload via SHOW_FILE
SQL exports	Upload the dump via SHOW_FILE
Inline data	Describe small datasets directly in prompt

---

Output Formats

Format	Best For
Interactive HTML Dashboard	Explorable charts, filters, drill-downs
PDF Report	Shareable analysis reports with charts and findings
Clean CSV/XLSX	Cleaned or transformed data files for downstream use
Markdown	Quick insights for integration into docs

---

Choosing Mode & Tier

Use chat_mode="agent", chat_tier="max" for data analysis. Analysis is coding work — pipelines, statistics, and modeling need the deepest tier.

Scenario	Recommended
All data analysis and ML work	chat_mode="agent", chat_tier="max"
Trivial one-column summaries	chat_mode="agent" (defaults to "flash")

Agent Team (chat_mode="team") is reserved for deep research — data analysis runs best on Agent max.

---

Example Prompts

Minimal prompt, maximum insight:

"Analyze this: <SHOW_FILE>/path/to/data.csv</SHOW_FILE>

Tell me everything interesting."

That's it. CellCog's coding agent will profile the data, run exploratory analysis, find patterns, and present findings with charts. You don't need to know what to ask — the agent figures it out.

Business analysis:

"Analyze our e-commerce data: <SHOW_FILE>/path/to/orders.csv</SHOW_FILE>

I need:

• Revenue trends (daily, weekly, monthly)
• Best and worst performing products
• Customer purchase frequency distribution
• Average order value trends
• Seasonal patterns
• Top 5 actionable insights for growing revenue

Interactive HTML dashboard with all charts."

Research data analysis:

"Analyze this survey data from 500 respondents: <SHOW_FILE>/path/to/survey.csv</SHOW_FILE>

Research questions:

1. Is there a significant relationship between age group and product preference?
2. Do satisfaction scores differ by region? (ANOVA)
3. What factors best predict likelihood to recommend? (regression)

Include: statistical tests, p-values, effect sizes, and publication-ready charts. PDF report format."

---

Tips for Better Data Analysis

1. Just upload and ask: You don't need to describe every column. CellCog reads the data and figures out what's there.

2. State your question: "What drives churn?" is more focused than "Analyze this data." Both work, but the first gets faster results.

3. Mention the audience: "For my CEO" means executive summary. "For the data team" means show the methodology.

4. Specify what you'll do with it: "I need to present this to the board" vs "I need clean data for my ML pipeline" — context shapes the output.

5. Don't over-specify methods: Let CellCog choose the right statistical approach. Say what you want to learn, not which algorithm to use.

6. Iterate: Upload data → get initial analysis → ask follow-up questions → go deeper. CellCog maintains context across messages.

---

If CellCog is not installed

Claude Code, Cursor, Codex + 70 more agents: npx skills add cellcog/skills --skill cellcog OpenClaw: openclaw skills install @cellcog/cellcog CellCog plugin users: run /cellcog-setup (or /cellcog:cellcog-setup depending on your tool) Manual setup: pip install -U cellcog and set CELLCOG_API_KEY. See the cellcog skill for SDK reference.