add_column
Add a new column to a dataframe with constant values, lists, or computed formulas to enhance data structure and analysis capabilities.
Instructions
Add a new column to the dataframe.
Returns: ColumnOperationResult with operation details
Examples: # Add column with constant value add_column(ctx, "status", "active")
# Add column with list of values
add_column(ctx, "scores", [85, 90, 78, 92, 88])
# Add computed column
add_column(ctx, "total", formula="price * quantity")
# Add column with complex formula
add_column(ctx, "full_name", formula="first_name + ' ' + last_name")Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Name for the new column to add | |
| value | No | Single value for all rows or list of values (one per row) | |
| formula | No | Safe mathematical expression to compute column values (e.g., 'col1 + col2') |
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 |