Filter Columns

General information

Brick provides a possibility to remove unnecessary columns from your data


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.
notion image
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.
notion image
The result is presented below:
notion image