merge_dataframes
Combine two dataframes using SQL-like joins (inner, left, right, outer) to merge data split across files. Store the result as a new dataframe for further analysis.
Instructions
Merge two dataframes (like SQL JOIN). How: 'inner', 'left', 'right', 'outer'. Result is stored as a new dataframe. Use when data is split across files. Always verify join keys exist in both dataframes with get_info first.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"left_name": "<left_name>",
"right_name": "<right_name>",
"on": "<on>"
},
"name": "merge_dataframes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| on | Yes | ||
| how | No | inner | |
| left_name | Yes | ||
| right_name | Yes | ||
| result_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |