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

APIImplementedMissing parameters
addY
annotationsY
arrayPcopy
array_ufuncY
boolY
classY
delattrY
dictY
dirY
docY
eqY
floordivY
formatY
geY
getattrPname
getattributeY
getitemY
gtY
hashY
initY
init_subclassY
iterY
leY
lenY
ltY
matmulY
modY
moduleY
mulY
neY
newY
nonzeroY
orPother, self
powY
raddY
reduceY
reduce_exY
reprY
rfloordivY
rmodY
rmulY
rorPother, self
rpowY
rsubY
rtruedivY
setattrPname
setitemY
sizeofY
strY
subY
subclasshookY
truedivY
weakrefY
absY
addPfill_value, level
add_prefixY
add_suffixY
aggPargs, axis, kwargs
aggregatePargs, axis, kwargs
alignPbroadcast_axis, copy, fill_axis, fill_value, level, limit, method
allPkwargs, skipna
anyPkwargs, skipna
applyPaxis, by_row, engine, engine_kwargs, raw, result_type
applymapPkwargs
assignY
astypePcopy, errors
atY
axesY
bfillPaxis, downcast, inplace, limit_area
columnsY
combineY
combine_firstY
copyPdeep
corrY
countPaxis
covPddof, min_periods
cummaxPargs, axis, kwargs, skipna
cumminPargs, axis, kwargs, skipna
cumprodPargs, axis, kwargs, skipna
cumsumPargs, axis, kwargs, skipna
describePexclude, include, percentiles
diffPaxis
divPfill_value, level
dividePfill_value, level
dotY
dropPerrors, inplace
drop_duplicatesPignore_index, inplace
droplevelY
dropnaPsubset, thresh
dtypesY
duplicatedY
emptyY
eqPlevel
equalsY
evalPinplace, kwargs
expandingPaxis, method
explodeY
ffillPaxis, downcast, inplace, limit_area
fillnaPaxis, downcast, inplace, limit, method
filterY
first_valid_indexY
floordivPfill_value, level
from_dictY
from_recordsY
gePlevel
getY
groupbyPaxis, group_keys, observed, sort
gtPlevel
headY
iatY
idxmaxPaxis, numeric_only, skipna
idxminPaxis, numeric_only, skipna
ilocY
indexY
infoY
interpolatePaxis, downcast, inplace, kwargs, limit, limit_area, limit_direction
isinY
isnaY
isnullY
iterrowsY
itertuplesY
joinPlsuffix, rsuffix, sort, validate
kurtPaxis, kwargs, skipna
kurtosisPaxis, kwargs, skipna
lePlevel
locY
ltPlevel
mapPkwargs
maxPkwargs, skipna
meanPkwargs, skipna
medianPaxis, kwargs, skipna
meltPcol_level, ignore_index
memory_usagePdeep
mergePcopy, indicator, left_index, right_index, validate
minPkwargs, skipna
modPfill_value, level
mulPfill_value, level
multiplyPfill_value, level
ndimY
nePlevel
nlargestY
notnaY
notnullY
nsmallestY
nuniquePaxis, dropna
pct_changePfill_method, freq, kwargs, limit
pipeY
pivotY
pivot_tablePdropna, fill_value, margins, margins_name, observed, sort
plotY
powPfill_value, level
prodPkwargs, min_count, skipna
productPkwargs, min_count, skipna
queryPinplace, kwargs
raddPfill_value, level
rankPpct
rdivPfill_value, level
reindexPcopy, fill_value, level, limit, method, tolerance
reindex_likePcopy, limit, method, tolerance
renamePaxis, copy, errors, index, inplace, level, mapper
rename_axisPaxis, columns, copy, index, inplace
reorder_levelsY
replacePinplace, limit, method
reset_indexPallow_duplicates, col_fill, col_level, inplace, level, names
rfloordivPfill_value, level
rmodPfill_value, level
rmulPfill_value, level
rollingPaxis, center, closed, method, on, step, win_type
rpowPfill_value, level
rsubPfill_value, level
rtruedivPfill_value, level
samplePaxis, ignore_index, replace, weights
select_dtypesY
set_indexPinplace, verify_integrity
shapeY
shiftPaxis, fill_value, freq, suffix
sizeY
skewPaxis, kwargs, skipna
sort_indexPaxis, ignore_index, inplace, key, kind, level, sort_remaining
sort_valuesPaxis, ignore_index, inplace, key
stackPdropna, future_stack, sort
stdPddof, kwargs, skipna
subPfill_value, level
subtractPfill_value, level
sumPkwargs, min_count, skipna
swaplevelY
tailY
to_csvPchunksize, columns, compression, date_format, decimal, doublequote, encoding, errors, escapechar, float_format, index_label, lineterminator, mode, na_rep, quotechar, quoting, storage_options
to_dictPindex
to_excelPcolumns, engine, engine_kwargs, float_format, freeze_panes, header, index, index_label, inf_rep, merge_cells, na_rep, startcol, startrow, storage_options
to_gbqPauth_local_webserver, chunksize, credentials, location, progress_bar, project_id, reauth, table_schema
to_htmlY
to_jsonPcompression, date_format, date_unit, default_handler, double_precision, force_ascii, indent, mode, storage_options
to_latexPbold_rows, caption, column_format, decimal, encoding, escape, float_format, formatters, index_names, label, longtable, multicolumn, multicolumn_format, multirow, na_rep, position, sparsify
to_markdownPstorage_options
to_numpyY
to_orcPengine, engine_kwargs, index
to_parquetPengine, kwargs, partition_cols, storage_options
to_picklePcompression, protocol, storage_options
to_recordsY
to_stringY
truedivPfill_value, level
unstackPfill_value, sort
updatePerrors
value_countsY
valuesY
varPddof, kwargs, skipna
## DataFrameGroupBy
APIImplementedMissing parameters
annotationsY
classY
delattrY
dictY
dirY
docY
eqY
formatY
geY
getattributeY
getitemY
gtY
hashY
initPaxis, exclusions, group_keys, grouper, keys, level, obj, observed, selection, sort
init_subclassY
leY
ltY
moduleY
neY
newY
reduceY
reduce_exY
reprY
setattrY
sizeofY
strY
subclasshookY
weakrefY
aggPargs, engine, engine_kwargs
aggregatePargs, engine, engine_kwargs
allPskipna
anyPskipna
countY
cumcountY
cummaxPaxis
cumminPaxis
cumprodPaxis
cumsumPaxis
diffPaxis
expandingPargs, kwargs
maxPengine, engine_kwargs, min_count
meanPengine, engine_kwargs
medianY
minPengine, engine_kwargs, min_count
nuniquePdropna
prodY
rollingPargs, kwargs
shiftPaxis, fill_value, freq, suffix
skewPaxis, kwargs, skipna
stdPddof, engine, engine_kwargs
sumPengine, engine_kwargs, min_count
varPddof, engine, engine_kwargs
## Index
APIImplementedMissing parameters
TY
annotationsY
arrayPcopy
classY
delattrY
dictY
dirY
docY
eqPother
formatY
gePother
getattributeY
getitemY
gtPother
hashY
initY
init_subclassY
lePother
lenY
ltPother
moduleY
nePother
newPcopy, tupleize_cols
orPother, self
reduceY
reduce_exY
reprY
rorPother, self
setattrY
sizeofY
strY
subclasshookY
weakrefY
allPargs, kwargs
anyPargs, kwargs
argmaxPargs, axis, kwargs, skipna
argminPargs, axis, kwargs, skipna
astypePcopy
copyPdeep
dropPerrors
drop_duplicatesY
dropnaY
dtypeY
emptyY
fillnaPdowncast
get_level_valuesY
has_duplicatesY
is_monotonic_decreasingY
is_monotonic_increasingY
is_uniqueY
isinPlevel
maxPargs, axis, kwargs, skipna
minPargs, axis, kwargs, skipna
nameY
namesY
ndimY
nlevelsY
nuniquePdropna
renamePinplace
shapeY
sizeY
sort_valuesPkey, return_indexer
to_numpyPcopy, na_value
to_seriesY
transposePargs, kwargs
value_countsPbins
valuesY
## pandas module
APIImplementedMissing parameters
ArrowDtypeY
BooleanDtypeY
DataFrameY
Float64DtypeY
IndexY
Int64DtypeY
MultiIndexY
NAY
NamedAggY
SeriesY
StringDtypeY
builtinsY
cachedY
docY
fileY
loaderY
nameY
packageY
pathY
specY
annotationsY
concatPcopy, keys, levels, names, sort, verify_integrity
cutPduplicates, include_lowest, ordered, precision, retbins, right
get_dummiesPsparse
mergePcopy, indicator, left_index, right_index, validate
option_contextY
optionsY
pandasY
qcutPprecision, retbins
read_csvPcache_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_gbqPauth_local_webserver, credentials, dialect, location, progress_bar_type, project_id, query, reauth, use_bqstorage_api
read_jsonPchunksize, compression, convert_axes, convert_dates, date_unit, dtype_backend, encoding_errors, keep_default_dates, nrows, precise_float, storage_options, typ
read_parquetPcolumns, dtype_backend, filesystem, filters, kwargs, storage_options, use_nullable_dtypes
read_pickleY
to_datetimePcache, dayfirst, errors, exact, infer_datetime_format, origin, yearfirst
## Series
APIImplementedMissing parameters
TY
addY
andY
annotationsY
arrayPcopy
array_ufuncY
boolY
classY
delattrY
dictY
dirY
docY
eqY
floordivY
formatY
geY
getattrPname
getattributeY
getitemPkey
gtY
hashY
initPcopy, data, dtype, fastpath, index, name
init_subclassY
invertY
iterY
leY
lenY
ltY
matmulY
modY
moduleY
mulY
neY
newY
nonzeroY
orY
powY
raddY
randY
reduceY
reduce_exY
reprY
rfloordivY
rmatmulY
rmodY
rmulY
rorY
rpowY
rsubY
rtruedivY
setattrY
sizeofY
strY
subY
subclasshookY
truedivY
weakrefY
absY
addPaxis, fill_value, level
add_prefixY
add_suffixY
aggPargs, axis, kwargs
aggregatePargs, axis, kwargs
allPaxis, bool_only, kwargs, skipna
anyPaxis, bool_only, kwargs, skipna
applyPargs, convert_dtype, kwargs
argmaxPargs, axis, kwargs, skipna
argminPargs, axis, kwargs, skipna
astypePcopy, errors
atY
autocorrY
betweenY
bfillPaxis, downcast, inplace, limit_area
clipPaxis, inplace, kwargs
combine_firstY
copyPdeep
corrY
countY
covPddof, min_periods
cummaxPargs, axis, kwargs, skipna
cumminPargs, axis, kwargs, skipna
cumprodPargs, axis, kwargs, skipna
cumsumPargs, axis, kwargs, skipna
diffY
divPaxis, fill_value, level
dividePaxis, fill_value, level
divmodPaxis, fill_value, level
dotY
dropPerrors, inplace
drop_duplicatesPignore_index, inplace
droplevelY
dropnaY
dtY
dtypeY
dtypesY
duplicatedY
emptyY
eqPaxis, fill_value, level
equalsY
expandingPaxis, method
explodeY
ffillPaxis, downcast, inplace, limit_area
fillnaPaxis, downcast, inplace, limit, method
filterY
floordivPaxis, fill_value, level
gePaxis, fill_value, level
getY
groupbyPgroup_keys, observed, sort
gtPaxis, fill_value, level
hasnansY
headY
iatY
idxmaxPargs, axis, kwargs, skipna
idxminPargs, axis, kwargs, skipna
ilocY
indexY
interpolatePaxis, downcast, inplace, kwargs, limit, limit_area, limit_direction
is_monotonic_decreasingY
is_monotonic_increasingY
isinY
isnaY
isnullY
kurtPaxis, kwargs, numeric_only, skipna
kurtosisPaxis, kwargs, numeric_only, skipna
lePaxis, fill_value, level
locY
ltPaxis, fill_value, level
mapY
maskPaxis, inplace, level
maxPaxis, kwargs, numeric_only, skipna
meanPaxis, kwargs, numeric_only, skipna
medianPaxis, kwargs, numeric_only, skipna
minPaxis, kwargs, numeric_only, skipna
modPaxis, fill_value, level
modePdropna
mulPaxis, fill_value, level
multiplyPaxis, fill_value, level
nameY
ndimY
nePaxis, fill_value, level
nlargestY
notnaY
notnullY
nsmallestY
nuniquePdropna
padPaxis, downcast, inplace
pct_changePfill_method, freq, kwargs, limit
pipeY
plotY
powPaxis, fill_value, level
prodPaxis, kwargs, min_count, numeric_only, skipna
productPaxis, kwargs, min_count, numeric_only, skipna
raddPaxis, fill_value, level
rankPpct
rdivPaxis, fill_value, level
rdivmodPaxis, fill_value, level
reindexPaxis, copy, fill_value, level, limit, method, tolerance
reindex_likePcopy, limit, method, tolerance
renamePaxis, copy, errors, inplace, level
rename_axisPaxis, copy, index, inplace
reorder_levelsY
replacePinplace, limit, method
reset_indexPallow_duplicates, inplace, level
rfloordivPaxis, fill_value, level
rmodPaxis, fill_value, level
rmulPaxis, fill_value, level
rollingPaxis, center, closed, method, on, step, win_type
roundPargs, kwargs
rpowPaxis, fill_value, level
rsubPaxis, fill_value, level
rtruedivPaxis, fill_value, level
samplePaxis, ignore_index, replace, weights
shapeY
shiftPaxis, fill_value, freq, suffix
sizeY
skewPaxis, kwargs, numeric_only, skipna
sort_indexPignore_index, inplace, key, kind, level, sort_remaining
sort_valuesPignore_index, inplace, key
stdPaxis, ddof, kwargs, numeric_only, skipna
strY
structY
subPaxis, fill_value, level
subtractPaxis, fill_value, level
sumPaxis, kwargs, min_count, numeric_only, skipna
swaplevelPcopy
tailY
to_csvPchunksize, columns, compression, date_format, decimal, doublequote, encoding, errors, escapechar, float_format, index_label, lineterminator, mode, na_rep, quotechar, quoting, storage_options
to_dictY
to_excelPcolumns, engine, engine_kwargs, float_format, freeze_panes, header, index, index_label, inf_rep, merge_cells, na_rep, startcol, startrow, storage_options
to_frameY
to_jsonPcompression, date_format, date_unit, default_handler, double_precision, force_ascii, indent, mode, storage_options
to_latexPbold_rows, caption, column_format, decimal, encoding, escape, float_format, formatters, index_names, label, longtable, multicolumn, multicolumn_format, multirow, na_rep, position, sparsify
to_listY
to_markdownPstorage_options
to_numpyY
to_picklePcompression, protocol, storage_options
to_stringY
to_xarrayY
transposePargs, kwargs
truedivPaxis, fill_value, level
uniqueY
unstackPfill_value, sort
updateY
value_countsPbins
valuesY
varPaxis, ddof, kwargs, numeric_only, skipna
wherePaxis, inplace, level
## Series.dt methods
APIImplementedMissing parameters
annotationsY
classY
delattrY
dictY
dirY
docY
eqY
formatY
geY
getattributeY
gtY
hashY
initPorig
init_subclassY
leY
ltY
moduleY
neY
newPcls, data
reduceY
reduce_exY
reprY
setattrPkey
sizeofY
strY
subclasshookY
weakrefY
dateY
dayY
dayofweekY
floorPargs, kwargs
hourY
minuteY
monthY
normalizePargs, kwargs
quarterY
secondY
strftimePargs, kwargs
timeY
tzY
unitY
yearY
## Series.str methods
APIImplementedMissing parameters
annotationsY
classY
delattrY
dictY
dirY
docY
eqY
formatY
geY
getattributeY
gtY
hashY
initY
init_subclassY
leY
ltY
moduleY
neY
newY
reduceY
reduce_exY
reprY
setattrPkey
sizeofY
strY
subclasshookY
weakrefY
capitalizeY
catPna_rep, sep
centerY
containsPna
endswithPna
extractPexpand
findY
fullmatchPna
getY
isalnumY
isalphaY
isdecimalY
isdigitY
islowerY
isnumericY
isspaceY
isupperY
lenY
ljustY
lowerY
lstripPto_strip
matchPna
padY
repeatY
replacePn
rjustY
rstripPto_strip
slicePstep
startswithPna
stripPto_strip
upperY
zfillY
## SeriesGroupBy
APIImplementedMissing parameters
annotationsY
classY
delattrY
dictY
dirY
docY
eqY
formatY
geY
getattributeY
getitemY
gtY
hashY
initPaxis, exclusions, group_keys, grouper, keys, level, obj, observed, selection, sort
init_subclassY
leY
ltY
moduleY
neY
newY
reduceY
reduce_exY
reprY
setattrY
sizeofY
strY
subclasshookY
weakrefY
aggPargs, engine, engine_kwargs
aggregatePargs, engine, engine_kwargs
allPskipna
anyPskipna
countY
cumcountY
cummaxPaxis
cumminPaxis
cumprodPaxis
cumsumPaxis
diffPaxis
expandingPargs, kwargs
maxPengine, engine_kwargs, min_count
meanPengine, engine_kwargs
medianY
minPengine, engine_kwargs, min_count
nuniquePdropna
prodY
rollingPargs, kwargs
shiftPaxis, fill_value, freq, suffix
skewPaxis, kwargs, skipna
stdPddof, engine, engine_kwargs
sumPengine, engine_kwargs, min_count
varPddof, engine, engine_kwargs
## Window
APIImplementedMissing parameters
annotationsY
classY
delattrY
dictY
dirY
docY
eqY
formatY
geY
getattributeY
gtY
hashY
initPaxis, center, closed, method, min_periods, obj, on, selection, step, win_type, window
init_subclassY
leY
ltY
moduleY
neY
newY
reduceY
reduce_exY
reprY
setattrY
sizeofY
strY
subclasshookY
weakrefY
countPnumeric_only
maxPargs, engine, engine_kwargs, kwargs, numeric_only
meanPengine, engine_kwargs, numeric_only
minPengine, engine_kwargs, numeric_only
stdPddof, engine, engine_kwargs, numeric_only
sumPengine, engine_kwargs, numeric_only
varPddof, engine, engine_kwargs, numeric_only