Data Processing

Merge multiple CSV files into a single file with options for header handling and deduplication

Data Processing

Filter CSV data by column values with multiple conditions and operators. Supports 12 filter operators including equals, contains, greater_than, less_than, and empty value checks. Additional Filters examples: [{"column": "age", "operator": "greater_than", "value": "25"}] [{"column": "status", "operator": "equals", "value": "active"}, {"column": "score", "operator": "greater_equal", "value": "80"}] [{"column": "name", "operator": "contains", "value": "john"}, {"column": "email", "operator": "is_not_empty"}]

Data Processing

Sort CSV data by one or multiple columns with ascending/descending order options

Data Processing

Transform and process CSV data with column operations, calculations, and data type conversions. Supports renaming columns, adding calculated columns, removing columns, converting data types, calculating values, and filtering rows. Operation examples: • Rename column: [{"type": "rename", "column": "old_name", "new_name": "new_name"}] • Add calculated column: [{"type": "add_column", "new_column": "total", "formula": "price * quantity"}] • Remove column: [{"type": "remove_column", "remove_column": "column_to_remove"}] • Convert data type: [{"type": "convert_type", "convert_column": "age", "target_type": "number"}] • Calculate values: [{"type": "calculate", "target_column": "total", "expression": "price * tax + shipping"}] • Filter rows: [{"type": "filter_values", "filter_column": "status", "operator": "equals", "value": "active"}]

Data Processing

Split CSV content by specified number of rows per file. Perfect for processing large datasets, dividing data for analysis, batch processing, and managing file size limits. Features: - Split CSV by row count - Support multiple output formats - Preserve header row in each split - Flexible output format options - Support for large datasets - Fast and efficient processing Common Use Cases: - Split large CSV files for processing - Divide data for parallel processing - Create manageable data chunks - Export data in different formats - Prepare data for batch operations - Manage file size limitations

Data Processing

Remove BOM (Byte Order Mark) characters from text and file content. Perfect for cleaning up text files that have encoding issues, fixing CSV imports, and preparing data for processing. Features: - Detect and remove UTF-8 BOM (EF BB BF) - Detect and remove UTF-16 BOM (FE FF or FF FE) - Detect and remove UTF-32 BOM (00 00 FE FF or FF FE 00 00) - Support multiple input formats - Visual BOM character display - Detailed detection report - Support for batch text processing Common Use Cases: - Fix CSV file import errors - Clean up text file encoding issues - Prepare data for JSON parsing - Fix XML parsing problems - Resolve API data encoding conflicts - Standardize text data format

Data Processing

Validate foreign key relationships between multiple datasets. Perfect for checking data integrity, finding orphaned records, and ensuring referential consistency across related tables. Features: - Validate foreign key relationships - Find orphaned records - Check referential integrity - Support multiple key formats - Cross-table validation - Missing key detection - Duplicate key analysis - Relationship mapping Common Use Cases: - Database integrity checks - Data migration validation - ETL process verification - Referential consistency checks - Data quality assurance - Relationship analysis

Data Processing

Inject various types of noise into text data for testing purposes. Perfect for stress testing data processing systems, testing data quality algorithms, and creating realistic test datasets. Features: - Character-level noise injection - Word-level noise injection - Numeric data noise - Formatting noise - Whitespace noise - Special character noise - Configurable intensity levels - Realistic noise patterns Common Use Cases: - Test data validation systems - Stress test parsing algorithms - Evaluate error handling - Test data cleaning algorithms - Create realistic messy data - Benchmark data processing performance

Data Processing

Calculate the coefficient of variation (CV) for numerical columns to measure relative variability

Data Analysis

Calculate confidence intervals for population means using Z or T distributions

Data Analysis

Perform one-way Analysis of Variance (ANOVA) to compare means across multiple groups

Data Analysis

Analyze data kurtosis to measure the "tailedness" of distribution and detect heavy-tailed or light-tailed patterns