Categories

← View All Tools

Data Range Limiter

Limit numerical values to specified ranges by clipping, filtering, or marking out-of-bounds values. Perfect for data quality control, sensor data cleaning, business rule enforcement, and data preprocessing. Features: - Range clipping (clip values to min/max boundaries) - Range filtering (remove out-of-bounds rows) - Range marking (flag modified values) - Per-column range configuration - Automatic numeric column detection - Multiple handling strategies - Detailed modification reports - Statistical analysis of changes - Business rule enforcement Common Use Cases: - Sensor data validation and cleaning - Machine learning input preparation - Data quality control and validation - Business constraint enforcement - Outlier management and control - Data preprocessing pipelines

CSV data with headers and numeric values to be processed

JSON object specifying min/max ranges for each column. Example: {"age": {"min": 18, "max": 65}}

Specify which columns to apply range limits to. Leave empty to auto-detect numeric columns.

Automatically suggest reasonable ranges based on data distribution

Keep original values with "_original" suffix

Add flags to indicate which values were modified

Generate detailed statistics about modifications

API Documentation

Request Endpoint

POST /en/api/tools/data-range-limiter

Request Parameters

Parameter Name Type Required Description
inputData textarea Yes CSV data with headers and numeric values to be processed
rangeConfiguration textarea Yes JSON object specifying min/max ranges for each column. Example: {"age": {"min": 18, "max": 65}}
targetColumns textarea No Specify which columns to apply range limits to. Leave empty to auto-detect numeric columns.
handlingStrategy select No -
autoDetectRanges checkbox No Automatically suggest reasonable ranges based on data distribution
preserveOriginal checkbox No Keep original values with "_original" suffix
markModified checkbox No Add flags to indicate which values were modified
includeStatistics checkbox No Generate detailed statistics about modifications

Response Format

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

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-data-range-limiter": {
      "name": "data-range-limiter",
      "description": "Limit numerical values to specified ranges by clipping, filtering, or marking out-of-bounds values. Perfect for data quality control, sensor data cleaning, business rule enforcement, and data preprocessing.

Features:
- Range clipping (clip values to min/max boundaries)
- Range filtering (remove out-of-bounds rows)
- Range marking (flag modified values)
- Per-column range configuration
- Automatic numeric column detection
- Multiple handling strategies
- Detailed modification reports
- Statistical analysis of changes
- Business rule enforcement

Common Use Cases:
- Sensor data validation and cleaning
- Machine learning input preparation
- Data quality control and validation
- Business constraint enforcement
- Outlier management and control
- Data preprocessing pipelines",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=data-range-limiter",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

If you encounter any issues, please contact us at [email protected]