NOTICE

The upcoming release of Featuretools 1.0.0 contains several breaking changes. Users are encouraged to test this version prior to release by installing from GitHub:

pip install https://github.com/alteryx/featuretools/archive/woodwork-integration.zip

For details on migrating to the new version, refer to Transitioning to Featuretools Version 1.0. Please report any issues in the Featuretools GitHub repo or by messaging in Alteryx Open Source Slack.


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

featuretools.entityset.EntitySet.get_backward_dataframes featuretools.entityset.EntitySet.plot