Data Processing
CSV Transformer 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"}]