v1.40.0

1.40.0 (2025-03-11)

⚠ BREAKING CHANGES

• reading JSON data as a custom arrow extension type (#1458)

Features

• Reading JSON data as a custom arrow extension type (#1458) (e720f41)
• Support list output for managed function (#1457) (461e9e0)

Bug Fixes

• Fix list-like indexers in partial ordering mode (#1456) (fe72ada)
• Fix the merge issue between 1424 and 1373 (#1461) (7b6e361)
• Use == instead of is for timedelta type equality checks (#1480) (0db248b)

Performance Improvements

• Compilation no longer bounded by recursion (#1464) (27ab028)

v1.39.0

1.39.0 (2025-03-05)

Features

• (Preview) Support diff() for date series (#1423) (521e987)
• (Preview) Support aggregations over timedeltas (#1418) (1251ded)
• (Preview) Support arithmetics between dates and timedeltas (#1413) (962b152)
• (Preview) Support automatic load of timedelta from BQ tables. (#1429) (b2917bb)
• Add allow_large_results option to many I/O methods. Set to False to reduce latency (#1428) (dd2f488)
• Add GeoSeries.boundary() (#1435) (32cddfe)
• Add allow_large_results to peek (#1448) (67487b9)
• Add groupby.rank() (#1433) (3a633d5)
• Iloc multiple columns selection. (#1437) (ddfd02a)
• Support interface for BigQuery managed functions (#1373) (2bbf53f)
• Warn if default ingress_settings is used in remote_functions (#1419) (dfd891a)

Bug Fixes

• Do not compare schema description during schema validation (#1452) (03a3a56)
• Remove warnings for null index and partial ordering mode in prep for GA (#1431) (6785aee)
• Warn if default cloud_function_service_account is used in remote_function (#1424) (fe7463a)
• Window operations over JSON columns (#1451) (0070e77)
• Write chunked text instead of dummy text for pdf chunk (#1444) (96b0e8a)

Performance Improvements

• Speed up DataFrame corr, cov (#1309) (c598c0a)

Documentation

• Add snippet for explaining the linear regression model prediction (#1427) (7c37c7d)

v1.38.0

1.38.0 (2025-02-24)

Features

• (Preview) Support diff aggregation for timestamp series. (#1405) (abe48d6)
• Add GeoSeries.from_wkt() and GeoSeries.to_wkt() (#1401) (2993b28)
• Support DF.array(copy=True) (#1403) (693ed8c)
• Support routines with ARRAY return type in read_gbq_function (#1412) (4b60049)

Bug Fixes

• Calling to_timdelta() over timedeltas no longer changes their values (#1411) (650a190)
• Replace empty dict with None to avoid mutable default arguments (#1416) (fa4e3ad)

Performance Improvements

• Avoid redundant SQL casts (#1399) (6ee48d5)

Dependencies

• Remove scikit-learn and sqlalchemy as required dependencies (#1296) (fd8bc89)

Documentation

• Add samples using SQL methods via the bigframes.bigquery module (#1358) (f54e768)
• Add snippets for visualizing a time series and creating a time series model for the Limit forecasted values in time series model tutorial (#1310) (c6c9120)

v1.37.0

1.37.0 (2025-02-19)

Features

• JSON dtype support for read_pandas and Series constructor (#1391) (44f4137)
• Support add, sub, mult, div, and more between timedeltas (#1396) (ffa63d4)
• Support comparison, ordering, and filtering for timedeltas (#1387) (34d01b2)
• Support subtraction in DATETIME/TIMESTAMP columns with timedelta columns (#1390) (50ad3a5)

Bug Fixes

• Ensure binops with pandas objects returns bigquery dataframes (#1404) (3cee24b)

Performance Improvements

• Prune projections more aggressively (#1398) (7990262)
• Simplify sum aggregate SQL text (#1395) (0145656)
• Use simple null constraints to simplify queries (#1381) (00611d4)

Documentation

• Add DataFrame.struct docs (#1348) (7e9e93a)

v1.36.0

1.36.0 (2025-02-11)

Features

• Add bigframes.bigquery.st_area and suggest it from GeoSeries.area (#1318) (8b5ffa8)
• Add GeoSeries.from_xy() (#1364) (3c3e14c)

Bug Fixes

• Dtype parameter ineffective in Series/DataFrame construction (#1354) (b9bdca8)
• Translate labels to col ids when copying dataframes (#1372) (0c55b07)
• Fixed an AttributeError related to sqlglot that occurred when using bigframes (#1379)(24962cd)

Performance Improvements

• Prune unused operations from sql (#1365) (923da03)
• Simplify merge join key coalescing (#1361) (7ae565d)

v1.35.0

1.35.0 (2025-02-04)

Features

• Add Series.keys() (#1342) (deb015d)
• Allow case_when to change dtypes if case list contains the condition (True, some_default_value) (#1311) (5c2a2c6)
• Support python type as astype arg (#1316) (b26e135)
• Support time_series_id_col in ARIMAPlus (#1282) (97532c9)

Bug Fixes

• Exclude DataFrame and Series __call__ from unimplemented API metrics (#1351) (f2d5264)
• Make DataFrame __getattr__ and __setattr__ more robust to subclassing (#1352) (417de3a)

Performance Improvements

• Fall back to ordering by bq pk when possible (#1350) (3c4abf2)
• Improve isin performance (#1203) (db087b0)
• Prevent inlining of remote ops (#1347) (012081a)

Dependencies

• Add support for Python 3.13 for everything but remote functions (#1307) (533db96)

Documentation

• Add GeoSeries docs (#1327) (05f83d1)
• Add link to DataFrames intro to improve SEO (#1176) (aafb5be)
• Add snippet to explain the univariate model's forecast result in the Forecast a single time series with a univariate model tutorial (#1272) (c22126b)

v1.34.0

1.34.0 (2025-01-27)

⚠ BREAKING CHANGES

• Enable reading JSON data with dbjson extension dtype (#1139)

Features

• (df|s).hist(), (df|s).line(), (df|s).area(), (df|s).bar(), df.scatter() (#1320) (bd3f584)
• Add DataFrame.corrwith method (#1315) (b503355)
• Add DataFrame.mask method (#1302) (8b8155f)
• Enable reading JSON data with dbjson extension dtype (#1139) (f672262)

v1.33.0

1.33.0 (2025-01-22)

Features

• Add bigframes.bigquery.sql_scalar() to apply SQL syntax on Series objects (#1293) (aa2f73a)
• Add unix_seconds, unix_millis and unix_micros for timestamp series. (#1297) (e4b0c8d)
• DataFrame.join supports Series other (#1303) (ee37a0a)
• Support array output in remote_function (#1057) (bdee173)

Bug Fixes

• Dataframe sort_values Series input keyerror. (#1285) (5a2731b)
• Fix read_gbq_function issue in dataframe apply method (#1174) (0318764)
• Series sort_index and sort_values now raises when axis!=0 (#1294) (94bc2f2)

Documentation

• Add snippet to forecast future time series in the Forecast a single time series with a univariate model tutorial (#1271) (a687050)
• Update bigframes.pandas.Series docs (#1273) (0cac64f)

v1.32.0

1.32.0 (2025-01-13)

Features

• Add max_retries to TextEmbeddingGenerator and Claude3TextGenerator (#1259) (8077ff4)
• Bigframes.bigquery.parse_json (#1265) (27bbd80)
• Support DataFrame.astype(dict) (#1262) (5934f8e)

Bug Fixes

• Avoid global mutation in BigQueryOptions.client_endpoints_override (#1280) (788f6e9)
• Fix erroneous window bounds removal during compilation (#1163) (f91756a)

Dependencies

• Relax sqlglot upper bound (#1278) (c71ec09)

Documentation

• Add bq studio links that allows users to generate Jupiter notebooks in bq studio with github contents (#1266) (58f13cb)
• Add snippet to evaluate ARIMA plus model in the Forecast a single time series with a univariate model tutorial (#1267) (3dcae2d)
• Add snippet to see the ARIMA coefficients in the Forecast a single time series with a univariate model tutorial (#1268) (059a564)
• Update bigframes.pandas.pandas docstrings (#1247) (c4bffc3)
• Use 002 model for better scalability in text generation (#1270) (bb7a850)

v1.31.0

1.31.0 (2025-01-05)

Features

• Implement confirmation threshold for semantic operators (#1251) (5ba4511)

Bug Fixes

• Raise if trying to change ordering_mode after session has started (#1252) (8cfaae8)
• Reduce the number of labels added to query jobs (#1245) (fdcdc18)

Documentation

• Remove bq studio link (#1258) (dd4fd2e)
• Update bigframes.pandas.DatetimeMethods docstrings (#1246) (10f08da)
• Update semantic_operators.ipynb (#1260) (a2ed989)