项目作者: erikayi

项目描述 :
A small data team worked on building the ETL processes on hospital beds and Cities' health data.
高级语言: Jupyter Notebook
项目地址: git://github.com/erikayi/miniProject-1.5-ETL-Cities-Health-Data.git
创建时间: 2020-10-21T22:05:42Z
项目社区:https://github.com/erikayi/miniProject-1.5-ETL-Cities-Health-Data

开源协议:MIT License

下载


Extract, Transform, and Load the Data (ETL) Mini Project

Clean two different sources, and join those two datasets together.
Then, we load into the database to be able to run queries in the SQL database.

Compare and Contrast the two data about the relationship between diseases and hospital beds.

First Data Source : “Health Status Of 26 Of The Nation’s Largest And Most Urban Cities”

This dataset illustrates health status of 26 of the nation’s largest and most urban cities as captured by 34 health
(and six demographics-related) indicators. These indicators represent some of the leading causes of morbidity and mortality
in the United States and leading priorities of national, state, and local health agencies.
Public health data were captured in nine overarching categories: HIV/AIDS, cancer, nutrition/physical activity/obesity,
food safety, infectious disease, maternal and child health, tobacco, injury/violence, and behavioral health/substance abuse.

First Data Source : “Hospital Beds Per 1,000 Population By Ownership Type”

In this dataset, it discusses about staffed beds for community hospitals, which represent 85% of all hospitals in each states in the US.
Figures may not sum to totals due to rounding.