-
- flask installed
- pandas installed
- This is answered by localhost:///population/most
- This is answered by localhost:///immigrants/country/most
-
- Command: python load_pop_data.py
- Command: python load_immigrant_data
-
- Command: python server.py
-
Data of Q4 2023 per province from Statistics Canada Source : https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000901&cubeTimeFrame.startMonth=10&cubeTimeFrame.startYear=2023&cubeTimeFrame.endMonth=10&cubeTimeFrame.endYear=2023&referencePeriods=20231001%2C20231001
-
Data of 2021 Alberta Population from Statistics Canada Source : https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/prof/details/page.cfm?LANG=E&GENDERlist=1&STATISTIClist=1&DGUIDlist=2021A000248&HEADERlist=25&SearchText=Alberta
-
Modified immigrants_alberta.csv (by continent)
-
Modified immigrants_alberta.csv (by country)
-
The 'load_data.py' loads the 'population.csv' into the SQLite Database
-
The 'load_immigrants_data.py' loads the different immigrant data into the SQLite Database
-
Contains the backend (API)
-
Data of Q4 2023 per province from Statistics Canada Source : https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000901&cubeTimeFrame.startMonth=10&cubeTimeFrame.startYear=2023&cubeTimeFrame.endMonth=10&cubeTimeFrame.endYear=2023&referencePeriods=20231001%2C20231001
-
The data used for -immigrants.csv_ is from the link below. The data was cleaned in order to be loeaded properly to the DB. The data used for immigrants_alberta_continent.csv and immigrants_alberta_country.csv is derived from immigrants.csv
Data of 2021 Alberta Population from Statistics Canada Source : https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/prof/details/page.cfm?LANG=E&GENDERlist=1&STATISTIClist=1&DGUIDlist=2021A000248&HEADERlist=25&SearchText=Alberta