v2.20.0

2.20.0 (2025-09-16)

Features

• Add __dataframe__ interchange support (#2063) (3b46a0d)
• Add ai_generate_bool to the bigframes.bigquery package (#2060) (70d6562)
• Add bigframes.bigquery.to_json_string (#2076) (41e8f33)
• Add rank(pct=True) support (#2084) (c1e871d)
• Add StreamingDataFrame.to_bigtable and .to_pubsub start_timestamp parameter (#2066) (a63cbae)
• Can call agg with some callables (#2055) (17a1ed9)
• Support astype to json (#2073) (6bd6738)
• Support pandas.Index as key for DataFrame.setitem() (#2062) (b3cf824)
• Support pd.cut() for array-like type (#2064) (21eb213)
• Support to cast struct to json (#2067) (b0ff718)

Bug Fixes

• Deflake ai_gen_bool multimodel test (#2085) (566a37a)
• Do not scroll page selector in anywidget repr_mode (#2082) (5ce5d63)
• Fix the potential invalid VPC egress configuration (#2068) (cce4966)
• Return a DataFrame containing query stats for all non-SELECT statements (#2071) (a52b913)
• Use the remote and managed functions for bigframes results (#2079) (49b91e8)

Performance Improvements

• Avoid re-authenticating if credentials have already been fetched (#2058) (913de1b)
• Improve apply axis=1 performance (#2077) (12e4380)

v2.19.0

2.19.0 (2025-09-09)

Features

• Add str.join method (#2054) (8804ada)
• Support display.max_colwidth option (#2053) (5229e07)
• Support VPC egress setting in remote function (#2059) (5df779d)

Bug Fixes

• Fix issue mishandling chunked array while loading data (#2051) (873d0ee)
• Remove warning for slot_millis_sum (#2047) (425a691)

v2.18.0

2.18.0 (2025-09-03)

⚠ BREAKING CHANGES

• add allow_large_results option to read_gbq_query, aligning with bpd.options.compute.allow_large_results option (#1935)

Features

• Add allow_large_results option to read_gbq_query, aligning with bpd.options.compute.allow_large_results option (#1935) (a7963fe)
• Add parameter shuffle for ml.model_selection.train_test_split (#2030) (2c72c56)
• Can pivot unordered, unindexed dataframe (#2040) (1a0f710)
• Local date accessor execution support (#2034) (7ac6fe1)
• Support args in dataframe apply method (#2026) (164c481)
• Support args in series apply method (#2013) (d9d725c)
• Support callable for dataframe mask method (#2020) (9d4504b)
• Support multi-column assignment for DataFrame (#2028) (ba0d23b)
• Support string matching in local executor (#2032) (c0b54f0)

Bug Fixes

• Fix scalar op lowering tree walk (#2029) (935af10)
• Read_csv fails when check file size for wildcard gcs files (#2019) (b0d620b)
• Resolve the validation issue for other arg in dataframe where method (#2042) (8689199)

Performance Improvements

• Improve axis=1 aggregation performance (#2036) (fbb2094)
• Improve iter_nodes_topo performance using Kahn's algorithm (#2038) (3961637)

v2.17.0

2.17.0 (2025-08-22)

Features

• Add isin local execution impl (#1993) (26df6e6)
• Add reset_index names, col_level, col_fill, allow_duplicates args (#2017) (c02a1b6)
• Support callable for series mask method (#2014) (5ac32eb)

v2.16.0

2.16.0 (2025-08-20)

Features

• Add bigframes.pandas.options.display.precision option (#1979) (15e6175)
• Add level, inplace params to reset_index (#1988) (3446950)
• Add ML code samples from dbt blog post (#1978) (ebaa244)
• Add where, coalesce, fillna, casewhen, invert local impl (#1976) (f7f686c)
• Adjust anywidget CSS to prevent overflow (#1981) (204f083)
• Format page number in table widget (#1992) (e83836e)
• Or, And, Xor can execute locally (#1994) (59c52a5)
• Support callable bigframes function for dataframe where (#1990) (44c1ec4)
• Support callable for series where method (#2005) (768b82a)
• When using repr_mode = "anywidget", numeric values align right (15e6175)

Bug Fixes

• Address the packages issue for bigframes function (#1991) (68f1d22)
• Correct pypdf dependency specifier for remote PDF functions (#1980) (0bd5e1b)
• Enable default retries in calls to BQ Storage Read API (#1985) (f25d7bd)
• Fix the copyright year in dbt sample files (#1996) (fad5722)

Performance Improvements

• Faster session startup by defering anon dataset fetch (#1982) (2720c4c)

Documentation

• Add examples of running bigframes in kaggle (#2002) (7d89d76)
• Remove preview warning from partial ordering mode sample notebook (#1986) (132e0ed)

v2.15.0

2.15.0 (2025-08-11)

Features

• Add st_buffer, st_centroid, and st_convexhull and their corresponding GeoSeries methods (#1963) (c4c7fa5)
• Add first, last support to GroupBy (#1969) (41dda88)
• Add value_counts to GroupBy classes (#1974) (82175a4)
• Allow callable as a conditional or replacement input in DataFrame.where (#1971) (a8d57d2)
• Can cast locally in hybrid engine (#1944) (d9bc4a5)
• Df.join lsuffix and rsuffix support (#1857) (26515c3)

Bug Fixes

• Add warnings for duplicated or conflicting type hints in bigfram… (#1956) (d38e42c)
• Make remote_function more robust when there are create_function retries (#1973) (cd954ac)
• Make ExecutionMetrics stats tracking more robust to missing stats (#1977) (feb3ff4)

Performance Improvements

• Remove an unnecessary extra dry_run query from read_gbq_table (#1972) (d17b711)

Documentation

• Divide BQ DataFrames quickstart code cell (#1975) (fedb8f2)

v2.14.0

2.14.0 (2025-08-05)

Features

• Dynamic table width for better display across devices (#1948) (a6d30ae) (a6d30ae)
• Retry AI/ML jobs that fail more often (#1965) (25bde9f)
• Support series input in managed function (#1920) (62a189f)

Bug Fixes

• Enhance type error messages for bigframes functions (#1958) (770918e)

Performance Improvements

• Use promote_offsets for consistent row number generation for index.get_loc (#1957) (c67a25a)

Documentation

• Add code snippet for storing dataframes to a CSV file (#1943) (a511e09)
• Add code snippet for storing dataframes to a CSV file (#1953) (a298a02)

v2.13.0

2.13.0 (2025-07-25)

Features

• _read_gbq_colab creates hybrid session (#1901) (31b17b0)
• Add CSS styling for TableWidget pagination interface (#1934) (5b232d7)
• Add row numbering local pushdown in hybrid execution (#1932) (92a2377)
• Implement Index.get_loc (#1921) (bbbcaf3)

Bug Fixes

• Add license header and correct issues in dbt sample (#1931) (ab01b0a)

Dependencies

• Replace google-cloud-iam with grpc-google-iam-v1 (#1864) (e5ff8f7)

v2.12.0

2.12.0 (2025-07-23)

Features

• Add code samples for dbt bigframes integration (#1898) (7e03252)
• Add isin local execution to hybrid engine (#1915) (c0cefd3)
• Add ml.metrics.mean_absolute_error method (#1910) (15b8449)
• Allow local arithmetic execution in hybrid engine (#1906) (ebdcd02)
• Provide day_of_year and day_of_week for dt accessor (#1911) (40e7638)
• Support params max_batching_rows, container_cpu, and container_memory for udf (#1897) (8baa912)
• Support typed pyarrow.Scalar in assignment (#1930) (cd28e12)

Bug Fixes

• Correct min field from max() to min() in remote function tests (#1917) (d5c54fc)
• Resolve location reset issue in bigquery options (#1914) (c15cb8a)
• Series.str.isdigit in unicode superscripts and fractions (#1924) (8d46c36)

Documentation

• Add code snippets for session and IO public docs (#1919) (6e01cbe)
• Add snippets for performance optimization doc (#1923) (4da309e)

v2.11.0

2.11.0 (2025-07-15)

Features

• Add __contains__ to Index, Series, DataFrame (#1899) (07222bf)
• Add thresh param for Dataframe.dropna (#1885) (1395a50)
• Add concat pushdown for hybrid engine (#1891) (813624d)
• Add pagination buttons (prev/next) to anywidget mode for DataFrames (#1841) (8eca767)
• Add total_rows property to pandas batches iterator (#1888) (e3f5e65)
• Hybrid engine local join support (#1900) (1aa7950)
• Support date data type for to_datetime() (#1902) (24050cb)
• Support bpd.Series(json_data, dtype="json") (#1882) (05cb7d0)

Bug Fixes

• Bpd.merge on common columns (#1905) (a1fa112)
• DataFrame string addition respects order (#1894) (52c8233)
• Show slot_millis_sum warning only when allow_large_results=False (#1892) (25efabc)
• Used query row count metadata instead of table metadata (#1893) (e1ebc53)