Google launches BigQuery Data Frames
<p>Google just announced BigQuery DataFrames — the feature is now in preview. BigQuery DataFrames is a Python API that you can use to analyze data and perform machine learning tasks in BigQuery[1].</p>
<p>BigQuery DataFrames combines Data Analysis and Data Science capabilities by giving you the following options[1]:</p>
<ul>
<li><code><em>bigframes.pandas</em></code><em> implements a DataFrame API (with partial Pandas compatibility) on top of BigQuery.</em></li>
<li><code><em>bigframes.ml</em></code><em> implements a Python API for BigQuery ML (with partial scikit-learn compatibility).</em></li>
</ul>
<p>DataFrames is an open-source package that you can run <code>pip install --upgrade bigframes</code> to install the latest version — here a small blue print on how to use it[2]:</p>
<pre>
import bigframes.pandas as bpd
bpd.options.bigquery.project = your_gcp_project_id
df1 = bpd.read_gbq("project.dataset.table")
df2 = bpd.read_gbq("SELECT a, b, c, FROM `project.dataset.table`")</pre>
<p>So this is again quite good news if you are working with Google Cloud and BigQuery in the enterprise but also want to do more with Python and run Data Science and Machine Learning task without any more unnecessary interfaces. Alternatively, Google also offers BigQuery ML, an alternative for ML via SQL. If you want to get started with BigQuery DataFrames Google also provides a BigQuery DataFrames quickstart.</p>
<p><a href="https://medium.com/codex/google-launches-bigquery-data-frames-762ae20ff1d0">Visit Now</a></p>