bigframes.extensions.core.series_accessor.BigQuerySeriesAccessor#

class bigframes.extensions.core.series_accessor.BigQuerySeriesAccessor(obj: S)[source]#

Series accessor for BigQuery functions.

abstract property aead: AeadSeriesAccessor[T, S]#: Accessor for BigQuery aead functions.

abstract property ai: AiSeriesAccessor[T, S]#: Accessor for BigQuery ai functions.

array_concat(array_expression_2: Series | Expression | Any | Literal[Sentinel.ARGUMENT_DEFAULT], *, session: Session | None = None) → S[source]#: Concatenates one or more arrays with the same element type into a single array.

array_first(*, session: Session | None = None) → S[source]#: Takes an array and returns the first element in the array.

array_first_n(n: Series | Expression | Literal[Sentinel.ARGUMENT_DEFAULT] | int, *, session: Session | None = None) → S[source]#: Returns a prefix of input_array consisting of the first n elements.

array_includes(search_value: Series | Expression | Any | Literal[Sentinel.ARGUMENT_DEFAULT], *, session: Session | None = None) → S[source]#: Takes an array and returns TRUE if there is an element in the array that is equal to the search_value.

array_includes_all(search_values: Series | Expression | Any | Literal[Sentinel.ARGUMENT_DEFAULT], *, session: Session | None = None) → S[source]#: Takes an array to search and an array of search values. Returns TRUE if all search values are in the array to search, otherwise returns FALSE.

array_includes_any(search_values: Series | Expression | Any | Literal[Sentinel.ARGUMENT_DEFAULT], *, session: Session | None = None) → S[source]#: Takes an array to search and an array of search values. Returns TRUE if any search values are in the array to search, otherwise returns FALSE.

array_is_distinct(*, session: Session | None = None) → S[source]#: Returns TRUE if the array contains no repeated elements, using the same equality comparison logic as SELECT DISTINCT.

array_last(*, session: Session | None = None) → S[source]#: Takes an array and returns the last element in the array.

array_length(*, session: Session | None = None) → S[source]#

Compute the length of each array element in the Series.

Examples:

>>> import bigframes.pandas as bpd
>>> import bigframes.bigquery as bbq

>>> s = bpd.Series([[1, 2, 8, 3], [], [3, 4]])
>>> bbq.array_length(s)
0    4
1    0
2    2
dtype: Int64

You can call this function using the Series bigquery accessor.

>>> s.bigquery.array_length()
0    4
1    0
2    2
dtype: Int64

You can also use this accessor on a pandas Series after importing bigframes.

>>> import bigframes
>>> import pandas as pd
>>> ps = pd.Series([[1, 2, 8, 3], [], [3, 4]])
>>> ps.bigquery.array_length()
0    4
1    0
2    2
dtype: Int64

You can also apply this function directly to Series using apply.

>>> s.apply(bbq.array_length, by_row=False)
0    4
1    0
2    2
dtype: Int64

Parameters:

series (bigframes.series.Series) – A Series with array columns.

Returns:

A Series of integer values indicating: the length of each element in the Series.

Return type:

bigframes.series.Series

array_reverse(*, session: Session | None = None) → S[source]#: Returns the input ARRAY with elements in reverse order.

array_slice(start_offset: Series | Expression | Literal[Sentinel.ARGUMENT_DEFAULT] | int, end_offset: Series | Expression | Literal[Sentinel.ARGUMENT_DEFAULT] | int, *, session: Session | None = None) → S[source]#: Returns an array containing zero or more consecutive elements from the input array.

Converts array elements within a Series into delimited strings.