BigQuery AI Functions in Pandas

import pandas as pd <br /> <br /> dates = pd.date_range(“2025-01-01″, periods=14, freq=”D”) <br /> <br /> df = pd.DataFrame({ <br /> “date”: dates.tolist() * 2, <br /> “item_id”: [“item_1”] * 14 + [“item_2”] * 14, <br /> “sales”: [ <br /> 100, 105, 110, 115, 120, 125, 130, 135, 140, 145, 150, 155, 160, 165, <br /> 50, 52, 55, 58, 60, 62, 65, 68, 70, 72, 75, 78, 80, 85, <br /> ], <br /> }) <br /> <br /> df.sample(5) <br /> # date item_id sales <br /> # 15 2025-01-02 item_2 52 <br /> # 10 2025-01-11 item_1 150 <br /> # 24 2025-01-11 item_2 75 <br /> # 26 2025-01-13 item_2 80 <br /> # 7 2025-01-08 item_1 135