otp.Operation.str.contains

contains(substr)

Check if the string contains substr.

Parameters

substr (str or Column or Operation) – A substring to search for within the string.

Returns

True if the string contains the substring, False otherwise. Note that boolean Operation is converted to float if added as a column.

Return type

Operation

Examples

>>> data = otp.Ticks(X=['hello', 'world!'])
>>> data['CONTAINS'] = data['X'].str.contains('hel')
>>> otp.run(data)
                     Time       X  CONTAINS
0 2003-12-01 00:00:00.000   hello       1.0
1 2003-12-01 00:00:00.001  world!       0.0

Other columns can be used as parameter substr too:

>>> data = otp.Ticks(X=['hello', 'big', 'world!'],
...                  Y=['hel', 'wor', 'wor'])
>>> data['CONTAINS'] = data['X'].str.contains(data['Y'])
>>> otp.run(data)
                     Time       X    Y  CONTAINS
0 2003-12-01 00:00:00.000   hello  hel       1.0
1 2003-12-01 00:00:00.001     big  wor       0.0
2 2003-12-01 00:00:00.002  world!  wor       1.0

This method can also be used for filtering:

>>> data = otp.Ticks(X=['Hello', 'World'])
>>> with_substr, wo_substr = data[data['X'].str.contains('Hel')]
>>> otp.run(with_substr)
        Time      X
0 2003-12-01  Hello