- 3.36.0 (latest)
- 3.35.1
- 3.34.0
- 3.33.0
- 3.31.0
- 3.30.0
- 3.29.0
- 3.27.0
- 3.26.0
- 3.25.0
- 3.24.0
- 3.23.1
- 3.22.0
- 3.21.0
- 3.20.1
- 3.19.0
- 3.18.0
- 3.17.2
- 3.16.0
- 3.15.0
- 3.14.1
- 3.13.0
- 3.12.0
- 3.11.4
- 3.4.0
- 3.3.6
- 3.2.0
- 3.1.0
- 3.0.1
- 2.34.4
- 2.33.0
- 2.32.0
- 2.31.0
- 2.30.1
- 2.29.0
- 2.28.1
- 2.27.1
- 2.26.0
- 2.25.2
- 2.24.1
- 2.23.3
- 2.22.1
- 2.21.0
- 2.20.0
- 2.19.0
- 2.18.0
- 2.17.0
- 2.16.1
- 2.15.0
- 2.14.0
- 2.13.1
- 2.12.0
- 2.11.0
- 2.10.0
- 2.9.0
- 2.8.0
- 2.7.0
- 2.6.2
- 2.5.0
- 2.4.0
- 2.3.1
- 2.2.0
- 2.1.0
- 2.0.0
- 1.28.2
- 1.27.2
- 1.26.1
- 1.25.0
- 1.24.0
- 1.23.1
- 1.22.0
- 1.21.0
- 1.20.0
- 1.19.0
- 1.18.0
- 1.17.0
- 1.16.0
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
.
Any
Return 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: None
.)
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: None
when the key does not exist. >>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('z') None The default value can be overridden with the default
parameter. >>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('z', '') '' >>> Row(('a', 'b'), {'x': 0, 'y': 1}).get('z', default = '') ''
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)
.