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
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