google.cloud.bigquery.table.Row#

Methods

get(key[, default]) Return a value for key, with a default value if it does not exist.
items() Return items as (key, value) pairs.
keys() Return the keys for using a row as a dict.
values() Return the values included in this row.


class google.cloud.bigquery.table.Row(values, field_to_index)[source]#

Bases: object

A BigQuery row.

Values can be accessed by position (index), by key like a dict, or as properties.

Parameters:
  • values (Sequence[object]) – The row values
  • field_to_index (Dict[str, int]) – A mapping from schema field names to indexes
get(key, default=None)[source]#

Return a value for key, with a default value if it does not exist.

Parameters:
  • key (str) – The key of the column to access
  • default (object) – The default value to use if the key does not exist. (Defaults to None.)
Returns:

The value associated with the provided key, or a default value.

Return type:

object

Examples

When the key exists, the value associated with it is returned.

>>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('x')
'a'

The default value is None when the key does not exist.

>>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('z')
None

The default value can be overrided with the default parameter.

>>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('z', '')
''
>>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('z', default = '')
''
items()[source]#

Return items as (key, value) pairs.

Returns:The (key, value) pairs representing this row.
Return type:Iterable[Tuple[str, object]]

Examples

>>> list(Row(('a', 'b'), {'x': 0, 'y': 1}).items())
[('x', 'a'), ('y', 'b')]
keys()[source]#

Return the keys for using a row as a dict.

Returns:The keys corresponding to the columns of a row
Return type:Iterable[str]

Examples

>>> list(Row(('a', 'b'), {'x': 0, 'y': 1}).keys())
['x', 'y']
values()[source]#

Return the values included in this row.

Returns:A sequence of length len(row).
Return type:Sequence[object]