--where

Switch

--where VALUE

Description

Filter groups based on sql call.

Argument and Default Value

Argument is sql-like query with column_name, operator and value. The column_name must be an actual column in --outcome_table. Do NOT include the word "where" after inside your. There is no default value.

Details =======Contents [hide]Switch Description     Argument and Default Value

Other Switches

Example Commands

Switch

--where VALUE

Description

Filter groups based on sql call.

Argument and Default Value

Argument is sql:doc:fwflag_like query with column_name, operator and value. The column_name must be an actual column in --outcome_table. Do NOT include the word "where" after inside your. There is no default value.

Works with correlation, prediction and classification.

Examples: --where "age >= 30 and age < 80" --where "gender = 0" --where "upt > 100"

Other Switches

Required Switches: -d, -c, -t --outcome_table Example Commands ================ .. code:doc:fwflag_block:: python

# Run LIWC over age and only consider males ./fwInterface.py -d dla_tutorial -t msgs_xxx -c user_id -f 'feat$cat_LIWC2007$msgs_xxx$user_id$16to16' --outcome_table masterstats_r500 --outcomes demog_age --where "demog_gender = 1" --output_name xxx_output