transform_column_case
Change text case in a CSV column to uppercase, lowercase, title case, or capitalize sentences for data standardization and analysis.
Instructions
Transform the case of text in a column.
Returns: ColumnOperationResult with transformation details
Examples: # Convert to uppercase transform_column_case(ctx, "code", "upper")
# Convert names to title case
transform_column_case(ctx, "name", "title")
# Convert to lowercase for comparison
transform_column_case(ctx, "email", "lower")
# Capitalize sentences
transform_column_case(ctx, "description", "capitalize")Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | Column name to transform text case in | |
| transform | Yes | Case transformation: upper, lower, title, or capitalize |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| success | No | Whether operation completed successfully | |
| operation | Yes | Type of operation performed | |
| transform | No | Transform description | |
| part_index | No | Part index for split operations | |
| nulls_filled | No | Number of null values filled | |
| rows_removed | No | Number of rows removed (for remove_duplicates) | |
| rows_affected | Yes | Number of rows affected by operation | |
| values_filled | No | Number of values filled (for fill_missing_values) | |
| updated_sample | No | Sample values after operation | |
| original_sample | No | Sample values before operation | |
| columns_affected | Yes | Names of columns affected |