The job is to make an application presenting data of mortality published by EUROSTAT and GUS:

• https://stat.gov.pl/obszary-tematyczne/ludnosc/ludnosc/
• https://ec.europa.eu/eurostat/web/population-demography/demography-population-stock-balance/database?node_code=demomwk

Application should enable user to:

1. open GUS website in a separate browser in order to download data to specific location; default in application folder , subfolder data/;
2. open EUROSTAT website in a separate browser in order to download data to specific location; default in application folder , subfolder data/;
3. creating on demand RSQLite database with 2 tables GUS and EUROSTAT; process of data should be consistent with demo presented scripts
4. will contain graphical user interface to created database:

1. interface should unable making SQL queries 2. if query will be correct interactive table should be presented ( filtration, sort, change of shown result from 10 to 100 , every 10) 3. should enable exporting results to csv file in the name provided by user: 4. if result will be 3-columned in a: 1. timestamp 2. variable 3. value way it should be visualised as a ggplotly(ggplot(xxx,aes(x=timestamp,y=value,col=variable)) + geom_line()), where xxx is a table-result; 5. every visualization mentioned below should be generated in 2 types: 1. direct for certain period: default for 2020.01.01-2021.12.01 2. relative in which data for certain period will be divided by appropriate chosen period; default from period 2015.01.01 2019.12.31 3. appropriate dates should be imported for example textInput(); 4. direct and relative visualisation should be placed next to each other; 5.visualisations: 1.visualisation of polish data/GUS (tab:Mapa GUS) and international/EUROSTAT(tab: Mapa EU) in googleVis maps (on separated tabs): aggregated for chosen period and with all age categories and genders, but with voivodeships/EU countries; 2. visualisation of polish data/GUS (tab: Szeregi czasowe GUS) and international/EUROSTAT (tab: Szeregi czasowe EU) in a time series(on separate tabs), with plotly used: 1.GUS: 1. for chosen period; default whole data; 2.relative divided by average from period of to be comparison; default whole data; 3.for chosen age; default for all categories; 4.for chosen gender; default for both genders; 5.for chosen voivodeship; default aggregated for whole Poland 6.for chosen time granulation: week,month,year;default week; 2. EUROSTAT: 1. for chosen period; default whole data; 2. relative divided by average from period of to be comparison; default whole data; 3. for chosen gender; default for both genders; 4.for chosen country;default for Poland; 5. for chosen time granulation: week, year; default week Appropriate visualation parameters should be available to be chosen from drop-down list 6. on demand generating/compiling a html report (with use of certain Rmd), containing all generated graphs (result of last query + last maps + last graphs of time series);within report it is possible to change interactive visualisation - plotly with appropriate ggplot It should be resent in a 1 archive (for example: zip). Scripts should be launched with: > source("project.r")

Attachments:

project.docx