featuretools.entityset.EntitySet.query_by_values¶
- EntitySet.query_by_values(dataframe_name, instance_vals, column_name=None, columns=None, time_last=None, training_window=None, include_cutoff_time=True)[source]¶
Query instances that have column with given value
- Parameters
dataframe_name (str) – The id of the dataframe to query
instance_vals (pd.Dataframe, pd.Series, list[str] or str) – Instance(s) to match.
column_name (str) – Column to query on. If None, query on index.
columns (list[str]) – Columns to return. Return all columns if None.
time_last (pd.TimeStamp) – Query data up to and including this time. Only applies if dataframe has a time index.
training_window (Timedelta, optional) – Window defining how much time before the cutoff time data can be used when calculating features. If None, all data before cutoff time is used.
include_cutoff_time (bool) – If True, data at cutoff time are included in calculating features
- Returns
instances that match constraints with ids in order of underlying dataframe
- Return type
pd.DataFrame