Data Processing

Missing Value Handler

Comprehensive missing value detection, analysis, and intelligent handling with multiple strategies

text· Text resultOpen tool

Quick start

Call this tool from your code in three languages.

cURL

curl -X POST 'https://api.elysiatools.com/en/api/tools/missing-value-handler' \
  -H 'Content-Type: application/json' \
  -d '{"dataInput":"Enter your tabular data (CSV or tab-separated)\n\nExample:\nName,Age,Salary,Department\nJohn,25,50000,IT\nJane,,45000,HR\nBob,30,,Finance\nAlice,28,52000,\nCharlie,35,60000,IT","dataFormat":"csv","missingValueIndicators":"Enter values that should be treated as missing (one per line)\n\nCommon indicators:\n(empty cell)\nnull\nNULL\nN/A\nna\n#N/A\n-999\nMissing","outputFormat":"detailed"}'

API reference

Send a POST request with your inputs as JSON. File parameters require a separate upload first.

Endpoint

HTTP

POST https://api.elysiatools.com/en/api/tools/missing-value-handler

Parameters

Name	Type	Required	Description
dataInput	textarea	Yes	—
dataFormat	select	Yes	—
missingValueIndicators	textarea	No	Additional strings to treat as missing values (besides empty cells)
outputFormat	select	Yes	—

Response format

Text result

JSON

{
  "result": "Processed text content",
  "error": "Error message (optional)",
  "message": "Notification message (optional)",
  "metadata": {
    "key": "value"
  }
}

MCP integration

Add this tool to your Model Context Protocol server so AI agents can list and call it.

Server configuration

Add this block to your MCP client configuration:

mcp.json

{
  "mcpServers": {
    "elysiatools-missing-value-handler": {
      "name": "missing-value-handler",
      "description": "Comprehensive missing value detection, analysis, and intelligent handling with multiple strategies",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=missing-value-handler",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

List available tools

After connecting to the SSE endpoint, list the exposed tools:

tools/list

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

Call this tool

Invoke the tool by its id, passing arguments built from its parameters:

tools/call

{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "missing-value-handler",
    "arguments": {
  "dataInput": "Enter your tabular data (CSV or tab-separated)\n\nExample:\nName,Age,Salary,Department\nJohn,25,50000,IT\nJane,,45000,HR\nBob,30,,Finance\nAlice,28,52000,\nCharlie,35,60000,IT",
  "dataFormat": "csv",
  "missingValueIndicators": "Enter values that should be treated as missing (one per line)\n\nCommon indicators:\n(empty cell)\nnull\nNULL\nN/A\nna\n#N/A\n-999\nMissing",
  "outputFormat": "detailed"
}
  }
}

Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).

Browse tools Open tool

curl -X POST 'https://api.elysiatools.com/en/api/tools/missing-value-handler' \ -H 'Content-Type: application/json' \ -d '{"dataInput":"Enter your tabular data (CSV or tab-separated)\n\nExample:\nName,Age,Salary,Department\nJohn,25,50000,IT\nJane,,45000,HR\nBob,30,,Finance\nAlice,28,52000,\nCharlie,35,60000,IT","dataFormat":"csv","missingValueIndicators":"Enter values that should be treated as missing (one per line)\n\nCommon indicators:\n(empty cell)\nnull\nNULL\nN/A\nna\n#N/A\n-999\nMissing","outputFormat":"detailed"}'

Name

Type

Required

Description

dataInput

textarea

Yes

—

dataFormat

select

Yes

—

missingValueIndicators

textarea

Additional strings to treat as missing values (besides empty cells)

outputFormat

select

Yes

—

{ "mcpServers": { "elysiatools-missing-value-handler": { "name": "missing-value-handler", "description": "Comprehensive missing value detection, analysis, and intelligent handling with multiple strategies", "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=missing-value-handler", "command": "", "args": [], "env": {}, "isActive": true, "type": "sse" } } }

{ "jsonrpc": "2.0", "id": 2, "method": "tools/call", "params": { "name": "missing-value-handler", "arguments": { "dataInput": "Enter your tabular data (CSV or tab-separated)\n\nExample:\nName,Age,Salary,Department\nJohn,25,50000,IT\nJane,,45000,HR\nBob,30,,Finance\nAlice,28,52000,\nCharlie,35,60000,IT", "dataFormat": "csv", "missingValueIndicators": "Enter values that should be treated as missing (one per line)\n\nCommon indicators:\n(empty cell)\nnull\nNULL\nN/A\nna\n#N/A\n-999\nMissing", "outputFormat": "detailed" } } }