Final project - Group 30 (DS4A Colombia 2019)

Folder structure

• models: contain all reutilizable functions such as predictors and functions.
• Scripts : where we are going to store notebooks
• Output : plots, table and logbook of the project
• Input : All data sources

This is Leandro's first commit.

Database tables

Our database has the following tables:

• per: Personas (people.)
• viv: Viviendas (houses.)
• hog: Hogares (households.)
• mgn: Marco geográfico nacional (geographical data.)
• fall: Fallecidos (deceased people.)

Intermediate tables:

• departments: Departments and their codes. Taken from the DANE.
• municipalities: Municipalities and their codes. Taken from the DANE.
• edad_dict: A table that contains the translation of the codes for the ages that are in the per table.
• education_dict: A table that contains the translation of the codes for the education levels that are in the per table.
• marital_dict: A table that contains the translation of the codes for the marital status that is a column in the per table.
• sex_dict: A table that contains the translation of the codes for sex, which is a column in the per table.

The dictionary of variables (Census) can be downloaded here (scroll to the bottom of the page.)

GEIH tables

• geih2018_pob: The table of the Great Integrated Household Survey 2018 (dictionary of variables here)
• v_income_dist: A view that contains the data needed to compute the income distribution histogram.