Data Processing

Advanced outlier detection and processing tool that identifies, removes, or replaces anomalous values in numerical data using multiple statistical methods. Perfect for data cleaning, statistical analysis, and machine learning data preparation. Features: - Multiple detection methods (IQR, Z-score, Modified Z-score, Isolation Forest) - Flexible handling strategies (Remove, Replace with mean/median/mode, Cap) - Automatic threshold optimization - Multi-dimensional outlier detection - Visual outlier statistics and reporting - Batch processing capabilities - Custom sensitivity levels - Comprehensive impact analysis Common Use Cases: - Data cleaning and preprocessing - Statistical analysis preparation - Machine learning dataset cleaning - Quality control in manufacturing - Financial anomaly detection - Sensor data validation

Data Processing

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

Data Processing

Standardize numerical data using Z-score (standard score) normalization to transform values with mean=0 and standard deviation=1. Perfect for statistical analysis, machine learning feature preprocessing, outlier detection, and data comparison across different scales. Features: - Z-score standardization (mean=0, std=1) - Robust Z-score option (using median and MAD) - Custom scaling to target range - Multiple column selection - Automatic data type detection - Handles missing values intelligently - Preserves non-numeric columns - Comprehensive statistical summary - Outlier detection and reporting Common Use Cases: - Machine learning feature preparation - Statistical hypothesis testing - Outlier detection and removal - Data comparison across different units - Principal Component Analysis (PCA) preprocessing

Data Processing

Extract specific columns from tabular data with support for various formats and flexible column selection

Data Processing

Clean and standardize data by fixing spelling errors, standardizing formats, removing duplicates, and filling missing values

Data Processing

Pure code-based data format normalization tool that cleans and standardizes messy data using programmatic logic

Geography

Find the currency used in any country including symbol, code, and exchange information

Format Conversion

Convert date strings to various formatted date formats

Math & Numbers

Calculate what day of the week a given date falls on

Utilities

Add or subtract time periods from a date (years, months, days, hours, minutes, seconds)

Health

Calculate daily calorie needs based on activity level and goals

Utilities

Calculate the difference between two dates in various time units