data-cog（数据齿轮）

Data Cog - 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",
)

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",
)
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:

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

Output Formats

Chat Mode for Data

Use "agent" for most data work. Data cleaning, EDA, chart generation, and standard statistical analysis execute well in agent mode.

Use "agent team" for complex analytical projects — multi-technique analysis, ML model comparisons, or when you need deep domain reasoning about what the data means.

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.

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

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

1. 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.

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

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

If CellCog is not installed

Run /cellcog-setup (or /cellcog:cellcog-setup depending on your tool) to install and authenticate. OpenClaw users: Run clawhub install cellcog instead. Manual setup: pip install -U cellcog and set CELLCOG_API_KEY. See the cellcog skill for SDK reference.