Skip to content

World Indicators from Google BigQuery Postgres | ETL Project

License

Notifications You must be signed in to change notification settings

BryanSouza91/world-indicators-etl

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

World Indicators

In this project I used Open Data available from Google's BigQuery Public Database to create a Postgres Database. The goal was to link the datasets by Country which would make for quick analyses. The datasets were quite dense which became an issue for simple relational indices to be created, this led me to realize I was on the path to building a data lake, which was out of scope.

Getting Started

This project consists mainly of Jupyter notebooks with a Postgres Database. Run Extract.ipynb first then Load.ipynb

Prerequisites

pip install pandas

Authors

License

This project is licensed under the MIT License - see the LICENSE file for details

About

World Indicators from Google BigQuery Postgres | ETL Project

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published