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)

v1.30.0

1.30.0 (2024-12-30)

Features

• Add GeoSeries.x and GeoSeries.y (#1126) (4c3548f)
• Add LinearRegression.predict_explain() to generate ML.EXPLAIN_PREDICT columns (#1190) (e13eca2)
• Add LogisticRegression.predict_explain() to generate ML.EXPLAIN_PREDICT columns (#1222) (bcbc732)
• Add write_engine parameter to read_FORMATNAME methods to control how data is written to BigQuery (#371) (ed47ef1)
• Add client side retry to GeminiTextGenerator (#1242) (8193abe)
• Add Gemini-pro-1.5 to GeminiTextGenerator Tuning and Support score() method in Gemini-pro-1.5 (#1208) (298fc73)
• Add support for LinearRegression.predict_explain and LogisticRegression.predict_explain parameter, top_k_features (#1228) (3068e19)
• Support dataframe where method (#1166) (71b4053)

Bug Fixes

• Arima model series input. (#1237) (f7d52d9)
• Json in struct destination type (#1187) (200c9bb)
• Throw an error message when setting is_row_processor=True to read a multi param function (#1160) (b2816a5)

Documentation

• Add an "open in BQ Studio" link to all BigFrames sample notebooks (#1223) (e0a8288)
• Add bq studio link for a new ipynb file called "bq_dataframes_template.ipynb" (#1239) (840aaff)
• Add example for logistic regression (#1240) (4d854fd)
• Add examples for ml PCA and SimpleImputer (#1236) (0d84459)
• Add KMeans example (#1234) (d87ab97)
• Add linear model example (#1235) (2c3e1fd)
• Add ml.model_selection examples (#1238) (50648e4)
• Add python snippet for "Create the time series model" section of the Forecast a single time series with a univariate model tutorial (#1227) (20f3190)

v1.29.0

1.29.0 (2024-12-12)

Features

• Add Gemini 2.0 preview text model support (#1209) (1021d57)

Documentation

• Add Gemini 2.0 text gen sample notebook (#1211) (9596b66)
• Update bigframes.pandas.index docs return types (#1191) (c63e7da)