# Microgram: dataframe-join

`station__algovigilance__microgram-dataframe-join` · native (always callable) · domain `algovigilance` · pv-relevance `pv-core`

Join two DataFrames on shared key columns. Join types: inner, left, right, outer, semi, anti. Provide left and right DataFrames as separate column objects and the key column names.

## Agent metadata

- `idempotent`: true
- `read_only`: true
- `expected_latency_ms`: unknown (not yet contract-tested)
- `cost_tokens_estimate`: unknown

## Input schema

- `left` *object* (required) — Left DataFrame: column name to array of values
- `right` *object* (required) — Right DataFrame: column name to array of values
- `on` *object* (required) — Key column names present in both DataFrames
- `how` *string* — Join type: inner (default), left, right, outer, semi, anti

## Example call

```json
POST /api/mcp
Content-Type: application/json

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "station__algovigilance__microgram-dataframe-join",
    "arguments": {
      "left": {},
      "right": {},
      "on": {}
    }
  }
}
```

## Related

- [/tools](/tools) — all 7718 tools
- [/tools/algovigilance__microgram-dataframe-join](/tools/algovigilance__microgram-dataframe-join) — HTML page
- [/tools/algovigilance__microgram-dataframe-join/json](/tools/algovigilance__microgram-dataframe-join/json) — JSON form (agent-friendly)
- [/api/mcp](/api/mcp) — endpoint
- [/AGENTS.md](/AGENTS.md) — agent guide