Skip to main content

Using Code Mode for Data Analysis

The video demonstrates Team AI's Code Mode, showing how to upload data files for analysis, create visualizations like charts, and perform detailed data breakdowns without manual coding.

Christopher Varner avatar
Written by Christopher Varner
Updated over a week ago

Overview

Code Mode enables non-technical users to perform data analysis, create visualizations, and generate statistical summaries using natural language prompts. Upload a CSV file and use conversational commands to analyze trends, create charts, and format results for stakeholders—no coding required.

Learning Objectives:

  • Upload and analyze CSV data using natural language

  • Generate statistical summaries and breakdowns

  • Create line charts, bar charts, and other visualizations

  • Repurpose analysis into emails and business formats

Prerequisites

You'll Need:

  • Active TeamAI account

  • CSV file with data to analyze

  • Basic understanding of your dataset

  • Clear idea of insights you want to extract


Access Code Mode

Enable Data Analysis Environment

  1. Navigate to chat interface

    • In left panel, click "Chats"

  2. Activate Code Mode

    • Locate "Modes" section at bottom of chat window

    • Click "Code Mode" option

Result: TeamAI switches to data analysis mode with optimized AI model for code execution.

Tip: Uploading a CSV file automatically switches to Code Mode even if you're in Web Search Mode.


Upload Data

Import CSV File

  1. Click upload button

    • Click "+" icon in chat input area

    • Select "Upload File" from menu

  2. Select CSV file

    • Choose file from your computer

    • File must have clear headers in first row

  3. Confirm upload

    • File name appears in chat input

    • TeamAI confirms file is ready for analysis

Result: CSV data is loaded and ready for analysis commands.

Warning: Very large CSV files may take longer to process. Ensure headers are clear to avoid confusion.


Request Basic Analysis

Get Statistical Summary

  1. Enter analysis prompt

    • Type: "Give me a detailed breakdown of this sheet"

    • Press Enter to send

  2. Review statistical output

    • Code Mode returns:

      • Measures of central tendency (mean, median)

      • Measures of dispersion (standard deviation)

      • Minimum and maximum values

      • Data distribution insights

Result: Comprehensive overview of your dataset's characteristics.


Create Visualizations

Generate Charts

  1. Request specific chart

    • Be explicit: "Give me a line chart showing closing price by month"

    • Specify axes: "Use Date column for X-axis and Price column for Y-axis"

  2. Enter prompt

    text

    Copy

    Create a line chart showing monthly closing prices X-axis: Date column Y-axis: Closing_Price column
  3. View generated chart

    • Chart appears directly in chat interface

    • Professional visualization with proper labels

    • Visual trends and patterns are immediately visible

Result: Professional chart displaying your data trends.

Best For: Time-series data like stock prices, sales figures, performance metrics

Tip: Try different chart types (bar, scatter, pie) to find what best highlights your patterns.


Repurpose Analysis

Format for Business Use

  1. Request format change

    • Example: "Put this analysis into an email for my boss"

    • Alternative: "Format as a bullet-point summary for stakeholders"

  2. Specify audience

    • Mention stakeholder type: "Make this technical analysis understandable for non-technical managers"

Result: Analysis translated into business-friendly language ready to share.


Best Practices

  1. Be specific - Request particular statistical measures or chart types

  2. Specify axes - Clearly state which columns for X and Y axes

  3. Check date formats - Ensure CSV has properly formatted date columns for time-series

  4. Experiment - Try different visualizations for same data

  5. Follow up - Ask clarifying questions about specific data points

  6. Start simple - Request basic breakdown before complex analysis


Common Questions

Q: What file types can I analyze?
A: CSV is primary. Also supports Excel, JSON, and potentially databases.

Q: Can Code Mode handle missing data?
A: Yes. It identifies and reports missing values in your dataset.

Q: How complex can visualizations be?
A: You can request specific chart types with particular columns on each axis. Advanced multi-series charts are supported.

Q: Can I export visualizations?
A: Yes. Most visualizations can be copied/pasted as images.

Q: Does it support predictive analysis?
A: Demo focused on descriptive statistics, but you can request predictions, correlations, and trend forecasting with specific prompts.

Did this answer your question?