Supported pandas APIs#

The following tables show the pandas APIs that have been implemented (or not) in BigQuery DataFrames.

  • ‘Y’ means it implements all parameters.

  • ‘P’ means it implements only some parameters.

DataFrame#

API Implemented Requires index Requires ordering Missing parameters
T Y
__abs__ Y
__add__ Y
__and__ Y
__annotations__ Y
__array__ Y
__array_ufunc__ Y
__bool__ Y
__class__ Y
__contains__ Y
__dataframe__ Y
__delattr__ Y
__delitem__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__floordiv__ Y
__format__ Y
__ge__ Y
__getattr__ P name
__getattribute__ Y
__getitem__ Y
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ Y
__init_subclass__ Y
__invert__ Y
__iter__ Y
__le__ Y
__len__ Y
__lt__ Y
__matmul__ Y
__mod__ Y
__module__ Y
__mul__ Y
__ne__ Y
__neg__ Y
__new__ Y
__nonzero__ Y
__or__ Y
__pandas_priority__ Y
__pos__ Y
__pow__ Y
__radd__ Y
__rand__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__rfloordiv__ Y
__rmod__ Y
__rmul__ Y
__ror__ Y
__rpow__ Y
__rsub__ Y
__rtruediv__ Y
__rxor__ Y
__setattr__ P name
__setitem__ Y
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__sub__ Y
__subclasshook__ Y
__truediv__ Y
__weakref__ Y
__xor__ Y
abs Y
add P fill_value, level
add_prefix Y
add_suffix Y
agg P args, axis, kwargs
aggregate P args, axis, kwargs
align P broadcast_axis, copy, fill_axis, fill_value, level, limit, method
all P kwargs, skipna
any P kwargs, skipna
apply P by_row, engine, engine_kwargs, raw, result_type
applymap P kwargs
assign Y
astype P copy
at Y
axes Y
bfill P Y axis, downcast, inplace, limit_area
columns Y
combine Y
combine_first Y
copy P deep
corr Y
corrwith P axis, drop, method
count P axis
cov P ddof, min_periods
cummax P Y args, axis, kwargs, skipna
cummin P Y args, axis, kwargs, skipna
cumprod P Y args, axis, kwargs, skipna
cumsum P Y args, axis, kwargs, skipna
describe P exclude, percentiles
diff P Y axis
div P fill_value, level
divide P fill_value, level
dot Y Y
drop P errors
drop_duplicates P ignore_index, inplace
droplevel Y
dropna Y
dtypes Y
duplicated Y
empty Y
eq P level
equals Y Y
eval P inplace, kwargs
expanding P Y axis, method
explode Y
ffill P Y axis, downcast, inplace, limit_area
fillna P axis, downcast, inplace, limit, method
filter Y
first_valid_index Y
floordiv P fill_value, level
from_dict Y
from_records Y
ge P level
get Y
groupby P axis, group_keys, observed, sort
gt P level
head Y Y
hist P ax, backend, column, data, figsize, grid, layout, legend, sharex, sharey, xlabelsize, xrot, ylabelsize, yrot
iat Y
idxmax P Y Y axis, numeric_only, skipna
idxmin P Y Y axis, numeric_only, skipna
iloc Y
index Y
info Y
insert Y
interpolate P Y Y axis, downcast, inplace, kwargs, limit, limit_area, limit_direction
isin Y
isna Y
isnull Y
iterrows Y
itertuples Y
join P sort, validate
kurt P axis, kwargs, skipna
kurtosis P axis, kwargs, skipna
le P level
loc Y
lt P level
map P kwargs
mask P axis, inplace, level
max P kwargs, skipna
mean P kwargs, skipna
median P axis, kwargs, skipna
melt P Y col_level, ignore_index
memory_usage P deep
merge P copy, indicator, validate
min P kwargs, skipna
mod P fill_value, level
mul P fill_value, level
multiply P fill_value, level
ndim Y
ne P level
nlargest Y
notna Y
notnull Y
nsmallest Y
nunique P axis, dropna
pct_change P Y fill_method, freq, kwargs, limit
pipe Y
pivot Y
pivot_table Y
plot Y
pow P fill_value, level
prod P kwargs, min_count, skipna
product P kwargs, min_count, skipna
quantile P axis, interpolation, method
query P inplace, kwargs
radd P fill_value, level
rank Y
rdiv P fill_value, level
reindex P copy, fill_value, level, limit, method, tolerance
reindex_like P Y copy, limit, method, tolerance
rename P axis, copy, errors, index, level, mapper
rename_axis P axis, columns, copy, index
reorder_levels Y
replace P inplace, limit, method
resample P Y axis, convention, group_keys, kind, offset
reset_index Y
rfloordiv P fill_value, level
rmod P fill_value, level
rmul P fill_value, level
rolling P Y axis, center, method, step, win_type
round P args, kwargs
rpow P fill_value, level
rsub P fill_value, level
rtruediv P fill_value, level
sample P Y axis, ignore_index, replace, weights
select_dtypes Y
set_index P inplace, verify_integrity
shape Y
shift P Y axis, fill_value, freq, suffix
size Y
skew P axis, kwargs, skipna
sort_index P ignore_index, key, kind, level, sort_remaining
sort_values P axis, ignore_index, key
stack P dropna, future_stack, sort
std P ddof, kwargs, skipna
sub P fill_value, level
subtract P fill_value, level
sum P kwargs, min_count, skipna
swaplevel Y
tail Y Y
take Y
to_csv P chunksize, columns, compression, date_format, decimal, doublequote, encoding, errors, escapechar, float_format, index_label, lineterminator, mode, na_rep, quotechar, quoting, storage_options
to_dict P index
to_excel P columns, engine, engine_kwargs, float_format, freeze_panes, header, index, index_label, inf_rep, merge_cells, na_rep, startcol, startrow, storage_options
to_gbq P auth_local_webserver, chunksize, credentials, location, progress_bar, project_id, reauth, table_schema
to_html Y
to_json P compression, date_format, date_unit, default_handler, double_precision, force_ascii, indent, mode, storage_options
to_latex P bold_rows, caption, column_format, decimal, encoding, escape, float_format, formatters, index_names, label, longtable, multicolumn, multicolumn_format, multirow, na_rep, position, sparsify
to_markdown P storage_options
to_numpy Y
to_orc P engine, engine_kwargs, index
to_parquet P engine, kwargs, partition_cols, storage_options
to_pickle P compression, protocol, storage_options
to_records Y
to_string Y
transpose P Y Y args, copy
truediv P fill_value, level
unstack P Y Y fill_value, sort
update P errors
value_counts Y
values Y
var P ddof, kwargs, skipna
where P axis, inplace, level

DataFrameGroupBy#

API Implemented Requires index Requires ordering Missing parameters
__annotations__ Y
__class__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__format__ Y
__ge__ Y
__getattribute__ Y
__getitem__ Y
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ P axis, exclusions, group_keys, grouper, keys, level, obj, observed, selection, sort
__init_subclass__ Y
__iter__ Y
__le__ Y
__len__ Y
__lt__ Y
__module__ Y
__ne__ Y
__new__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__setattr__ Y
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__subclasshook__ Y
__weakref__ Y
agg P args, engine, engine_kwargs
aggregate P args, engine, engine_kwargs
all P skipna
any P skipna
corr P method, min_periods
count Y
cov P ddof, min_periods
cumcount Y Y
cummax P Y axis
cummin P Y axis
cumprod P Y axis
cumsum P Y axis
describe P exclude, percentiles
diff P Y axis
expanding P Y args, kwargs
first P Y skipna
head Y Y
last P Y skipna
max P engine, engine_kwargs, min_count
mean P engine, engine_kwargs
median Y
min P engine, engine_kwargs, min_count
nunique P dropna
prod Y
quantile P interpolation
rank P axis
rolling P Y args, kwargs
shift P Y axis, fill_value, freq, suffix
size Y
skew P axis, kwargs, skipna
std P ddof, engine, engine_kwargs
sum P engine, engine_kwargs, min_count
value_counts Y
var P ddof, engine, engine_kwargs

Index#

API Implemented Requires index Requires ordering Missing parameters
T Y
__annotations__ Y
__array__ P copy
__class__ Y
__contains__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__format__ Y
__ge__ P other
__getattribute__ Y
__getitem__ Y
__getstate__ Y
__gt__ P other
__hash__ Y
__init__ Y
__init_subclass__ Y
__le__ P other
__len__ Y
__lt__ P other
__module__ Y
__ne__ P other
__new__ P copy, tupleize_cols
__or__ P other, self
__pandas_priority__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__ror__ P other, self
__setattr__ Y
__setitem__ Y
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__subclasshook__ Y
__weakref__ Y
all P args, kwargs
any P args, kwargs
argmax P Y args, axis, kwargs, skipna
argmin P Y args, axis, kwargs, skipna
astype P copy
copy P deep
drop P errors
drop_duplicates Y
dropna Y
dtype Y
empty Y
fillna P downcast
get_level_values Y
get_loc Y
has_duplicates Y
is_monotonic_decreasing Y
is_monotonic_increasing Y
is_unique Y
isin P level
item Y
max P args, axis, kwargs, skipna
min P args, axis, kwargs, skipna
name Y
names Y
ndim Y
nlevels Y
nunique P dropna
rename Y
shape Y
size Y
sort_values P key, return_indexer
str Y
to_list Y
to_numpy P copy, na_value
to_series Y
transpose P args, kwargs
unique Y
value_counts P bins
values Y

pandas module#

API Implemented Requires index Requires ordering Missing parameters
ArrowDtype Y
BooleanDtype Y
DataFrame Y
DatetimeIndex Y
Float64Dtype Y
Index Y
Int64Dtype Y
MultiIndex Y
NA Y
NamedAgg Y
Series Y
StringDtype Y
__all__ Y
__builtins__ Y
__cached__ Y
__doc__ Y
__file__ Y
__loader__ Y
__name__ Y
__package__ Y
__path__ Y
__spec__ Y
__version__ Y
annotations Y
concat P copy, keys, levels, names, sort, verify_integrity
core Y
crosstab P dropna, margins, margins_name, normalize
cut P duplicates, include_lowest, ordered, precision, retbins
get_dummies P sparse
io Y
merge P copy, indicator, validate
option_context Y
options Y
pandas Y
qcut P precision, retbins
read_csv P cache_dates, chunksize, comment, compression, converters, date_format, date_parser, dayfirst, decimal, delim_whitespace, delimiter, dialect, doublequote, dtype_backend, encoding_errors, escapechar, false_values, float_precision, infer_datetime_format, iterator, keep_date_col, keep_default_na, lineterminator, low_memory, memory_map, na_filter, na_values, nrows, on_bad_lines, parse_dates, quotechar, quoting, skip_blank_lines, skipfooter, skipinitialspace, skiprows, storage_options, thousands, true_values, verbose
read_gbq P auth_local_webserver, credentials, dialect, location, progress_bar_type, project_id, query, reauth, use_bqstorage_api
read_json P chunksize, compression, convert_axes, convert_dates, date_unit, dtype_backend, encoding_errors, keep_default_dates, nrows, precise_float, storage_options, typ
read_parquet P columns, dtype_backend, filesystem, filters, kwargs, storage_options, use_nullable_dtypes
read_pickle Y
to_datetime P cache, dayfirst, errors, exact, infer_datetime_format, origin, yearfirst
to_timedelta P errors

Series#

API Implemented Requires index Requires ordering Missing parameters
T Y
__abs__ Y
__add__ Y
__and__ Y
__annotations__ Y
__array__ Y
__array_ufunc__ Y
__bool__ Y
__class__ Y
__contains__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__floordiv__ Y
__format__ Y
__ge__ Y
__getattr__ P name
__getattribute__ Y
__getitem__ P key
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ P fastpath
__init_subclass__ Y
__invert__ Y
__iter__ Y
__le__ Y
__len__ Y
__lt__ Y
__matmul__ Y
__mod__ Y
__module__ Y
__mul__ Y
__ne__ Y
__neg__ Y
__new__ Y
__nonzero__ Y
__or__ Y
__pandas_priority__ Y
__pos__ Y
__pow__ Y
__radd__ Y
__rand__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__rfloordiv__ Y
__rmatmul__ Y
__rmod__ Y
__rmul__ Y
__ror__ Y
__rpow__ Y
__rsub__ Y
__rtruediv__ Y
__rxor__ Y
__setattr__ Y
__setitem__ Y
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__sub__ Y
__subclasshook__ Y
__truediv__ Y
__weakref__ Y
__xor__ Y
abs Y
add P axis, fill_value, level
add_prefix Y Y
add_suffix Y Y
agg P args, axis, kwargs
aggregate P args, axis, kwargs
all P axis, bool_only, kwargs, skipna
any P axis, bool_only, kwargs, skipna
apply P convert_dtype, kwargs
argmax P Y args, axis, kwargs, skipna
argmin P Y args, axis, kwargs, skipna
astype P copy
at Y
autocorr Y
between Y
bfill P Y axis, downcast, inplace, limit_area
case_when Y
clip P axis, inplace, kwargs
combine P fill_value
combine_first Y
copy P deep
corr Y
count Y
cov P ddof, min_periods
cummax P Y args, axis, kwargs, skipna
cummin P Y args, axis, kwargs, skipna
cumprod P Y args, axis, kwargs, skipna
cumsum P Y args, axis, kwargs, skipna
describe P exclude, include, percentiles
diff Y Y
div P axis, fill_value, level
divide P axis, fill_value, level
divmod P axis, fill_value, level
dot Y
drop P errors, inplace
drop_duplicates P ignore_index, inplace
droplevel Y Y
dropna Y
dt Y
dtype Y
dtypes Y
duplicated Y
empty Y
eq P axis, fill_value, level
equals Y
expanding P Y axis, method
explode Y
ffill P Y axis, downcast, inplace, limit_area
fillna P axis, downcast, inplace, limit, method
filter Y
floordiv P axis, fill_value, level
ge P axis, fill_value, level
get Y
groupby P group_keys, observed, sort
gt P axis, fill_value, level
hasnans Y
head Y Y
hist P ax, backend, figsize, grid, legend, xlabelsize, xrot, ylabelsize, yrot
iat Y
idxmax P Y args, axis, kwargs, skipna
idxmin P Y args, axis, kwargs, skipna
iloc Y
index Y
interpolate P Y Y axis, downcast, inplace, kwargs, limit, limit_area, limit_direction
is_monotonic_decreasing Y
is_monotonic_increasing Y
isin Y
isna Y
isnull Y
item Y
kurt P axis, kwargs, numeric_only, skipna
kurtosis P axis, kwargs, numeric_only, skipna
le P axis, fill_value, level
list Y
loc Y
lt P axis, fill_value, level
map Y
mask P axis, inplace, level
max P axis, kwargs, numeric_only, skipna
mean P axis, kwargs, numeric_only, skipna
median P axis, kwargs, numeric_only, skipna
min P axis, kwargs, numeric_only, skipna
mod P axis, fill_value, level
mode P dropna
mul P axis, fill_value, level
multiply P axis, fill_value, level
name Y
ndim Y
ne P axis, fill_value, level
nlargest Y
notna Y
notnull Y
nsmallest Y
nunique P dropna
pad P Y axis, downcast, inplace
pct_change P Y fill_method, freq, kwargs, limit
pipe Y
plot Y
pow P axis, fill_value, level
prod P axis, kwargs, min_count, numeric_only, skipna
product P axis, kwargs, min_count, numeric_only, skipna
quantile P interpolation
radd P axis, fill_value, level
rank Y Y
rdiv P axis, fill_value, level
rdivmod P axis, fill_value, level
reindex P Y axis, copy, fill_value, level, limit, method, tolerance
reindex_like P Y copy, limit, method, tolerance
rename P axis, copy, errors, level
rename_axis P Y axis, copy, index
reorder_levels Y Y
replace P inplace, limit, method
resample P Y axis, convention, group_keys, kind, offset, on
reset_index Y Y
rfloordiv P axis, fill_value, level
rmod P axis, fill_value, level
rmul P axis, fill_value, level
rolling P Y axis, center, method, on, step, win_type
round P args, kwargs
rpow P axis, fill_value, level
rsub P axis, fill_value, level
rtruediv P axis, fill_value, level
sample P Y axis, ignore_index, replace, weights
shape Y
shift P Y axis, fill_value, freq, suffix
size Y
skew P axis, kwargs, numeric_only, skipna
sort_index P Y ignore_index, key, kind, level, sort_remaining
sort_values P ignore_index, key
std P axis, ddof, kwargs, numeric_only, skipna
str Y
struct Y
sub P axis, fill_value, level
subtract P axis, fill_value, level
sum P axis, kwargs, min_count, numeric_only, skipna
swaplevel P Y copy
tail Y Y
take Y
to_csv P chunksize, columns, compression, date_format, decimal, doublequote, encoding, errors, escapechar, float_format, index_label, lineterminator, mode, na_rep, quotechar, quoting, storage_options
to_dict Y
to_excel P columns, engine, engine_kwargs, float_format, freeze_panes, header, index, index_label, inf_rep, merge_cells, na_rep, startcol, startrow, storage_options
to_frame Y
to_json P compression, date_format, date_unit, default_handler, double_precision, force_ascii, indent, mode, storage_options
to_latex P bold_rows, caption, column_format, decimal, encoding, escape, float_format, formatters, index_names, label, longtable, multicolumn, multicolumn_format, multirow, na_rep, position, sparsify
to_list Y
to_markdown P storage_options
to_numpy Y
to_pickle P compression, protocol, storage_options
to_string Y
to_xarray Y
transpose P Y args, kwargs
truediv P axis, fill_value, level
unique Y
unstack P Y fill_value, sort
update Y
value_counts P bins
values Y
var P axis, ddof, kwargs, numeric_only, skipna
where P axis, inplace, level

Series.dt methods#

API Implemented Requires index Requires ordering Missing parameters
__annotations__ Y
__class__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__format__ Y
__ge__ Y
__getattribute__ Y
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ P orig
__init_subclass__ Y
__le__ Y
__lt__ Y
__module__ Y
__ne__ Y
__new__ P cls, data
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__setattr__ P key
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__subclasshook__ Y
__weakref__ Y
date Y
day Y
day_name P args, kwargs
day_of_week Y
day_of_year Y
dayofweek Y
dayofyear Y
days Y
floor P args, kwargs
hour Y
isocalendar Y
microseconds Y
minute Y
month Y
normalize P args, kwargs
quarter Y
second Y
seconds Y
strftime P args, kwargs
time Y
total_seconds P args, kwargs
tz Y
unit Y
year Y

Series.str methods#

API Implemented Requires index Requires ordering Missing parameters
__annotations__ Y
__class__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__format__ Y
__ge__ Y
__getattribute__ Y
__getitem__ Y
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ Y
__init_subclass__ Y
__le__ Y
__lt__ Y
__module__ Y
__ne__ Y
__new__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__setattr__ P key
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__subclasshook__ Y
__weakref__ Y
capitalize Y
cat P na_rep, sep
center Y
contains P na
endswith P na
extract P expand
find Y
fullmatch P na
get Y
isalnum Y
isalpha Y
isdecimal Y
isdigit Y
islower Y
isnumeric Y
isspace Y
isupper Y
join Y
len Y
ljust Y
lower Y
lstrip Y
match P na
pad Y
repeat Y
replace P n
rjust Y
rstrip Y
slice P step
split P expand, n
startswith P na
strip Y
upper Y
zfill Y

SeriesGroupBy#

API Implemented Requires index Requires ordering Missing parameters
__annotations__ Y
__class__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__format__ Y
__ge__ Y
__getattribute__ Y
__getitem__ Y
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ P axis, exclusions, group_keys, grouper, keys, level, obj, observed, selection, sort
__init_subclass__ Y
__iter__ Y
__le__ Y
__len__ Y
__lt__ Y
__module__ Y
__ne__ Y
__new__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__setattr__ Y
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__subclasshook__ Y
__weakref__ Y
agg P args, engine, engine_kwargs
aggregate P args, engine, engine_kwargs
all P skipna
any P skipna
corr P method, min_periods
count Y
cov P ddof, min_periods
cumcount Y Y
cummax P Y axis
cummin P Y axis
cumprod P Y axis
cumsum P Y axis
describe P exclude, percentiles
diff P Y axis
expanding P Y args, kwargs
first P Y skipna
head Y Y
last P Y skipna
max P engine, engine_kwargs, min_count
mean P engine, engine_kwargs
median Y
min P engine, engine_kwargs, min_count
nunique P dropna
prod Y
quantile P interpolation
rank P axis
rolling P Y args, kwargs
shift P Y axis, fill_value, freq, suffix
size Y
skew P axis, kwargs, skipna
std P ddof, engine, engine_kwargs
sum P engine, engine_kwargs, min_count
value_counts Y
var P ddof, engine, engine_kwargs

Window#

API Implemented Requires index Requires ordering Missing parameters
__annotations__ Y
__class__ Y
__delattr__ Y
__dict__ Y
__dir__ Y
__doc__ Y
__eq__ Y
__firstlineno__ Y
__format__ Y
__ge__ Y
__getattribute__ Y
__getstate__ Y
__gt__ Y
__hash__ Y
__init__ P axis, center, closed, method, min_periods, obj, on, selection, step, win_type, window
__init_subclass__ Y
__le__ Y
__lt__ Y
__module__ Y
__ne__ Y
__new__ Y
__reduce__ Y
__reduce_ex__ Y
__repr__ Y
__setattr__ Y
__sizeof__ Y
__static_attributes__ Y
__str__ Y
__subclasshook__ Y
__weakref__ Y
agg P args, kwargs
aggregate P args, kwargs
count P numeric_only
max P args, engine, engine_kwargs, kwargs, numeric_only
mean P engine, engine_kwargs, numeric_only
min P engine, engine_kwargs, numeric_only
std P ddof, engine, engine_kwargs, numeric_only
sum P engine, engine_kwargs, numeric_only
var P ddof, engine, engine_kwargs, numeric_only