def find(
self,
substr: str | StringValue,
start: int | ir.IntegerValue | None = None,
end: int | ir.IntegerValue | None = None,
) -> ir.IntegerValue:
"""Return the position of the first occurence of substring.
Parameters
----------
substr
Substring to search for
start
Zero based index of where to start the search
end
Zero based index of where to stop the search. Currently not
implemented.
Returns
-------
IntegerValue
Position of `substr` in `arg` starting from `start`
"""
import ibis.expr.operations as ops
if end is not None:
raise NotImplementedError
return ops.StringFind(self, substr, start, end).to_expr()
def test_ops_smoke():
expr = ir.literal(3)
ops.UnaryOp(expr)
ops.Cast(expr, to='int64')
ops.TypeOf(arg=2)
ops.Negate(4)
ops.Negate(4.0)
ops.NullIfZero(0)
ops.NullIfZero(1)
ops.IsNull(ir.null())
ops.NotNull(ir.null())
ops.ZeroIfNull(ir.null())
ops.IfNull(1, ops.NullIfZero(0).to_expr())
ops.NullIf(ir.null(), ops.NullIfZero(0).to_expr())
ops.IsNan(np.nan)
ops.IsInf(np.inf)
ops.Ceil(4.5)
ops.Floor(4.5)
ops.Round(3.43456)
ops.Round(3.43456, 2)
ops.Round(3.43456, digits=1)
ops.Clip(123, lower=30)
ops.Clip(123, lower=30, upper=100)
ops.BaseConvert('EEE', from_base=16, to_base=10)
ops.Logarithm(100)
ops.Log(100)
ops.Log(100, base=2)
ops.Ln(100)
ops.Log2(100)
ops.Log10(100)
ops.Uppercase('asd')
ops.Lowercase('asd')
ops.Reverse('asd')
ops.Strip('asd')
ops.LStrip('asd')
ops.RStrip('asd')
ops.Capitalize('asd')
ops.Substring('asd', start=1)
ops.Substring('asd', 1)
ops.Substring('asd', 1, length=2)
ops.StrRight('asd', nchars=2)
ops.Repeat('asd', times=4)
ops.StringFind('asd', 'sd', start=1)
ops.Translate('asd', from_str='bd', to_str='ce')
ops.LPad('asd', length=2, pad='ss')
ops.RPad('asd', length=2, pad='ss')
ops.StringJoin(',', ['asd', 'bsdf'])
ops.FuzzySearch('asd', pattern='n')
ops.StringSQLLike('asd', pattern='as', escape='asd')
ops.RegexExtract('asd', pattern='as', index=1)
ops.RegexReplace('asd', 'as', 'a')
ops.StringReplace('asd', 'as', 'a')
ops.StringSplit('asd', 's')
ops.StringConcat(['s', 'e'])
ops.StartsWith('asd', 'as')
ops.EndsWith('asd', 'xyz')
def _string_find(self, substr, start=None, end=None):
"""
Returns position (0 indexed) of first occurence of substring,
optionally after a particular position (0 indexed)
Parameters
----------
substr : string
start : int, default None
end : int, default None
Not currently implemented
Returns
-------
position : int, 0 indexed
"""
if end is not None:
raise NotImplementedError
return _ops.StringFind(self, substr, start, end).to_expr()