Filter

Excel

Go to the Data tab > Filter or use keyboard shortcut Ctrl-Shift-L. By default this will allow you to filter any column within the range of data containing the currently highlighted cell. Select a range of columns before clicking Filter to allow filtering only within those columns.

Tableau

Drag fields to the Filter card or Right-click > Show Quick Filter

Alteryx

Use the Filter tool (in the Preparation palette).

Use either the basic filter option to set a quick filter or use a custom expression to define the filter criteria. Both True|False outcomes are provided

OrgVue

Use the Filter or Pages controls, or, to include the filter in an expression: ‹array›.~filter!~(n => ‹logical_test›)

nodes().filter(n=> n.gender == "Female")

tSQL

SELECT ‹field› FROM ‹table› ~WHERE!~ ‹condition›

SELECT * 
FROM EmployeesData
WHERE Gender="Female"

Python

~filter!~(~lambda n:!~ ‹logical_test›, ‹array›)

filter(lambda n: n.gender=="Female", gender)

This assumes that the variable gender is an array containing objects. If you want to filter from a simple array of strings, you can replace the n.gender== with n==:

filter(lambda n: n=="Female", gender)

NB. The above example assumes a variable has been declared for gender. For more information, go to General > Variables.