Skip to main content
Back to top
Ctrl
+
K
BigQuery DataFrames (BigFrames)
User Guide
API Reference
Supported pandas APIs
Changelog
Search
Ctrl
+
K
System Settings
Light
Dark
GitHub
Search
Ctrl
+
K
User Guide
API Reference
Supported pandas APIs
Changelog
System Settings
Light
Dark
GitHub
Collapse Sidebar
Expand Sidebar
Section Navigation
bigframes._config
bigframes._config.BigQueryOptions
bigframes._config.ComputeOptions
bigframes._config.DisplayOptions
bigframes._config.ExperimentOptions
bigframes._config.Options
bigframes._config.SamplingOptions
bigframes._config.option_context
bigframes.bigquery
bigframes.bigquery.approx_top_count
bigframes.bigquery.array_agg
bigframes.bigquery.array_concat
bigframes.bigquery.array_first
bigframes.bigquery.array_first_n
bigframes.bigquery.array_includes
bigframes.bigquery.array_includes_all
bigframes.bigquery.array_includes_any
bigframes.bigquery.array_is_distinct
bigframes.bigquery.array_last
bigframes.bigquery.array_length
bigframes.bigquery.array_reverse
bigframes.bigquery.array_slice
bigframes.bigquery.array_to_string
bigframes.bigquery.bit_count
bigframes.bigquery.bool_
bigframes.bigquery.create_external_table
bigframes.bigquery.create_vector_index
bigframes.bigquery.current_date
bigframes.bigquery.date
bigframes.bigquery.date_add
bigframes.bigquery.date_diff
bigframes.bigquery.date_from_unix_date
bigframes.bigquery.date_sub
bigframes.bigquery.date_trunc
bigframes.bigquery.deterministic_decrypt_bytes
bigframes.bigquery.deterministic_decrypt_string
bigframes.bigquery.deterministic_encrypt
bigframes.bigquery.double
bigframes.bigquery.flatten
bigframes.bigquery.float64
bigframes.bigquery.format_date
bigframes.bigquery.generate_array
bigframes.bigquery.hparam_candidates
bigframes.bigquery.hparam_range
bigframes.bigquery.int64
bigframes.bigquery.json_extract
bigframes.bigquery.json_extract_array
bigframes.bigquery.json_extract_string_array
bigframes.bigquery.json_keys
bigframes.bigquery.json_query
bigframes.bigquery.json_query_array
bigframes.bigquery.json_set
bigframes.bigquery.json_value
bigframes.bigquery.json_value_array
bigframes.bigquery.last_day
bigframes.bigquery.load_data
bigframes.bigquery.parse_bignumeric
bigframes.bigquery.parse_date
bigframes.bigquery.parse_json
bigframes.bigquery.parse_numeric
bigframes.bigquery.rand
bigframes.bigquery.sql_scalar
bigframes.bigquery.st_area
bigframes.bigquery.st_buffer
bigframes.bigquery.st_centroid
bigframes.bigquery.st_convexhull
bigframes.bigquery.st_difference
bigframes.bigquery.st_distance
bigframes.bigquery.st_intersection
bigframes.bigquery.st_isclosed
bigframes.bigquery.st_length
bigframes.bigquery.st_regionstats
bigframes.bigquery.st_simplify
bigframes.bigquery.string
bigframes.bigquery.struct
bigframes.bigquery.to_json
bigframes.bigquery.to_json_string
bigframes.bigquery.unix_date
bigframes.bigquery.unix_micros
bigframes.bigquery.unix_millis
bigframes.bigquery.unix_seconds
bigframes.bigquery.vector_search
bigframes.bigquery.aead
bigframes.bigquery.aead.decrypt_bytes
bigframes.bigquery.aead.decrypt_string
bigframes.bigquery.aead.encrypt
bigframes.bigquery.ai
bigframes.bigquery.ai.classify
bigframes.bigquery.ai.embed
bigframes.bigquery.ai.forecast
bigframes.bigquery.ai.generate
bigframes.bigquery.ai.generate_bool
bigframes.bigquery.ai.generate_double
bigframes.bigquery.ai.generate_embedding
bigframes.bigquery.ai.generate_int
bigframes.bigquery.ai.generate_table
bigframes.bigquery.ai.generate_text
bigframes.bigquery.ai.if_
bigframes.bigquery.ai.predict
bigframes.bigquery.ai.score
bigframes.bigquery.ai.similarity
bigframes.bigquery.ml
bigframes.bigquery.ml.create_model
bigframes.bigquery.ml.evaluate
bigframes.bigquery.ml.explain_predict
bigframes.bigquery.ml.forecast
bigframes.bigquery.ml.generate_embedding
bigframes.bigquery.ml.generate_text
bigframes.bigquery.ml.get_insights
bigframes.bigquery.ml.global_explain
bigframes.bigquery.ml.predict
bigframes.bigquery.ml.recommend
bigframes.bigquery.ml.transform
bigframes.bigquery.obj
bigframes.bigquery.obj.fetch_metadata
bigframes.bigquery.obj.get_access_url
bigframes.bigquery.obj.make_ref
bigframes.enums
bigframes.enums.DefaultIndexKind
bigframes.enums.OrderingMode
bigframes.exceptions
bigframes.exceptions.format_message
bigframes.exceptions.AmbiguousWindowWarning
bigframes.exceptions.ApiDeprecationWarning
bigframes.exceptions.BadIndexerKeyWarning
bigframes.exceptions.CleanupFailedWarning
bigframes.exceptions.DefaultIndexWarning
bigframes.exceptions.DefaultLocationWarning
bigframes.exceptions.FunctionAxisOnePreviewWarning
bigframes.exceptions.FunctionConflictTypeHintWarning
bigframes.exceptions.FunctionPackageVersionWarning
bigframes.exceptions.JSONDtypeWarning
bigframes.exceptions.MaximumResultRowsExceeded
bigframes.exceptions.NullIndexError
bigframes.exceptions.NullIndexPreviewWarning
bigframes.exceptions.ObsoleteVersionWarning
bigframes.exceptions.OperationAbortedError
bigframes.exceptions.OrderRequiredError
bigframes.exceptions.OrderingModePartialPreviewWarning
bigframes.exceptions.PreviewWarning
bigframes.exceptions.PythonTranspilerPreviewWarning
bigframes.exceptions.QueryComplexityError
bigframes.exceptions.TimeTravelCacheWarning
bigframes.exceptions.TimeTravelDisabledWarning
bigframes.exceptions.TranspilationError
bigframes.exceptions.UnknownDataTypeWarning
bigframes.exceptions.UnknownLocationWarning
bigframes.geopandas
bigframes.geopandas.GeoSeries
bigframes.geopandas.GeoSeries.area
bigframes.geopandas.GeoSeries.boundary
bigframes.geopandas.GeoSeries.centroid
bigframes.geopandas.GeoSeries.convex_hull
bigframes.geopandas.GeoSeries.is_closed
bigframes.geopandas.GeoSeries.length
bigframes.geopandas.GeoSeries.x
bigframes.geopandas.GeoSeries.y
bigframes.geopandas.GeoSeries.__init__
bigframes.geopandas.GeoSeries.buffer
bigframes.geopandas.GeoSeries.difference
bigframes.geopandas.GeoSeries.distance
bigframes.geopandas.GeoSeries.from_wkt
bigframes.geopandas.GeoSeries.from_xy
bigframes.geopandas.GeoSeries.intersection
bigframes.geopandas.GeoSeries.simplify
bigframes.geopandas.GeoSeries.to_wkt
bigframes.pandas
bigframes.pandas.clean_up_by_session_id
bigframes.pandas.close_session
bigframes.pandas.col
bigframes.pandas.concat
bigframes.pandas.crosstab
bigframes.pandas.cut
bigframes.pandas.deploy_remote_function
bigframes.pandas.deploy_udf
bigframes.pandas.get_default_session_id
bigframes.pandas.get_dummies
bigframes.pandas.get_global_session
bigframes.pandas.merge
bigframes.pandas.qcut
bigframes.pandas.read_arrow
bigframes.pandas.read_avro
bigframes.pandas.read_csv
bigframes.pandas.read_gbq
bigframes.pandas.read_gbq_function
bigframes.pandas.read_gbq_model
bigframes.pandas.read_gbq_query
bigframes.pandas.read_gbq_table
bigframes.pandas.read_json
bigframes.pandas.read_orc
bigframes.pandas.read_pandas
bigframes.pandas.read_parquet
bigframes.pandas.read_pickle
bigframes.pandas.remote_function
bigframes.pandas.reset_session
bigframes.pandas.to_datetime
bigframes.pandas.to_timedelta
bigframes.pandas.udf
bigframes.pandas.DataFrame
bigframes.pandas.DataFrame.T
bigframes.pandas.DataFrame.at
bigframes.pandas.DataFrame.axes
bigframes.pandas.DataFrame.bigquery
bigframes.pandas.DataFrame.bqclient
bigframes.pandas.DataFrame.columns
bigframes.pandas.DataFrame.dtypes
bigframes.pandas.DataFrame.empty
bigframes.pandas.DataFrame.iat
bigframes.pandas.DataFrame.iloc
bigframes.pandas.DataFrame.index
bigframes.pandas.DataFrame.loc
bigframes.pandas.DataFrame.ndim
bigframes.pandas.DataFrame.plot
bigframes.pandas.DataFrame.query_job
bigframes.pandas.DataFrame.shape
bigframes.pandas.DataFrame.size
bigframes.pandas.DataFrame.sql
bigframes.pandas.DataFrame.struct
bigframes.pandas.DataFrame.values
bigframes.pandas.DataFrame.__init__
bigframes.pandas.DataFrame.abs
bigframes.pandas.DataFrame.add
bigframes.pandas.DataFrame.add_prefix
bigframes.pandas.DataFrame.add_suffix
bigframes.pandas.DataFrame.agg
bigframes.pandas.DataFrame.aggregate
bigframes.pandas.DataFrame.align
bigframes.pandas.DataFrame.all
bigframes.pandas.DataFrame.any
bigframes.pandas.DataFrame.apply
bigframes.pandas.DataFrame.applymap
bigframes.pandas.DataFrame.area
bigframes.pandas.DataFrame.assign
bigframes.pandas.DataFrame.astype
bigframes.pandas.DataFrame.bar
bigframes.pandas.DataFrame.bfill
bigframes.pandas.DataFrame.cache
bigframes.pandas.DataFrame.combine
bigframes.pandas.DataFrame.combine_first
bigframes.pandas.DataFrame.copy
bigframes.pandas.DataFrame.corr
bigframes.pandas.DataFrame.corrwith
bigframes.pandas.DataFrame.count
bigframes.pandas.DataFrame.cov
bigframes.pandas.DataFrame.cummax
bigframes.pandas.DataFrame.cummin
bigframes.pandas.DataFrame.cumprod
bigframes.pandas.DataFrame.cumsum
bigframes.pandas.DataFrame.describe
bigframes.pandas.DataFrame.diff
bigframes.pandas.DataFrame.div
bigframes.pandas.DataFrame.divide
bigframes.pandas.DataFrame.dot
bigframes.pandas.DataFrame.drop
bigframes.pandas.DataFrame.drop_duplicates
bigframes.pandas.DataFrame.droplevel
bigframes.pandas.DataFrame.dropna
bigframes.pandas.DataFrame.duplicated
bigframes.pandas.DataFrame.eq
bigframes.pandas.DataFrame.equals
bigframes.pandas.DataFrame.eval
bigframes.pandas.DataFrame.expanding
bigframes.pandas.DataFrame.explode
bigframes.pandas.DataFrame.ffill
bigframes.pandas.DataFrame.fillna
bigframes.pandas.DataFrame.filter
bigframes.pandas.DataFrame.first_valid_index
bigframes.pandas.DataFrame.floordiv
bigframes.pandas.DataFrame.from_dict
bigframes.pandas.DataFrame.from_records
bigframes.pandas.DataFrame.ge
bigframes.pandas.DataFrame.get
bigframes.pandas.DataFrame.groupby
bigframes.pandas.DataFrame.gt
bigframes.pandas.DataFrame.head
bigframes.pandas.DataFrame.hist
bigframes.pandas.DataFrame.idxmax
bigframes.pandas.DataFrame.idxmin
bigframes.pandas.DataFrame.info
bigframes.pandas.DataFrame.insert
bigframes.pandas.DataFrame.interpolate
bigframes.pandas.DataFrame.isin
bigframes.pandas.DataFrame.isna
bigframes.pandas.DataFrame.isnull
bigframes.pandas.DataFrame.items
bigframes.pandas.DataFrame.iterrows
bigframes.pandas.DataFrame.itertuples
bigframes.pandas.DataFrame.join
bigframes.pandas.DataFrame.keys
bigframes.pandas.DataFrame.kurt
bigframes.pandas.DataFrame.kurtosis
bigframes.pandas.DataFrame.le
bigframes.pandas.DataFrame.line
bigframes.pandas.DataFrame.lt
bigframes.pandas.DataFrame.map
bigframes.pandas.DataFrame.mask
bigframes.pandas.DataFrame.max
bigframes.pandas.DataFrame.mean
bigframes.pandas.DataFrame.median
bigframes.pandas.DataFrame.melt
bigframes.pandas.DataFrame.memory_usage
bigframes.pandas.DataFrame.merge
bigframes.pandas.DataFrame.min
bigframes.pandas.DataFrame.mod
bigframes.pandas.DataFrame.mul
bigframes.pandas.DataFrame.multiply
bigframes.pandas.DataFrame.ne
bigframes.pandas.DataFrame.nlargest
bigframes.pandas.DataFrame.notna
bigframes.pandas.DataFrame.notnull
bigframes.pandas.DataFrame.nsmallest
bigframes.pandas.DataFrame.nunique
bigframes.pandas.DataFrame.pct_change
bigframes.pandas.DataFrame.peek
bigframes.pandas.DataFrame.pipe
bigframes.pandas.DataFrame.pivot
bigframes.pandas.DataFrame.pivot_table
bigframes.pandas.DataFrame.pow
bigframes.pandas.DataFrame.prod
bigframes.pandas.DataFrame.product
bigframes.pandas.DataFrame.quantile
bigframes.pandas.DataFrame.query
bigframes.pandas.DataFrame.radd
bigframes.pandas.DataFrame.rank
bigframes.pandas.DataFrame.rdiv
bigframes.pandas.DataFrame.reindex
bigframes.pandas.DataFrame.reindex_like
bigframes.pandas.DataFrame.rename
bigframes.pandas.DataFrame.rename_axis
bigframes.pandas.DataFrame.reorder_levels
bigframes.pandas.DataFrame.replace
bigframes.pandas.DataFrame.resample
bigframes.pandas.DataFrame.reset_index
bigframes.pandas.DataFrame.rfloordiv
bigframes.pandas.DataFrame.rmod
bigframes.pandas.DataFrame.rmul
bigframes.pandas.DataFrame.rolling
bigframes.pandas.DataFrame.round
bigframes.pandas.DataFrame.rpow
bigframes.pandas.DataFrame.rsub
bigframes.pandas.DataFrame.rtruediv
bigframes.pandas.DataFrame.sample
bigframes.pandas.DataFrame.scatter
bigframes.pandas.DataFrame.select_dtypes
bigframes.pandas.DataFrame.set_index
bigframes.pandas.DataFrame.shift
bigframes.pandas.DataFrame.skew
bigframes.pandas.DataFrame.sort_index
bigframes.pandas.DataFrame.sort_values
bigframes.pandas.DataFrame.stack
bigframes.pandas.DataFrame.std
bigframes.pandas.DataFrame.sub
bigframes.pandas.DataFrame.subtract
bigframes.pandas.DataFrame.sum
bigframes.pandas.DataFrame.swaplevel
bigframes.pandas.DataFrame.tail
bigframes.pandas.DataFrame.take
bigframes.pandas.DataFrame.to_arrow
bigframes.pandas.DataFrame.to_csv
bigframes.pandas.DataFrame.to_dict
bigframes.pandas.DataFrame.to_excel
bigframes.pandas.DataFrame.to_gbq
bigframes.pandas.DataFrame.to_html
bigframes.pandas.DataFrame.to_json
bigframes.pandas.DataFrame.to_latex
bigframes.pandas.DataFrame.to_markdown
bigframes.pandas.DataFrame.to_numpy
bigframes.pandas.DataFrame.to_orc
bigframes.pandas.DataFrame.to_pandas
bigframes.pandas.DataFrame.to_pandas_batches
bigframes.pandas.DataFrame.to_parquet
bigframes.pandas.DataFrame.to_pickle
bigframes.pandas.DataFrame.to_records
bigframes.pandas.DataFrame.to_string
bigframes.pandas.DataFrame.transpose
bigframes.pandas.DataFrame.truediv
bigframes.pandas.DataFrame.unstack
bigframes.pandas.DataFrame.update
bigframes.pandas.DataFrame.value_counts
bigframes.pandas.DataFrame.var
bigframes.pandas.DataFrame.where
bigframes.pandas.DatetimeIndex
bigframes.pandas.DatetimeIndex.day
bigframes.pandas.DatetimeIndex.day_of_week
bigframes.pandas.DatetimeIndex.dayofweek
bigframes.pandas.DatetimeIndex.month
bigframes.pandas.DatetimeIndex.weekday
bigframes.pandas.DatetimeIndex.year
bigframes.pandas.Index
bigframes.pandas.Index.T
bigframes.pandas.Index.dtype
bigframes.pandas.Index.dtypes
bigframes.pandas.Index.empty
bigframes.pandas.Index.has_duplicates
bigframes.pandas.Index.is_monotonic_decreasing
bigframes.pandas.Index.is_monotonic_increasing
bigframes.pandas.Index.is_unique
bigframes.pandas.Index.name
bigframes.pandas.Index.names
bigframes.pandas.Index.ndim
bigframes.pandas.Index.nlevels
bigframes.pandas.Index.query_job
bigframes.pandas.Index.shape
bigframes.pandas.Index.size
bigframes.pandas.Index.str
bigframes.pandas.Index.values
bigframes.pandas.Index.all
bigframes.pandas.Index.any
bigframes.pandas.Index.argmax
bigframes.pandas.Index.argmin
bigframes.pandas.Index.astype
bigframes.pandas.Index.copy
bigframes.pandas.Index.drop
bigframes.pandas.Index.drop_duplicates
bigframes.pandas.Index.dropna
bigframes.pandas.Index.fillna
bigframes.pandas.Index.from_frame
bigframes.pandas.Index.get_level_values
bigframes.pandas.Index.get_loc
bigframes.pandas.Index.isin
bigframes.pandas.Index.item
bigframes.pandas.Index.max
bigframes.pandas.Index.min
bigframes.pandas.Index.nunique
bigframes.pandas.Index.rename
bigframes.pandas.Index.sort_values
bigframes.pandas.Index.to_list
bigframes.pandas.Index.to_numpy
bigframes.pandas.Index.to_pandas
bigframes.pandas.Index.to_series
bigframes.pandas.Index.transpose
bigframes.pandas.Index.unique
bigframes.pandas.Index.value_counts
bigframes.pandas.MultiIndex
bigframes.pandas.MultiIndex.from_arrays
bigframes.pandas.MultiIndex.from_tuples
bigframes.pandas.NamedAgg
bigframes.pandas.NamedAgg.aggfunc
bigframes.pandas.NamedAgg.column
bigframes.pandas.Series
bigframes.pandas.Series.AlignedExprT
bigframes.pandas.Series.T
bigframes.pandas.Series.at
bigframes.pandas.Series.bigquery
bigframes.pandas.Series.dt
bigframes.pandas.Series.dtype
bigframes.pandas.Series.dtypes
bigframes.pandas.Series.empty
bigframes.pandas.Series.geo
bigframes.pandas.Series.hasnans
bigframes.pandas.Series.iat
bigframes.pandas.Series.iloc
bigframes.pandas.Series.index
bigframes.pandas.Series.is_monotonic_decreasing
bigframes.pandas.Series.is_monotonic_increasing
bigframes.pandas.Series.list
bigframes.pandas.Series.loc
bigframes.pandas.Series.name
bigframes.pandas.Series.ndim
bigframes.pandas.Series.plot
bigframes.pandas.Series.query_job
bigframes.pandas.Series.shape
bigframes.pandas.Series.size
bigframes.pandas.Series.sql
bigframes.pandas.Series.str
bigframes.pandas.Series.struct
bigframes.pandas.Series.values
bigframes.pandas.Series.__init__
bigframes.pandas.Series.abs
bigframes.pandas.Series.add
bigframes.pandas.Series.add_prefix
bigframes.pandas.Series.add_suffix
bigframes.pandas.Series.agg
bigframes.pandas.Series.aggregate
bigframes.pandas.Series.all
bigframes.pandas.Series.any
bigframes.pandas.Series.apply
bigframes.pandas.Series.area
bigframes.pandas.Series.argmax
bigframes.pandas.Series.argmin
bigframes.pandas.Series.astype
bigframes.pandas.Series.autocorr
bigframes.pandas.Series.bar
bigframes.pandas.Series.between
bigframes.pandas.Series.bfill
bigframes.pandas.Series.cache
bigframes.pandas.Series.case_when
bigframes.pandas.Series.clip
bigframes.pandas.Series.combine
bigframes.pandas.Series.combine_first
bigframes.pandas.Series.copy
bigframes.pandas.Series.corr
bigframes.pandas.Series.count
bigframes.pandas.Series.cov
bigframes.pandas.Series.cummax
bigframes.pandas.Series.cummin
bigframes.pandas.Series.cumprod
bigframes.pandas.Series.cumsum
bigframes.pandas.Series.describe
bigframes.pandas.Series.diff
bigframes.pandas.Series.div
bigframes.pandas.Series.divide
bigframes.pandas.Series.divmod
bigframes.pandas.Series.dot
bigframes.pandas.Series.drop