Overview

This integration adds expert reasoning capabilities from Claude Sonnet 4.5 (via Amazon Bedrock) to improve data analysis accuracy and code quality. Claude acts as a senior data scientist that reviews requests and provides guidance before code execution.

Architecture

Two-Model Reasoning System

graph TB
    subgraph "User Layer"
        A[User Request Show sales trend by month]
    end

    subgraph "Reasoning Layer - Claude Sonnet 4.5"
        B1[🧠 Claude Bedrock Expert Reasoning]
        B2[Analyze Request]
        B3[Review Data Structure]
        B4[Provide Guidance]
    end

    subgraph "Execution Layer - OpenAI GPT-4o"
        C1[💻 Code Interprete with Claude's Guidance]
        C2[Generate Code]
        C3[Execute Code]
        C4[Return Results]
    end

    A --> B1
    B1 --> B2
    B2 --> B3
    B3 --> B4
    B4 --> C1
    C1 --> C2
    C2 --> C3
    C3 --> C4
    C4 --> E[Beautiful Chart<br/>+ Analysis]

    style B1 fill:#FF6B6B,stroke:#333,stroke-width:3px
    style C1 fill:#4ECDC4,stroke:#333,stroke-width:3px
    style E fill:#00ff00,stroke:#333,stroke-width:3px

Why Two Models?

Model Role Strength Use Case
Claude Sonnet 4.5 Reasoning Expert Deep analysis, context understanding Review & guide
GPT-4o Code Interpreter Code Generator Code execution, fast response Generate & execute

Integration Flow

sequenceDiagram
    participant User
    participant Agent as DataFrameAgentTransformer
    participant Claude as AWS Bedrock<br/>Claude Sonnet 4.5
    participant OpenAI as OpenAI GPT-4o<br/>Code Interpreter
    participant Executor as Python Executor

    User->>Agent: "Create bar chart of sales by category"

    Note over Agent: Gather context:<br/>- DataFrame info<br/>- Available columns<br/>- Theme (dark/light)

    Agent->>Claude: Request reasoning<br/>(context + request)

    Note over Claude: Analyze:<br/>1. Best chart type<br/>2. Data validation<br/>3. Optimization tips<br/>4. Visualization style

    Claude-->>Agent: Expert Guidance:<br/>- Sort by value DESC<br/>- Limit to top 20<br/>- Use horizontal bars<br/>- Apply theme colors

    Note over Agent: Build enhanced prompt<br/>with Claude's guidance

    Agent->>OpenAI: Enhanced prompt with:<br/>- User request<br/>- Claude's reasoning<br/>- Code template<br/>- Best practices

    Note over OpenAI: Generate code<br/>following guidance

    OpenAI-->>Agent: Python code

    Agent->>Executor: Execute code
    Executor-->>Agent: Results + Plot
    Agent-->>User: Beautiful chart<br/>with analysis