6. Sprint 2 | Consuming data from Census.gov API, cleansing data frame and loading it BigQuery (Google Cloud Platform)
Project Info
- Created by: Diego Oroza
- Project Data Pipeline
- Date 2022
- Category Programming / DB & SQL
Project Description
This is the second source for our project to build a data pipeline. This piece of code consumes Census.gov API, invokes and retrieves updated population figures that subsequently are processed and refined by using Pandas data frames.
Once the information is formatted, it is automatically pushed to our Cloud Data Base designed within Google Cloud Platform - Big Query.
Note: In order to access the Google Colab link below, you may need to use any Google account.