EqualToColumn / Boolean Layer
Create boolean mask columns by comparing values between two columns element-wise. Similar to pandas df['A'] == df['B'] or R's equal() function. Returns True where corresponding values match exactly.
Common applications:
- Data verification
- Change detection
- Cross-validation
- Quality control
- Version comparison
Example:
Index | Column A | Column B | Equal |
---|---|---|---|
0 | apple | apple | true |
1 | 42 | 42 | true |
2 | null | apple | null |
3 | orange | ORANGE | false |
4 | 42.0 | 42 | true |
Compare
[, ...]List of column equality comparisons to perform. Each creates a new boolean column. Common scenarios:
- Multiple field validations
- Batch data verification
- System synchronization checks
- Cross-reference validation
At least one comparison must be specified.
SelectLeft
columnThe first column for comparison. Must be comparable with SelectRight
. If this column contains null values, the result will be null for those rows.
SelectRight
columnThe second column for comparison. Must be comparable with SelectLeft
. If this column contains null values, the result will be null for those rows. Common pairs:
- predicted vs. actual values
- old vs. new versions
- manual vs. automated results
Type conversion may occur for compatible types (e.g., int vs. float).
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn
matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.