menu
arrow_back

Analyzing Natality Data Using AI Platform and BigQuery

Analyzing Natality Data Using AI Platform and BigQuery

30 minutes 7 Credits

GSP012

Google Cloud Self-Paced Labs

Overview

In this lab, you analyze a large (137 million rows) natality dataset using Google BigQuery and AI Platform.

What you learn

In this lab, you:

  • Launch AI Platform notebook
  • Invoke a BigQuery query
  • Create charts in Jupyter
  • Export data for machine learning

This lab illustrates how you can carry out data exploration of large datasets, but continue to use familiar tools like Pandas and Jupyter. The trick is to do the first part of your aggregation in BigQuery, get back a Pandas DataFrame, then work with the smaller Pandas DataFrame locally. AI Platform provides a managed Jupyter experience, so you don't need to run notebook servers yourself.

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Google Cloud Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab
Score

—/100

Invoke bigquery and run a query.

Run Step

/ 20

Create AI Platform Notebooks instance.

Run Step

/ 20

Run a query to get annual count of plural births by plurality

Run Step

/ 20

Run a query to get baby weight by gender

Run Step

/ 20

Run a query to get the weight of the baby which relates to the number of weeks of gestation.

Run Step

/ 20