- 2.17.0 (latest)
- 2.16.0
- 2.15.0
- 2.14.0
- 2.13.0
- 2.12.0
- 2.11.0
- 2.10.0
- 2.9.0
- 2.8.0
- 2.7.0
- 2.6.0
- 2.5.0
- 2.4.0
- 2.3.0
- 2.2.0
- 2.0.0-dev0
- 1.36.0
- 1.35.0
- 1.34.0
- 1.33.0
- 1.32.0
- 1.31.0
- 1.30.0
- 1.29.0
- 1.28.0
- 1.27.0
- 1.26.0
- 1.25.0
- 1.24.0
- 1.22.0
- 1.21.0
- 1.20.0
- 1.19.0
- 1.18.0
- 1.17.0
- 1.16.0
- 1.15.0
- 1.14.0
- 1.13.0
- 1.12.0
- 1.11.1
- 1.10.0
- 1.9.0
- 1.8.0
- 1.7.0
- 1.6.0
- 1.5.0
- 1.4.0
- 1.3.0
- 1.2.0
- 1.1.0
- 1.0.0
- 0.26.0
- 0.25.0
- 0.24.0
- 0.23.0
- 0.22.0
- 0.21.0
- 0.20.1
- 0.19.2
- 0.18.0
- 0.17.0
- 0.16.0
- 0.15.0
- 0.14.1
- 0.13.0
- 0.12.0
- 0.11.0
- 0.10.0
- 0.9.0
- 0.8.0
- 0.7.0
- 0.6.0
- 0.5.0
- 0.4.0
- 0.3.0
- 0.2.0
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 | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
P | copy | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | name | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | other, self | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | other, self | |
Y | ||
Y | ||
Y | ||
P | name | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | fill_value, level | |
Y | ||
Y | ||
P | args, axis, kwargs | |
P | args, axis, kwargs | |
P | broadcast_axis, copy, fill_axis, fill_value, level, limit, method | |
P | kwargs, skipna | |
P | kwargs, skipna | |
P | axis, by_row, engine, engine_kwargs, raw, result_type | |
P | kwargs | |
Y | ||
P | copy, errors | |
Y | ||
Y | ||
P | axis, downcast, inplace, limit_area | |
Y | ||
Y | ||
Y | ||
P | deep | |
Y | ||
P | axis | |
P | ddof, min_periods | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | exclude, include, percentiles | |
P | axis | |
P | fill_value, level | |
P | fill_value, level | |
Y | ||
P | errors, inplace | |
P | ignore_index, inplace | |
Y | ||
P | subset, thresh | |
Y | ||
Y | ||
Y | ||
P | level | |
Y | ||
P | inplace, kwargs | |
P | axis, method | |
Y | ||
P | axis, downcast, inplace, limit_area | |
P | axis, downcast, inplace, limit, method | |
Y | ||
Y | ||
P | fill_value, level | |
Y | ||
Y | ||
P | level | |
Y | ||
P | axis, group_keys, observed, sort | |
P | level | |
Y | ||
Y | ||
P | axis, numeric_only, skipna | |
P | axis, numeric_only, skipna | |
Y | ||
Y | ||
Y | ||
P | axis, downcast, inplace, kwargs, limit, limit_area, limit_direction | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | lsuffix, rsuffix, sort, validate | |
P | axis, kwargs, skipna | |
P | axis, kwargs, skipna | |
P | level | |
Y | ||
P | level | |
P | kwargs | |
P | kwargs, skipna | |
P | kwargs, skipna | |
P | axis, kwargs, skipna | |
P | col_level, ignore_index | |
P | deep | |
P | copy, indicator, left_index, right_index, validate | |
P | kwargs, skipna | |
P | fill_value, level | |
P | fill_value, level | |
P | fill_value, level | |
Y | ||
P | level | |
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, dropna | |
P | fill_method, freq, kwargs, limit | |
Y | ||
Y | ||
P | dropna, fill_value, margins, margins_name, observed, sort | |
Y | ||
P | fill_value, level | |
P | kwargs, min_count, skipna | |
P | kwargs, min_count, skipna | |
P | axis, interpolation, method | |
P | inplace, kwargs | |
P | fill_value, level | |
P | pct | |
P | fill_value, level | |
P | copy, fill_value, level, limit, method, tolerance | |
P | copy, limit, method, tolerance | |
P | axis, copy, errors, index, inplace, level, mapper | |
P | axis, columns, copy, index, inplace | |
Y | ||
P | inplace, limit, method | |
P | allow_duplicates, col_fill, col_level, inplace, level, names | |
P | fill_value, level | |
P | fill_value, level | |
P | fill_value, level | |
P | axis, center, closed, method, on, step, win_type | |
P | fill_value, level | |
P | fill_value, level | |
P | fill_value, level | |
P | axis, ignore_index, replace, weights | |
Y | ||
P | inplace, verify_integrity | |
Y | ||
P | axis, fill_value, freq, suffix | |
Y | ||
P | axis, kwargs, skipna | |
P | axis, ignore_index, inplace, key, kind, level, sort_remaining | |
P | axis, ignore_index, inplace, key | |
P | dropna, future_stack, sort | |
P | ddof, kwargs, skipna | |
P | fill_value, level | |
P | fill_value, level | |
P | kwargs, min_count, skipna | |
Y | ||
Y | ||
P | chunksize, columns, compression, date_format, decimal, doublequote, encoding, errors, escapechar, float_format, index_label, lineterminator, mode, na_rep, quotechar, quoting, storage_options | |
P | index | |
P | columns, engine, engine_kwargs, float_format, freeze_panes, header, index, index_label, inf_rep, merge_cells, na_rep, startcol, startrow, storage_options | |
P | auth_local_webserver, chunksize, credentials, location, progress_bar, project_id, reauth, table_schema | |
Y | ||
P | compression, date_format, date_unit, default_handler, double_precision, force_ascii, indent, mode, storage_options | |
P | bold_rows, caption, column_format, decimal, encoding, escape, float_format, formatters, index_names, label, longtable, multicolumn, multicolumn_format, multirow, na_rep, position, sparsify | |
P | storage_options | |
Y | ||
P | engine, engine_kwargs, index | |
P | engine, kwargs, partition_cols, storage_options | |
P | compression, protocol, storage_options | |
Y | ||
Y | ||
P | args, copy | |
P | fill_value, level | |
P | fill_value, sort | |
P | errors | |
Y | ||
Y | ||
P | ddof, kwargs, skipna |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, exclusions, group_keys, grouper, keys, level, obj, observed, selection, sort | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | args, engine, engine_kwargs | |
P | args, engine, engine_kwargs | |
P | skipna | |
P | skipna | |
Y | ||
Y | ||
P | axis | |
P | axis | |
P | axis | |
P | axis | |
P | axis | |
P | args, kwargs | |
P | engine, engine_kwargs, min_count | |
P | engine, engine_kwargs | |
Y | ||
P | engine, engine_kwargs, min_count | |
P | dropna | |
Y | ||
P | interpolation | |
P | args, kwargs | |
P | axis, fill_value, freq, suffix | |
P | axis, kwargs, skipna | |
P | ddof, engine, engine_kwargs | |
P | engine, engine_kwargs, min_count | |
P | ddof, engine, engine_kwargs |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
P | copy | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | other | |
Y | ||
P | other | |
Y | ||
Y | ||
P | other | |
Y | ||
Y | ||
Y | ||
P | other | |
Y | ||
P | other | |
Y | ||
P | other | |
P | copy, tupleize_cols | |
P | other, self | |
Y | ||
Y | ||
Y | ||
P | other, self | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | args, kwargs | |
P | args, kwargs | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | copy | |
P | deep | |
P | errors | |
Y | ||
Y | ||
Y | ||
Y | ||
P | downcast | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | level | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
Y | ||
Y | ||
Y | ||
Y | ||
P | dropna | |
P | inplace | |
Y | ||
Y | ||
P | key, return_indexer | |
P | copy, na_value | |
Y | ||
P | args, kwargs | |
P | bins | |
Y |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | copy, keys, levels, names, sort, verify_integrity | |
P | duplicates, include_lowest, ordered, precision, retbins, right | |
P | sparse | |
P | copy, indicator, left_index, right_index, validate | |
Y | ||
Y | ||
Y | ||
P | precision, retbins | |
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 | |
P | auth_local_webserver, credentials, dialect, location, progress_bar_type, project_id, query, reauth, use_bqstorage_api | |
P | chunksize, compression, convert_axes, convert_dates, date_unit, dtype_backend, encoding_errors, keep_default_dates, nrows, precise_float, storage_options, typ | |
P | columns, dtype_backend, filesystem, filters, kwargs, storage_options, use_nullable_dtypes | |
Y | ||
P | cache, dayfirst, errors, exact, infer_datetime_format, origin, yearfirst |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
P | copy | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | name | |
Y | ||
P | key | |
Y | ||
Y | ||
P | copy, data, dtype, fastpath, index, name | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, fill_value, level | |
Y | ||
Y | ||
P | args, axis, kwargs | |
P | args, axis, kwargs | |
P | axis, bool_only, kwargs, skipna | |
P | axis, bool_only, kwargs, skipna | |
P | args, convert_dtype, kwargs | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | copy, errors | |
Y | ||
Y | ||
Y | ||
P | axis, downcast, inplace, limit_area | |
P | axis, inplace, kwargs | |
Y | ||
P | deep | |
Y | ||
Y | ||
P | ddof, min_periods | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
Y | ||
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
Y | ||
P | errors, inplace | |
P | ignore_index, inplace | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, fill_value, level | |
Y | ||
P | axis, method | |
Y | ||
P | axis, downcast, inplace, limit_area | |
P | axis, downcast, inplace, limit, method | |
Y | ||
P | axis, fill_value, level | |
P | axis, fill_value, level | |
Y | ||
P | group_keys, observed, sort | |
P | axis, fill_value, level | |
Y | ||
Y | ||
Y | ||
P | args, axis, kwargs, skipna | |
P | args, axis, kwargs, skipna | |
Y | ||
Y | ||
P | axis, downcast, inplace, kwargs, limit, limit_area, limit_direction | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, kwargs, numeric_only, skipna | |
P | axis, kwargs, numeric_only, skipna | |
P | axis, fill_value, level | |
Y | ||
P | axis, fill_value, level | |
Y | ||
P | axis, inplace, level | |
P | axis, kwargs, numeric_only, skipna | |
P | axis, kwargs, numeric_only, skipna | |
P | axis, kwargs, numeric_only, skipna | |
P | axis, kwargs, numeric_only, skipna | |
P | axis, fill_value, level | |
P | dropna | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
Y | ||
Y | ||
P | axis, fill_value, level | |
Y | ||
Y | ||
Y | ||
Y | ||
P | dropna | |
P | axis, downcast, inplace | |
P | fill_method, freq, kwargs, limit | |
Y | ||
Y | ||
P | axis, fill_value, level | |
P | axis, kwargs, min_count, numeric_only, skipna | |
P | axis, kwargs, min_count, numeric_only, skipna | |
P | interpolation | |
P | axis, fill_value, level | |
P | pct | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, copy, fill_value, level, limit, method, tolerance | |
P | copy, limit, method, tolerance | |
P | axis, copy, errors, inplace, level | |
P | axis, copy, index, inplace | |
Y | ||
P | inplace, limit, method | |
P | allow_duplicates, inplace, level | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, center, closed, method, on, step, win_type | |
P | args, kwargs | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, ignore_index, replace, weights | |
Y | ||
P | axis, fill_value, freq, suffix | |
Y | ||
P | axis, kwargs, numeric_only, skipna | |
P | ignore_index, inplace, key, kind, level, sort_remaining | |
P | ignore_index, inplace, key | |
P | axis, ddof, kwargs, numeric_only, skipna | |
Y | ||
Y | ||
P | axis, fill_value, level | |
P | axis, fill_value, level | |
P | axis, kwargs, min_count, numeric_only, skipna | |
P | copy | |
Y | ||
P | chunksize, columns, compression, date_format, decimal, doublequote, encoding, errors, escapechar, float_format, index_label, lineterminator, mode, na_rep, quotechar, quoting, storage_options | |
Y | ||
P | columns, engine, engine_kwargs, float_format, freeze_panes, header, index, index_label, inf_rep, merge_cells, na_rep, startcol, startrow, storage_options | |
Y | ||
P | compression, date_format, date_unit, default_handler, double_precision, force_ascii, indent, mode, storage_options | |
P | bold_rows, caption, column_format, decimal, encoding, escape, float_format, formatters, index_names, label, longtable, multicolumn, multicolumn_format, multirow, na_rep, position, sparsify | |
Y | ||
P | storage_options | |
Y | ||
P | compression, protocol, storage_options | |
Y | ||
Y | ||
P | args, kwargs | |
P | axis, fill_value, level | |
Y | ||
P | fill_value, sort | |
Y | ||
P | bins | |
Y | ||
P | axis, ddof, kwargs, numeric_only, skipna | |
P | axis, inplace, level |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | orig | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | cls, data | |
Y | ||
Y | ||
Y | ||
P | key | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | args, kwargs | |
Y | ||
Y | ||
Y | ||
P | args, kwargs | |
Y | ||
Y | ||
P | args, kwargs | |
Y | ||
Y | ||
Y | ||
Y |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | key | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | na_rep, sep | |
Y | ||
P | na | |
P | na | |
P | expand | |
Y | ||
P | na | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | to_strip | |
P | na | |
Y | ||
Y | ||
P | n | |
Y | ||
P | to_strip | |
P | step | |
P | na | |
P | to_strip | |
Y | ||
Y |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, exclusions, group_keys, grouper, keys, level, obj, observed, selection, sort | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | args, engine, engine_kwargs | |
P | args, engine, engine_kwargs | |
P | skipna | |
P | skipna | |
Y | ||
Y | ||
P | axis | |
P | axis | |
P | axis | |
P | axis | |
P | axis | |
P | args, kwargs | |
P | engine, engine_kwargs, min_count | |
P | engine, engine_kwargs | |
Y | ||
P | engine, engine_kwargs, min_count | |
P | dropna | |
Y | ||
P | interpolation | |
P | args, kwargs | |
P | axis, fill_value, freq, suffix | |
P | axis, kwargs, skipna | |
P | ddof, engine, engine_kwargs | |
P | engine, engine_kwargs, min_count | |
P | ddof, engine, engine_kwargs |
API | Implemented | Missing parameters |
---|---|---|
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | axis, center, closed, method, min_periods, obj, on, selection, step, win_type, window | |
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
Y | ||
P | numeric_only | |
P | args, engine, engine_kwargs, kwargs, numeric_only | |
P | engine, engine_kwargs, numeric_only | |
P | engine, engine_kwargs, numeric_only | |
P | ddof, engine, engine_kwargs, numeric_only | |
P | engine, engine_kwargs, numeric_only | |
P | ddof, engine, engine_kwargs, numeric_only |