piper.verbs.where¶
-
piper.verbs.where(df: pandas.core.frame.DataFrame, *args, **kwargs) → pandas.core.frame.DataFrame[source]¶ where/filter dataframe rows
This is a wrapper function rather than using e.g. df.query() For details of args, kwargs - see help(pd.DataFrame.query)
Examples
(select(customers) .pipe(clean_names) .pipe(select, ['client_code', 'establishment_type', 'address_1', 'address_2', 'town']) .pipe(where, 'establishment_type != 91') .pipe(where, "town != 'LISBOA' & establishment_type != 91"))
%%piper get_sample_data() >> str_trim() >> select('-dates') >> where(""" ~countries.isin(['Italy', 'Portugal']) & values_1 > 40 & values_2 < 25 """) >> order_by('-countries') >> head(5)
- Parameters
df – dataframe
*args – arguments for wrapped function
**kwargs – keyword-parameters for wrapped function
- Returns
- Return type
A pandas DataFrame