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

APIImplementedRequires indexRequires orderingMissing parameters
TY
addY
andY
annotationsY
arrayY
array_ufuncY
boolY
classY
delattrY
delitemY
dictY
dirY
docY
eqY
floordivY
formatY
geY
getattrPname
getattributeY
getitemY
gtY
hashY
initY
init_subclassY
invertY
iterY
leY
lenY
ltY
matmulY
modY
moduleY
mulY
neY
negY
newY
nonzeroY
orY
pandas_priorityY
posY
powY
raddY
randY
reduceY
reduce_exY
reprY
rfloordivY
rmodY
rmulY
rorY
rpowY
rsubY
rtruedivY
rxorY
setattrPname
setitemY
sizeofY
strY
subY
subclasshookY
truedivY
weakrefY
xorY
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
applyPby_row, engine, engine_kwargs, raw, result_type
applymapPkwargs
assignY
astypePcopy
atY
axesY
bfillPYaxis, downcast, inplace, limit_area
columnsY
combineY
combine_firstY
copyPdeep
corrY
corrwithPaxis, drop, method
countPaxis
covPddof, min_periods
cummaxPYargs, axis, kwargs, skipna
cumminPYargs, axis, kwargs, skipna
cumprodPYargs, axis, kwargs, skipna
cumsumPYargs, axis, kwargs, skipna
describePexclude, percentiles
diffPYaxis
divPfill_value, level
dividePfill_value, level
dotYY
dropPerrors, inplace
drop_duplicatesPignore_index, inplace
droplevelY
dropnaPthresh
dtypesY
duplicatedY
emptyY
eqPlevel
equalsYY
evalPinplace, kwargs
expandingPYaxis, method
explodeY
ffillPYaxis, 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
headYY
histPax, backend, column, data, figsize, grid, layout, legend, sharex, sharey, xlabelsize, xrot, ylabelsize, yrot
iatY
idxmaxPYYaxis, numeric_only, skipna
idxminPYYaxis, numeric_only, skipna
ilocY
indexY
infoYY
insertY
interpolatePYYaxis, 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
maskPaxis, inplace, level
maxPkwargs, skipna
meanPkwargs, skipna
medianPaxis, kwargs, skipna
meltPYcol_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_changePYfill_method, freq, kwargs, limit
pipeY
pivotYYY
pivot_tablePYYdropna, fill_value, margins, margins_name, observed, sort
plotY
powPfill_value, level
prodPkwargs, min_count, skipna
productPkwargs, min_count, skipna
quantilePaxis, interpolation, method
queryPinplace, kwargs
raddPfill_value, level
rankPpct
rdivPfill_value, level
reindexPcopy, fill_value, level, limit, method, tolerance
reindex_likePYcopy, 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
rollingPYaxis, center, method, step, win_type
rpowPfill_value, level
rsubPfill_value, level
rtruedivPfill_value, level
samplePYaxis, ignore_index, replace, weights
select_dtypesY
set_indexPinplace, verify_integrity
shapeY
shiftPYaxis, fill_value, freq, suffix
sizeY
skewPaxis, kwargs, skipna
sort_indexPYaxis, 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
tailYY
takeY
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
transposePYYargs, copy
truedivPfill_value, level
unstackPYYfill_value, sort
updatePerrors
value_countsY
valuesY
varPddof, kwargs, skipna
wherePaxis, inplace, level
## DataFrameGroupBy
APIImplementedRequires indexRequires orderingMissing 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
cummaxPYaxis
cumminPYaxis
cumprodPYaxis
cumsumPYaxis
diffPYaxis
expandingPYargs, kwargs
headYY
maxPengine, engine_kwargs, min_count
meanPengine, engine_kwargs
medianY
minPengine, engine_kwargs, min_count
nuniquePdropna
prodY
quantilePinterpolation
rankPaxis, pct
rollingPYargs, kwargs
shiftPYaxis, fill_value, freq, suffix
sizeY
skewPaxis, kwargs, skipna
stdPddof, engine, engine_kwargs
sumPengine, engine_kwargs, min_count
varPddof, engine, engine_kwargs
## Index
APIImplementedRequires indexRequires orderingMissing 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
pandas_priorityY
reduceY
reduce_exY
reprY
rorPother, self
setattrY
sizeofY
strY
subclasshookY
weakrefY
allPargs, kwargs
anyPargs, kwargs
argmaxPYargs, axis, kwargs, skipna
argminPYargs, 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
APIImplementedRequires indexRequires orderingMissing parameters
ArrowDtypeY
BooleanDtypeY
DataFrameY
Float64DtypeY
IndexY
Int64DtypeY
MultiIndexY
NAY
NamedAggY
SeriesY
StringDtypeY
allY
builtinsY
cachedY
docY
fileY
loaderY
nameY
packageY
pathY
specY
versionY
annotationsY
concatPcopy, keys, levels, names, sort, verify_integrity
coreY
cutPduplicates, include_lowest, ordered, precision, retbins
get_dummiesPsparse
ioY
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
to_timedeltaPerrors
## Series
APIImplementedRequires indexRequires orderingMissing parameters
TY
absY
addY
andY
annotationsY
arrayY
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
negY
newY
nonzeroY
orY
pandas_priorityY
posY
powY
raddY
randY
reduceY
reduce_exY
reprY
rfloordivY
rmatmulY
rmodY
rmulY
rorY
rpowY
rsubY
rtruedivY
rxorY
setattrY
sizeofY
strY
subY
subclasshookY
truedivY
weakrefY
xorY
absY
addPaxis, fill_value, level
add_prefixYY
add_suffixYY
aggPargs, axis, kwargs
aggregatePargs, axis, kwargs
allPaxis, bool_only, kwargs, skipna
anyPaxis, bool_only, kwargs, skipna
applyPargs, convert_dtype, kwargs
argmaxPYargs, axis, kwargs, skipna
argminPYargs, axis, kwargs, skipna
astypePcopy
atY
autocorrY
betweenY
bfillPYaxis, downcast, inplace, limit_area
case_whenY
clipPaxis, inplace, kwargs
combinePfill_value
combine_firstY
copyPdeep
corrY
countY
covPddof, min_periods
cummaxPYargs, axis, kwargs, skipna
cumminPYargs, axis, kwargs, skipna
cumprodPYargs, axis, kwargs, skipna
cumsumPYargs, axis, kwargs, skipna
diffYY
divPaxis, fill_value, level
dividePaxis, fill_value, level
divmodPaxis, fill_value, level
dotY
dropPerrors, inplace
drop_duplicatesPignore_index, inplace
droplevelYY
dropnaY
dtY
dtypeY
dtypesY
duplicatedY
emptyY
eqPaxis, fill_value, level
equalsY
expandingPYaxis, method
explodeY
ffillPYaxis, 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
headYY
histPax, backend, figsize, grid, legend, xlabelsize, xrot, ylabelsize, yrot
iatY
idxmaxPYargs, axis, kwargs, skipna
idxminPYargs, axis, kwargs, skipna
ilocY
indexY
interpolatePYYaxis, 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
listY
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
padPYaxis, downcast, inplace
pct_changePYfill_method, freq, kwargs, limit
pipeY
plotY
powPaxis, fill_value, level
prodPaxis, kwargs, min_count, numeric_only, skipna
productPaxis, kwargs, min_count, numeric_only, skipna
quantilePinterpolation
raddPaxis, fill_value, level
rankPYpct
rdivPaxis, fill_value, level
rdivmodPaxis, fill_value, level
reindexPYaxis, copy, fill_value, level, limit, method, tolerance
reindex_likePYcopy, limit, method, tolerance
renamePaxis, copy, errors, inplace, level
rename_axisPYaxis, copy, index, inplace
reorder_levelsYY
replacePinplace, limit, method
reset_indexPYallow_duplicates, inplace, level
rfloordivPaxis, fill_value, level
rmodPaxis, fill_value, level
rmulPaxis, fill_value, level
rollingPYaxis, center, method, on, step, win_type
roundPargs, kwargs
rpowPaxis, fill_value, level
rsubPaxis, fill_value, level
rtruedivPaxis, fill_value, level
samplePYaxis, ignore_index, replace, weights
shapeY
shiftPYaxis, fill_value, freq, suffix
sizeY
skewPaxis, kwargs, numeric_only, skipna
sort_indexPYignore_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
swaplevelPYcopy
tailYY
takeY
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
transposePYargs, kwargs
truedivPaxis, fill_value, level
uniqueY
unstackPYfill_value, sort
updateY
value_countsPbins
valuesY
varPaxis, ddof, kwargs, numeric_only, skipna
wherePaxis, inplace, level
## Series.dt methods
APIImplementedRequires indexRequires orderingMissing 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
APIImplementedRequires indexRequires orderingMissing parameters
annotationsY
classY
delattrY
dictY
dirY
docY
eqY
formatY
geY
getattributeY
getitemY
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
splitPexpand, n
startswithPna
stripPto_strip
upperY
zfillY
## SeriesGroupBy
APIImplementedRequires indexRequires orderingMissing 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
cummaxPYaxis
cumminPYaxis
cumprodPYaxis
cumsumPYaxis
diffPYaxis
expandingPYargs, kwargs
headYY
maxPengine, engine_kwargs, min_count
meanPengine, engine_kwargs
medianY
minPengine, engine_kwargs, min_count
nuniquePdropna
prodY
quantilePinterpolation
rankPaxis, pct
rollingPYargs, kwargs
shiftPYaxis, fill_value, freq, suffix
sizeY
skewPaxis, kwargs, skipna
stdPddof, engine, engine_kwargs
sumPengine, engine_kwargs, min_count
varPddof, engine, engine_kwargs
## Window
APIImplementedRequires indexRequires orderingMissing 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