![[Google Cloud Documentation]](https://www.gstatic.com/devrel-devsite/prod/v0f3a5b8b76e4a120372a69044e02756e703b6140f9f1812c6e4a0407b19864b7/clouddocs/images/lockup_full_color.svg){kind=link}
![[]](https://docs.cloud.google.com/_static/clouddocs/images/icons/categories/devops-color.svg){kind=link}
Row(values, field_to_index)A BigQuery row.
Values can be accessed by position (index), by key like a dict, or as properties.
Parameters |
|
|---|---|
| Name | Description |
values |
Sequence[object]
The row values |
field_to_index |
Dict[str, int]
A mapping from schema field names to indexes |
Methods
get
get(key: str, default: typing.Optional[typing.Any] = None) -> typing.AnyReturn a value for key, with a default value if it does not exist.
| Parameters | |
|---|---|
| Name | Description |
key |
str
The key of the column to access |
default |
object
The default value to use if the key does not exist. (Defaults to :data: |
| Returns | |
|---|---|
| Type | Description |
object .. rubric:: 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 :data: |
The value associated with the provided key, or a default value. |
items
items() -> typing.Iterable[typing.Tuple[str, typing.Any]]Return items as (key, value) pairs.
| Returns | |
|---|---|
| Type | Description |
Iterable[Tuple[str, object]] .. rubric:: Examples >>> list(Row(('a', 'b'), {'x': 0, 'y': 1}).items()) [('x', 'a'), ('y', 'b')] |
The (key, value) pairs representing this row. |
keys
keys() -> typing.Iterable[str]Return the keys for using a row as a dict.
| Returns | |
|---|---|
| Type | Description |
Iterable[str] .. rubric:: Examples >>> list(Row(('a', 'b'), {'x': 0, 'y': 1}).keys()) ['x', 'y'] |
The keys corresponding to the columns of a row |
values
values()Return the values included in this row.
| Returns | |
|---|---|
| Type | Description |
Sequence[object] |
A sequence of length len(row). |