General information
Brick provides a possibility to remove unnecessary columns from your data
Description
Brick Location
Bricks → Data Manipulation → Filter Columns
Brick Parameters
- Columns
Parameter provides an opportunity to select columns that you want to remove from your data. There is an option Remove all except selected which will remove all other columns except selected.
Brick Inputs/Outputs
- Inputs
Brick takes the dataset.
- Outputs
New dataset with less number of columns
Example of Usage
Suppose we have dataset about house prices. It consists of many columns, they are: id, Neighbourhood, YearBuilt, RoofMatl, GrLivArea, YrSold, SalePrice.
You can select as many columns for filtering in one single brick as you want by clicking on the '+' button in the brick settings. We accept two different behaviors depending on the checkbox 'Remove all except selected'. You'll have a selected list of columns as an output if it's checked and the mentioned list will be filtered out of the resulting dataset otherwise.
The result is presented below:
