User Guide
**********

.. include:: ../README.rst

.. toctree::
   :caption: Guides
   :maxdepth: 1

   Getting Started <https://docs.cloud.google.com/bigquery/docs/dataframes-quickstart>
   Cloud Docs User Guides <https://docs.cloud.google.com/bigquery/docs/bigquery-dataframes-introduction>

.. toctree::
   :caption: Getting Started
   :maxdepth: 1

   Quickstart Template <../notebooks/getting_started/bq_dataframes_template.ipynb>
   Getting Started <../notebooks/getting_started/getting_started_bq_dataframes.ipynb>
   Magics <../notebooks/getting_started/magics.ipynb>
   ML Fundamentals <../notebooks/getting_started/ml_fundamentals_bq_dataframes.ipynb>
   Pandas Extensions <../notebooks/getting_started/pandas_extensions.ipynb>

.. toctree::
   :caption: DataFrames
   :maxdepth: 1

   Anywidget Mode <../notebooks/dataframes/anywidget_mode.ipynb>
   Dataframe <../notebooks/dataframes/dataframe.ipynb>
   Index Col Null <../notebooks/dataframes/index_col_null.ipynb>
   Integrations <../notebooks/dataframes/integrations.ipynb>
   Pypi <../notebooks/dataframes/pypi.ipynb>

.. toctree::
   :caption: Data Types
   :maxdepth: 1

   Array <../notebooks/data_types/array.ipynb>
   Json <../notebooks/data_types/json.ipynb>
   Struct <../notebooks/data_types/struct.ipynb>
   Timedelta <../notebooks/data_types/timedelta.ipynb>

.. toctree::
   :caption: Generative AI
   :maxdepth: 1

   AI Functions <../notebooks/generative_ai/ai_functions.ipynb>
   AI Functions for Poster Analysis <../notebooks/generative_ai/ai_movie_poster.ipynb>
   AI Forecast <../notebooks/generative_ai/bq_dataframes_ai_forecast.ipynb>
   LLM Code Generation <../notebooks/generative_ai/bq_dataframes_llm_code_generation.ipynb>
   LLM KMeans <../notebooks/generative_ai/bq_dataframes_llm_kmeans.ipynb>
   LLM Output Schema <../notebooks/generative_ai/bq_dataframes_llm_output_schema.ipynb>
   LLM Vector Search <../notebooks/generative_ai/bq_dataframes_llm_vector_search.ipynb>
   Drug Name Generation <../notebooks/generative_ai/bq_dataframes_ml_drug_name_generation.ipynb>
   Large Language Models <../notebooks/generative_ai/large_language_models.ipynb>

.. toctree::
   :caption: Machine Learning
   :maxdepth: 1

   ML Cross Validation <../notebooks/ml/bq_dataframes_ml_cross_validation.ipynb>
   Linear Regression <../notebooks/ml/bq_dataframes_ml_linear_regression.ipynb>
   Linear Regression BBQ <../notebooks/ml/bq_dataframes_ml_linear_regression_bbq.ipynb>
   Linear Regression Big <../notebooks/ml/bq_dataframes_ml_linear_regression_big.ipynb>
   Easy Linear Regression <../notebooks/ml/easy_linear_regression.ipynb>
   Sklearn Linear Regression <../notebooks/ml/sklearn_linear_regression.ipynb>
   Timeseries Analysis <../notebooks/ml/timeseries_analysis.ipynb>

.. toctree::
   :caption: Visualization
   :maxdepth: 1

   COVID Line Graphs <../notebooks/visualization/bq_dataframes_covid_line_graphs.ipynb>
   Tutorial <../notebooks/visualization/tutorial.ipynb>

.. toctree::
   :caption: Geospatial Data
   :maxdepth: 1

   Geoseries <../notebooks/geo/geoseries.ipynb>

.. toctree::
   :caption: Regionalized BigQuery
   :maxdepth: 1

   Regionalized <../notebooks/location/regionalized.ipynb>

.. toctree::
   :caption: Multimodal
   :maxdepth: 1

   Multimodal Dataframe <../notebooks/multimodal/multimodal_dataframe.ipynb>

.. toctree::
   :caption: Remote Functions
   :maxdepth: 1

   Remote Function <../notebooks/remote_functions/remote_function.ipynb>
   Remote Function Usecases <../notebooks/remote_functions/remote_function_usecases.ipynb>
   Remote Function Vertex Claude Model <../notebooks/remote_functions/remote_function_vertex_claude_model.ipynb>

.. toctree::
   :caption: Streaming
   :maxdepth: 1

   Streaming Dataframe <../notebooks/streaming/streaming_dataframe.ipynb>

.. toctree::
   :caption: Experimental
   :maxdepth: 1

   AI Operators <../notebooks/experimental/ai_operators.ipynb>
   Semantic Operators <../notebooks/experimental/semantic_operators.ipynb>

.. toctree::
   :caption: Apps
   :maxdepth: 1

   Synthetic Data Generation <../notebooks/apps/synthetic_data_generation.ipynb>

.. toctree::
   :caption: Kaggle
   :maxdepth: 1

   AI Forecast <../notebooks/kaggle/bq_dataframes_ai_forecast.ipynb>
   Describe Product Images <../notebooks/kaggle/describe-product-images-with-bigframes-multimodal.ipynb>
   Vector Search Over National Jukebox <../notebooks/kaggle/vector-search-with-bigframes-over-national-jukebox.ipynb>
