flowmachine.features.subscriber.unique_location_counts

Source: flowmachine/features/subscriber/unique_location_counts.py

Class for UniqueLocationCounts. UniqueLocationCounts counts the total number of unique locations for each subscriber. Each Subscriber will have an integer that shows how many different locations it visited

Class UniqueLocationCounts

UniqueLocationCounts(start, stop, *, spatial_unit: Union[flowmachine.core.spatial_unit.CellSpatialUnit, flowmachine.core.spatial_unit.GeomSpatialUnit] = CellSpatialUnit(), hours: Union[Tuple[int, int], NoneType] = None, tables='all', subscriber_identifier='msisdn', ignore_nulls=True, subscriber_subset=None)

Source: flowmachine/features/subscriber/unique_location_counts.py

Class that defines counts of unique locations for each subscriber. Each subscriber is accompanied by the count of unique locations.

Attributes

• cache

• column_names

• column_names_as_string_list

• dependencies

• fully_qualified_table_name

• index_cols

• is_stored

• query_id

• query_state

• query_state_str

• table_name

Parameters

• start: str

  iso format date range for the beginning of the time frame, e.g. 2016-01-01 or 2016-01-01 14:03:01

• stop: str

  As above

• spatial_unit: typing.Union[flowmachine.core.spatial_unit.CellSpatialUnit, flowmachine.core.spatial_unit.GeomSpatialUnit], default CellSpatialUnit()

  Spatial unit to which subscriber locations will be mapped. See the docstring of make_spatial_unit for more information.

• hours: typing.Union[typing.Tuple[int, int], NoneType], default None

  subset the result within certain hours, e.g. (4,17) This will subset the query only with these hours, but across all specified days. Or set to 'all' to include all hours.

• tables: str, default 'ALL'

  schema qualified name of the table which the analysis is based upon. If 'ALL' it will pull together all of the tables specified as flowmachine.yml under 'location_tables'

• subscriber_identifier: {'msisdn', 'imei'}, default 'msisdn'

  Either msisdn, or imei, the column that identifies the subscriber.

• subscriber_subset: flowmachine.core.Table, flowmachine.core.Query, list, str, default None

  If provided, string or list of string which are msisdn or imeis to limit results to; or, a query or table which has a column with a name matching subscriber_identifier (typically, msisdn), to limit results to.

• ignore_nulls: bool, default True

  ignores those values that are null. Sometime data appears for which the cell is null. If set to true this will ignore those lines. If false these lines with null cells should still be present, although they contain no information on the subscribers location, they still tell us that the subscriber made a call at that time.

Examples

>>> ulc = UniqueLocationCounts('2016-01-01', '2016-01-04',                             spatial_unit=make_spatial_unit('admin', level=3),                             method='last', hours=(5,17))     >>> ulc.head(4)             subscriber                unique_location_counts         0   038OVABN11Ak4W5P    3         1   0987YDNK23Da6G5K    4         2   0679FBNM35DsTH3K    3

Methods

cache

cache

Source: flowmachine/core/query.py

Returns

• bool

  True is caching is switched on.

column_names

column_names

Source: flowmachine/features/subscriber/unique_location_counts.py

Returns the column names.

Returns

• typing.List[str]

  List of the column names of this query.

column_names_as_string_list

column_names_as_string_list

Source: flowmachine/core/query.py

Get the column names as a comma separated list

Returns

• str

  Comma separated list of column names

dependencies

dependencies

Source: flowmachine/core/query.py

Returns

• set

  The set of queries which this one is directly dependent on.

fully_qualified_table_name

fully_qualified_table_name

Source: flowmachine/core/query.py

Returns a unique fully qualified name for the query to be stored as under the cache schema, based on a hash of the parameters, class, and subqueries.

Returns

• str

  String form of the table's fqn

index_cols

index_cols

Source: flowmachine/core/query.py

A list of columns to use as indexes when storing this query.

Returns

• ixen: list

  By default, returns the location columns if they are present and self.spatial_unit is defined, and the subscriber column.

Examples

daily_location("2016-01-01").index_cols
[['name'], '"subscriber"']

is_stored

is_stored

Source: flowmachine/core/query.py

Returns

• bool

  True if the table is stored, and False otherwise.

query_id

query_id

Source: flowmachine/core/query.py

Generate a uniquely identifying hash of this query, based on the parameters of it and the subqueries it is composed of.

Returns

• str

  query_id hash string

query_state

query_state

Source: flowmachine/core/query.py

Return the current query state.

Returns

• QueryState

  The current query state

query_state_str

query_state_str

Source: flowmachine/core/query.py

Return the current query state as a string

Returns

• str

  The current query state. The possible values are the ones defined in flowmachine.core.query_state.QueryState.

table_name

table_name

Source: flowmachine/core/query.py

Returns a uniquename for the query to be stored as, based on a hash of the parameters, class, and subqueries.

Returns

• str

  String form of the table's fqn