Skip to contents

Create a gt table from a summarised population characteristics table.

Usage

tablePopulationCharacteristics(result)

Arguments

result

Output from summarisePopulationCharacteristics().

Value

A gt object with the summarised data.

Examples

# \donttest{
library(dplyr)
library(OmopSketch)

# Connect to a mock database
cdm <- mockOmopSketch()

# Run summarise clinical tables
summarisedPopulation <- summarisePopulationCharacteristics(
                       cdm = cdm,
                       studyPeriod = c("2010-01-01",NA),
                       sex = TRUE,
                       ageGroup = list("<=60" = c(0, 60), ">60" = c(61, Inf))
                       )
#> Warning: ! 1 casted column in og_011_1726698594 (cohort_set) as do not match expected
#>   column type:
#>  `cohort_definition_id` from numeric to integer
#> Warning: ! 1 column in og_011_1726698594 do not match expected column type:
#>  `cohort_definition_id` is numeric but expected integer
#> ! cohort columns will be reordered to match the expected order:
#>   cohort_definition_id, subject_id, cohort_start_date, and cohort_end_date.
#>  Building new trimmed cohort
#> Warning: ! 1 column in tmp_006_og_013_1726698595 do not match expected column type:
#>  `cohort_definition_id` is numeric but expected integer
#> Creating initial cohort
#> ! cohort columns will be reordered to match the expected order:
#>   cohort_definition_id, subject_id, cohort_start_date, and cohort_end_date.
#> ! cohort columns will be reordered to match the expected order:
#>   cohort_definition_id, subject_id, cohort_start_date, and cohort_end_date.
#>  Cohort trimmed
#>  adding demographics columns
#>  summarising data
#>  summariseCharacteristics finished!
#> ! The following column type were changed:
#>  variable_name: from integer to character
tablePopulationCharacteristics(summarisedPopulation)
#> ! Results have not been suppressed.
Variable name Variable level Estimate name Database name
mockOmopSketch
overall; overall
Number records - N 60
Number subjects - N 60
Cohort start date - min 2010-01-01
q25 2010-01-01
median 2010-01-01
q75 2014-08-22
max 2019-02-04
Cohort end date - min 2010-05-02
q25 2014-05-15
median 2017-06-25
q75 2019-04-21
max 2019-12-25
Age at start - Mean (SD) 35.48 (16.15)
min 10
q25 22
median 34
q75 51
max 63
Age at end - min 11
q25 25
median 39
q75 54
max 67
Sex Female N% 27 (45.00)
Male N% 33 (55.00)
Prior observation - Mean (SD) 3,015.30 (4,566.79)
min 0
q25 0
median 1,007
q75 3,875
max 17,878
Future observation - Mean (SD) 1,566.12 (1,067.60)
min 4
q25 624
median 1,543
q75 2,346
max 3,632
<=60; overall
Number records - N 58
Number subjects - N 58
Cohort start date - min 2010-01-01
q25 2010-01-01
median 2010-01-01
q75 2014-05-14
max 2019-02-04
Cohort end date - min 2010-05-02
q25 2014-04-27
median 2017-04-18
q75 2019-04-15
max 2019-12-25
Age at start - Mean (SD) 34.57 (15.64)
min 10
q25 21
median 33
q75 51
max 60
Age at end - min 11
q25 24
median 37
q75 54
max 67
Sex Female N% 26 (44.83)
Male N% 32 (55.17)
Prior observation - Mean (SD) 3,119.28 (4,610.57)
min 0
q25 0
median 1,058
q75 4,352
max 17,878
Future observation - Mean (SD) 1,594.69 (1,074.60)
min 4
q25 609
median 1,610
q75 2,382
max 3,632
>60; overall
Number records - N 2
Number subjects - N 2
Cohort start date - min 2015-06-19
q25 2016-01-09
median 2016-07-31
q75 2017-02-20
max 2017-09-12
Cohort end date - min 2017-08-09
q25 2018-02-07
median 2018-08-07
q75 2019-02-05
max 2019-08-06
Age at start - Mean (SD) 62.00 (1.41)
min 61
q25 62
median 62
q75 62
max 63
Age at end - min 63
q25 64
median 64
q75 64
max 65
Sex Female N% 1 (50.00)
Male N% 1 (50.00)
Prior observation - Mean (SD) 0.00 (0.00)
min 0
q25 0
median 0
q75 0
max 0
Future observation - Mean (SD) 737.50 (62.93)
min 693
q25 715
median 738
q75 760
max 782
overall; Female
Number records - N 27
Number subjects - N 27
Cohort start date - min 2010-01-01
q25 2010-01-01
median 2010-01-01
q75 2014-03-26
max 2018-06-05
Cohort end date - min 2010-07-28
q25 2015-03-15
median 2017-08-12
q75 2019-04-08
max 2019-12-12
Age at start - Mean (SD) 35.30 (17.30)
min 10
q25 18
median 37
q75 51
max 61
Age at end - min 11
q25 25
median 40
q75 56
max 64
Sex Female N% 27 (100.00)
Prior observation - Mean (SD) 3,556.52 (5,558.36)
min 0
q25 0
median 1,003
q75 4,134
max 17,878
Future observation - Mean (SD) 1,782.07 (1,125.64)
min 4
q25 946
median 1,748
q75 2,680
max 3,632
overall; Male
Number records - N 33
Number subjects - N 33
Cohort start date - min 2010-01-01
q25 2010-01-01
median 2010-01-01
q75 2014-10-14
max 2019-02-04
Cohort end date - min 2010-05-02
q25 2013-10-22
median 2016-05-04
q75 2019-06-06
max 2019-12-25
Age at start - Mean (SD) 35.64 (15.41)
min 12
q25 22
median 32
q75 51
max 63
Age at end - min 16
q25 24
median 36
q75 54
max 67
Sex Male N% 33 (100.00)
Prior observation - Mean (SD) 2,572.48 (3,591.75)
min 0
q25 0
median 1,105
q75 3,451
max 12,494
Future observation - Mean (SD) 1,389.42 (1,000.20)
min 68
q25 570
median 1,265
q75 2,132
max 3,579
<=60; Female
Number records - N 26
Number subjects - N 26
Cohort start date - min 2010-01-01
q25 2010-01-01
median 2010-01-01
q75 2013-12-03
max 2018-06-05
Cohort end date - min 2010-07-28
q25 2015-01-19
median 2017-09-25
q75 2019-04-12
max 2019-12-12
Age at start - Mean (SD) 34.31 (16.85)
min 10
q25 18
median 36
q75 51
max 60
Age at end - min 11
q25 25
median 40
q75 54
max 64
Sex Female N% 26 (100.00)
Prior observation - Mean (SD) 3,693.31 (5,621.90)
min 0
q25 0
median 1,007
q75 4,382
max 17,878
Future observation - Mean (SD) 1,820.54 (1,129.70)
min 4
q25 1,016
median 1,748
q75 2,714
max 3,632
<=60; Male
Number records - N 32
Number subjects - N 32
Cohort start date - min 2010-01-01
q25 2010-01-01
median 2010-01-01
q75 2014-09-28
max 2019-02-04
Cohort end date - min 2010-05-02
q25 2013-09-21
median 2016-04-03
q75 2019-04-24
max 2019-12-25
Age at start - Mean (SD) 34.78 (14.84)
min 12
q25 22
median 32
q75 50
max 58
Age at end - min 16
q25 24
median 36
q75 52
max 67
Sex Male N% 32 (100.00)
Prior observation - Mean (SD) 2,652.88 (3,618.93)
min 0
q25 0
median 1,150
q75 3,736
max 12,494
Future observation - Mean (SD) 1,411.19 (1,008.23)
min 68
q25 567
median 1,328
q75 2,154
max 3,579
>60; Female
Number records - N 1
Number subjects - N 1
Cohort start date - min 2015-06-19
q25 2015-06-19
median 2015-06-19
q75 2015-06-19
max 2015-06-19
Cohort end date - min 2017-08-09
q25 2017-08-09
median 2017-08-09
q75 2017-08-09
max 2017-08-09
Age at start - Mean (SD) -
min 61
q25 61
median 61
q75 61
max 61
Age at end - min 63
q25 63
median 63
q75 63
max 63
Sex Female N% 1 (100.00)
Prior observation - Mean (SD) -
min 0
q25 0
median 0
q75 0
max 0
Future observation - Mean (SD) -
min 782
q25 782
median 782
q75 782
max 782
>60; Male
Number records - N 1
Number subjects - N 1
Cohort start date - min 2017-09-12
q25 2017-09-12
median 2017-09-12
q75 2017-09-12
max 2017-09-12
Cohort end date - min 2019-08-06
q25 2019-08-06
median 2019-08-06
q75 2019-08-06
max 2019-08-06
Age at start - Mean (SD) -
min 63
q25 63
median 63
q75 63
max 63
Age at end - min 65
q25 65
median 65
q75 65
max 65
Sex Male N% 1 (100.00)
Prior observation - Mean (SD) -
min 0
q25 0
median 0
q75 0
max 0
Future observation - Mean (SD) -
min 693
q25 693
median 693
q75 693
max 693
PatientProfiles::mockDisconnect(cdm = cdm) # }