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
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
floordiv Y
format Y
ge Y
getattr P name
getattribute Y
getitem 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
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, left_index, right_index, 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 P dropna, fill_value, margins, margins_name, observed, sort
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
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 Y axis, 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
format Y
ge Y
getattribute Y
getitem 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
lt Y
module Y
ne Y
new Y
reduce Y
reduce_ex Y
repr Y
setattr Y
sizeof 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
count Y
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
format Y
ge P other
getattribute Y
getitem 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
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
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
cut P duplicates, include_lowest, ordered, precision, retbins
get_dummies P sparse
io Y
merge P copy, indicator, left_index, right_index, 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
floordiv Y
format Y
ge Y
getattr P name
getattribute Y
getitem P key
gt Y
hash Y
init P copy, data, dtype, fastpath, index, name
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
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
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
format Y
ge Y
getattribute 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
str Y
subclasshook Y
weakref Y
date Y
day Y
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
format Y
ge Y
getattribute Y
getitem 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
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
format Y
ge Y
getattribute Y
getitem 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
lt Y
module Y
ne Y
new Y
reduce Y
reduce_ex Y
repr Y
setattr Y
sizeof 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
count Y
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
format Y
ge Y
getattribute 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
str Y
subclasshook Y
weakref Y
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

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年10月14日 UTC.