1
Estimating costs of sleep apnea
2
Data
2.1
Population
2.1.1
Load data into R
2.1.2
Explore dataset
2.1.3
Load and modify multiple files
2.1.4
Included European countries
2.1.5
Europe total population in 2019
2.1.6
PLOT: Finland population 2019
2.1.7
PLOT: European countries population
2.2
IHME dataset
2.2.1
Load few datasets
2.2.2
Load all datasets
2.2.3
Summary
3
Database
3.1
Load datasets
3.1.1
Population dataset
3.1.2
IHME dataset
3.1.3
Calculator files
3.2
Moving data to duckdb
3.2.1
Transform to parquet
4
Explorative Data Analysis
4.1
IHME distinct values
4.1.1
measure_name
4.1.2
sex_name
4.1.3
age_name
4.1.4
metric_name
4.1.5
year
4.1.6
cause_name
4.1.7
Calculator datas
4.2
PLOT: Population in countries
4.3
PLOT: Finland population 2019
4.4
TABLE: Prevalences
4.5
TABLE: Incidences
4.6
TABLE: Deaths
4.7
TABLE: Prevalences per countries
5
Database for Calculator Shiny
5.1
Population datasets
5.2
Prevalences from ihme dataset
5.3
Mortalities from ihme
5.4
Add also base values
5.5
Table: prevalences and mortalities
5.6
OSA values from article (Excel)
5.7
Money index Excel
5.8
Save data to new database
5.8.1
duckdb
5.8.2
Parquet
6
Data for Visualizer Shiny
6.1
Calculating main dataset
6.1.1
Population
6.1.2
OSA rates
6.1.3
Condition Prevalences and PAF
6.2
Map data
6.3
Save and copy data
7
Validation
7.1
Population
7.2
Prevalences
8
Results without money correction
8.0.1
Table: cost per patient
8.1
Direct costs
8.1.1
Table: direct cost per patient
8.2
Direct non-healthcare costs
8.2.1
Table: direct non-healthcare cost
8.3
Productivity loss costs
8.3.1
Table: patient productivity cost
9
Interactive applications
9.1
Shiny: Map visualization
9.2
Shiny: Calculator
10
References
11
About
12
References
13
Testing output
13.1
testing
Sleep Revolution: Sleep Apnea Cost
9
Interactive applications
Here are links for the Shiny applications created
9.1
Shiny: Map visualization
URL:
https://janimiettinen.shinyapps.io/sleepapneacost/
9.2
Shiny: Calculator
URL:
https://janimiettinen.shinyapps.io/sleepapneacalculator/