- 2.28.0 (latest)
- 2.27.0
- 2.26.0
- 2.25.0
- 2.24.0
- 2.23.0
- 2.22.0
- 2.21.0
- 2.20.0
- 2.19.0
- 2.18.0
- 2.17.0
- 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
- 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 |

