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 P copy
array_ufunc Y
bool Y
class 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
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, errors
at Y
axes Y
bfill P Y axis, downcast, inplace, limit_area
columns Y
combine Y
combine_first Y
copy P deep
corr Y
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, inplace
drop_duplicates P ignore_index, inplace
droplevel Y
dropna P thresh
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
iat Y
idxmax P Y Y axis, numeric_only, skipna
idxmin P Y Y axis, numeric_only, skipna
iloc Y
index Y
info Y 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 lsuffix, rsuffix, sort, validate
kurt P axis, kwargs, skipna
kurtosis P axis, kwargs, skipna
le P level
loc Y
lt P level
map P kwargs
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 Y Y
pivot_table P Y Y 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 P pct
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, inplace, level, mapper
rename_axis P axis, columns, copy, index, inplace
reorder_levels Y
replace P inplace, limit, method
reset_index P allow_duplicates, col_fill, col_level, inplace, level, names
rfloordiv P fill_value, level
rmod P fill_value, level
rmul P fill_value, level
rolling P Y axis, center, closed, method, on, step, win_type
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, inplace, key, kind, level, sort_remaining
sort_values P axis, ignore_index, inplace, 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
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
## 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
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
cummax P Y axis
cummin P Y axis
cumprod P Y axis
cumsum P Y axis
diff P Y axis
expanding P Y args, kwargs
head Y Y
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
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
var P ddof, engine, engine_kwargs
## Index
API Implemented Requires index Requires ordering Missing parameters
T Y
annotations Y
array P copy
class Y
delattr Y
dict Y
dir Y
doc Y
eq P other
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
reduce Y
reduce_ex Y
repr Y
ror P other, self
setattr 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
has_duplicates Y
is_monotonic_decreasing Y
is_monotonic_increasing Y
is_unique Y
isin P level
max P args, axis, kwargs, skipna
min P args, axis, kwargs, skipna
name Y
names Y
ndim Y
nlevels Y
nunique P dropna
rename P inplace
shape Y
size Y
sort_values P key, return_indexer
to_numpy P copy, na_value
to_series Y
transpose P args, kwargs
value_counts P bins
values Y
## pandas module
API Implemented Requires index Requires ordering Missing parameters
ArrowDtype Y
BooleanDtype Y
DataFrame 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
cut P duplicates, include_lowest, ordered, precision, retbins, right
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
## Series
API Implemented Requires index Requires ordering Missing parameters
T Y
add Y
and Y
annotations Y
array P copy
array_ufunc Y
bool Y
class 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
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
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 args, convert_dtype, kwargs
argmax P Y args, axis, kwargs, skipna
argmin P Y args, axis, kwargs, skipna
astype P copy, errors
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
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
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
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 P Y pct
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, inplace, level
rename_axis P Y axis, copy, index, inplace
reorder_levels Y Y
replace P inplace, limit, method
reset_index P Y allow_duplicates, inplace, level
rfloordiv P axis, fill_value, level
rmod P axis, fill_value, level
rmul P axis, fill_value, level
rolling P Y axis, center, closed, 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, inplace, key, kind, level, sort_remaining
sort_values P ignore_index, inplace, 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
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
dayofweek Y
floor P args, kwargs
hour Y
minute Y
month Y
normalize P args, kwargs
quarter Y
second Y
strftime P args, kwargs
time Y
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
len Y
ljust Y
lower Y
lstrip P to_strip
match P na
pad Y
repeat Y
replace P n
rjust Y
rstrip P to_strip
slice P step
split P expand, n
startswith P na
strip P to_strip
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
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
cummax P Y axis
cummin P Y axis
cumprod P Y axis
cumsum P Y axis
diff P Y axis
expanding P Y args, kwargs
head Y Y
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
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
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