# Filter By Condition

Filter by condition allows you to apply filters to a specific column that remove rows from the dataframe by comparing these conditions to the values in the column you are filtering. To filter rows by condition.

1. Click on the `Filter` icon in the header you want to filter.
2. Click the `Filter/Sort` tab in the taskpane that opens.
3. Click the `+ Add Filter` button, and then click `Add a Filter`.
4. Set the condition you want to filter on. Different filter conditions are available for different datatypes.
5. If you add multiple figures, optionally set the `Operator` to `And` or `Or` to change how these filters are combined.
6. Only rows where the filter conditions are met will remain in the dataframe.

<figure><img src="https://2294704369-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MP_U5ZCmiamDOXEOOTC%2Fuploads%2FnEAhum9hpzHsrbiUY6FJ%2FFiltering%20GIF.gif?alt=media&#x26;token=90537fc3-d65e-42fe-b2c2-72ae88c8de25" alt=""><figcaption><p>Filtering to all values > 20.</p></figcaption></figure>

### Filter Groups

Filter Groups are aggregations of filters combined with an **And/Or**. This allows for more complex filters on the specific column.

1. Click on the `Filter` icon in the header you want to filter.
2. Click the `Filter/Sort` tab in the taskpane that opens.
3. Click the `+ Add Filter` button, and then click `Add a Filter Group`.
4. Within the filter group, set the filter conditions and operator.
5. This filter group will be applied to your dataset.