PKCT01

Summary Concentration Table

Preview
Try this using WebR

Code

lyt <- lyt_rows %>%
  analyze_vars_in_cols(
    vars = c("AVAL", "AVALCAT1", rep("AVAL", 8)),
    .stats = c("n", "n_blq", "mean", "sd", "cv", "geom_mean", "geom_cv", "median", "min", "max"),
    .formats = c(
      n = "xx.", n_blq = "xx.", mean = format_sigfig(3), sd = format_sigfig(3), cv = "xx.x", median = format_sigfig(3),
      geom_mean = format_sigfig(3), geom_cv = "xx.x", min = format_sigfig(3), max = format_sigfig(3)
    ),
    .labels = c(
      n = "n", n_blq = "Number\nof\nLTRs/BLQs", mean = "Mean", sd = "SD", cv = "CV (%) Mean",
      geom_mean = "Geometric Mean", geom_cv = "CV % Geometric Mean", median = "Median", min = "Minimum", max = "Maximum"
    ),
    na_str = "NE",
    .aligns = "decimal"
  )

result <- build_table(lyt, df = adpc_1, alt_counts_df = adsl) %>% prune_table()

# Decorating
main_title(result) <- "Summary of PK Concentrations by Nominal Time and Treatment: PK Evaluable"
subtitles(result) <- c(
  "Protocol: xxxxx",
  paste("Analyte: ", unique(adpc_1$PARAM)),
  paste("Treatment:", unique(adpc_1$ACTARM))
)
main_footer(result) <- "NE: Not Estimable"

result

Summary of PK Concentrations by Nominal Time and Treatment: PK Evaluable
Protocol: xxxxx
Analyte:  Plasma Drug X
Treatment: A: Drug X

——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
Treatment Group                            Number                                                                                                         
  Visit                                      of                                                                                                           
    Nominal Time (hr) / Timepoint    n    LTRs/BLQs    Mean       SD     CV (%) Mean   Geometric Mean   CV % Geometric Mean   Median    Minimum    Maximum
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
A: Drug X (N=134)                                                                                                                                         
  Day 1                                                                                                                                                   
    0 / Predose                     134      134       0        0            NE              NE                 NE             0         0          0     
    0.5 / 0.5H                      134        0      12.6      1.51        12.0          12.5                  12.2          12.6       9.72      15.6   
    1 / 1H                          134        0      16.2      1.63        10.0          16.1                  10.1          16.2      12.6       19.9   
    1.5 / 1.5H                      134        0      15.6      1.46         9.3          15.6                   9.3          15.5      12.3       19.0   
    2 / 2H                          134        0      13.4      1.35        10.1          13.4                  10.0          13.3      10.8       16.5   
    3 / 3H                          134        0       8.47     1.25        14.7           8.38                 15.0           8.40      5.88      10.9   
    4 / 4H                          134        0       4.79     1.02        21.2           4.69                 22.0           4.79      2.70       7.09  
    8 / 8H                          134        0       0.348    0.180       51.7           0.303                58.4           0.318     0.0760     0.866 
    12 / 12H                        134        0       0.0224   0.0189      84.6           0.0156              111.6           0.0170    0.00200    0.0830
  Day 2                                                                                                                                                   
    24 / 24H                        134      134       0        0            NE              NE                 NE             0         0          0     
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

NE: Not Estimable

Experimental use!

WebR is a tool allowing you to run R code in the web browser. Modify the code below and click run to see the results. Alternatively, copy the code and click here to open WebR in a new tab.

Preview
Try this using WebR

Code

lyt <- lyt_rows %>%
  analyze_vars_in_cols(
    vars = c("AVAL", "AVALCAT1", rep("AVAL", 8)),
    .stats = c("n", "n_blq", "mean", "sd", "cv", "geom_mean", "geom_cv", "median", "min", "max"),
    .formats = c(
      n = "xx.", n_blq = "xx.", mean = format_sigfig(3), sd = format_sigfig(3), cv = "xx.x", median = format_sigfig(3),
      geom_mean = format_sigfig(3), geom_cv = "xx.x", min = format_sigfig(3), max = format_sigfig(3)
    ),
    .labels = c(
      n = "n", n_blq = "Number\nof\nLTRs/BLQs", mean = "Mean", sd = "SD", cv = "CV (%) Mean",
      geom_mean = "Geometric Mean", geom_cv = "CV % Geometric Mean", median = "Median", min = "Minimum", max = "Maximum"
    ),
    imp_rule = "1/3",
    .aligns = "decimal"
  )

result <- build_table(lyt, df = adpc_1, alt_counts_df = adsl) %>% prune_table()

# Decorating
main_title(result) <- "Summary of PK Concentrations by Nominal Time and Treatment: PK Evaluable"
subtitles(result) <- c(
  "Protocol: xxxxx",
  paste("Analyte: ", unique(adpc_1$PARAM)),
  paste("Treatment:", unique(adpc_1$ACTARM))
)
main_footer(result) <- c("NE: Not Estimable", "ND: Not Derived")

result

Summary of PK Concentrations by Nominal Time and Treatment: PK Evaluable
Protocol: xxxxx
Analyte:  Plasma Drug X
Treatment: A: Drug X

——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
Treatment Group                            Number                                                                                                         
  Visit                                      of                                                                                                           
    Nominal Time (hr) / Timepoint    n    LTRs/BLQs    Mean       SD     CV (%) Mean   Geometric Mean   CV % Geometric Mean   Median    Minimum    Maximum
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
A: Drug X (N=134)                                                                                                                                         
  Day 1                                                                                                                                                   
    0 / Predose                     134      134        ND        ND         ND              NE                 ND             0           ND       0     
    0.5 / 0.5H                      134        0      12.6      1.51        12.0          12.5                  12.2          12.6       9.72      15.6   
    1 / 1H                          134        0      16.2      1.63        10.0          16.1                  10.1          16.2      12.6       19.9   
    1.5 / 1.5H                      134        0      15.6      1.46         9.3          15.6                   9.3          15.5      12.3       19.0   
    2 / 2H                          134        0      13.4      1.35        10.1          13.4                  10.0          13.3      10.8       16.5   
    3 / 3H                          134        0       8.47     1.25        14.7           8.38                 15.0           8.40      5.88      10.9   
    4 / 4H                          134        0       4.79     1.02        21.2           4.69                 22.0           4.79      2.70       7.09  
    8 / 8H                          134        0       0.348    0.180       51.7           0.303                58.4           0.318     0.0760     0.866 
    12 / 12H                        134        0       0.0224   0.0189      84.6           0.0156              111.6           0.0170    0.00200    0.0830
  Day 2                                                                                                                                                   
    24 / 24H                        134      134        ND        ND         ND              NE                 ND             0           ND       0     
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

NE: Not Estimable
ND: Not Derived

Experimental use!

WebR is a tool allowing you to run R code in the web browser. Modify the code below and click run to see the results. Alternatively, copy the code and click here to open WebR in a new tab.

Preview
Try this using WebR

Code

lyt <- lyt_rows %>%
  analyze_vars_in_cols(
    vars = c("AVAL", "AVALCAT1", rep("AVAL", 8)),
    .stats = c("n", "n_blq", "mean", "sd", "cv", "geom_mean", "geom_cv", "median", "min", "max"),
    .formats = c(
      n = "xx.", n_blq = "xx.", mean = format_sigfig(3), sd = format_sigfig(3), cv = "xx.x", median = format_sigfig(3),
      geom_mean = format_sigfig(3), geom_cv = "xx.x", min = format_sigfig(3), max = format_sigfig(3)
    ),
    .labels = c(
      n = "n", n_blq = "Number\nof\nLTRs/BLQs", mean = "Mean", sd = "SD", cv = "CV (%) Mean",
      geom_mean = "Geometric Mean", geom_cv = "CV % Geometric Mean", median = "Median", min = "Minimum", max = "Maximum"
    ),
    imp_rule = "1/2",
    .aligns = "decimal"
  )

result <- build_table(lyt, df = adpc_1, alt_counts_df = adsl) %>% prune_table()

# Decorate table
main_title(result) <- "Summary of PK Concentrations by Nominal Time and Treatment: PK Evaluable"
subtitles(result) <- c(
  "Protocol: xxxxx",
  paste("Analyte: ", unique(adpc_1$PARAM)),
  paste("Treatment:", unique(adpc_1$ACTARM))
)
main_footer(result) <- "ND: Not Derived"

result

Summary of PK Concentrations by Nominal Time and Treatment: PK Evaluable
Protocol: xxxxx
Analyte:  Plasma Drug X
Treatment: A: Drug X

——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
Treatment Group                            Number                                                                                                         
  Visit                                      of                                                                                                           
    Nominal Time (hr) / Timepoint    n    LTRs/BLQs    Mean       SD     CV (%) Mean   Geometric Mean   CV % Geometric Mean   Median    Minimum    Maximum
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
A: Drug X (N=134)                                                                                                                                         
  Day 1                                                                                                                                                   
    0 / Predose                     134      134        ND        ND         ND              ND                 ND              ND         ND       0     
    0.5 / 0.5H                      134        0      12.6      1.51        12.0          12.5                  12.2          12.6       9.72      15.6   
    1 / 1H                          134        0      16.2      1.63        10.0          16.1                  10.1          16.2      12.6       19.9   
    1.5 / 1.5H                      134        0      15.6      1.46         9.3          15.6                   9.3          15.5      12.3       19.0   
    2 / 2H                          134        0      13.4      1.35        10.1          13.4                  10.0          13.3      10.8       16.5   
    3 / 3H                          134        0       8.47     1.25        14.7           8.38                 15.0           8.40      5.88      10.9   
    4 / 4H                          134        0       4.79     1.02        21.2           4.69                 22.0           4.79      2.70       7.09  
    8 / 8H                          134        0       0.348    0.180       51.7           0.303                58.4           0.318     0.0760     0.866 
    12 / 12H                        134        0       0.0224   0.0189      84.6           0.0156              111.6           0.0170    0.00200    0.0830
  Day 2                                                                                                                                                   
    24 / 24H                        134      134        ND        ND         ND              ND                 ND              ND         ND       0     
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

ND: Not Derived

Experimental use!

WebR is a tool allowing you to run R code in the web browser. Modify the code below and click run to see the results. Alternatively, copy the code and click here to open WebR in a new tab.

Code

library(dplyr)
library(tern)

adsl <- random.cdisc.data::cadsl %>%
  filter(ACTARM == "A: Drug X")
adpc <- random.cdisc.data::cadpc %>%
  filter(ACTARM == "A: Drug X", PARAM == "Plasma Drug X")

# Setting up the data
adpc_1 <- adpc %>%
  mutate(
    NFRLT = as.factor(NFRLT),
    AVALCAT1 = as.factor(AVALCAT1),
    NOMTPT = as.factor(paste(NFRLT, "/", PCTPT))
  ) %>%
  select(NOMTPT, ACTARM, VISIT, AVAL, PARAM, AVALCAT1)

adpc_1$NOMTPT <- factor(
  adpc_1$NOMTPT,
  levels = levels(adpc_1$NOMTPT)[order(as.numeric(gsub(".*?([0-9\\.]+).*", "\\1", levels(adpc_1$NOMTPT))))]
)

# Row structure
lyt_rows <- basic_table() %>%
  split_rows_by(
    var = "ACTARM",
    split_fun = drop_split_levels,
    split_label = "Treatment Group",
    label_pos = "topleft"
  ) %>%
  add_rowcounts(alt_counts = TRUE) %>%
  split_rows_by(
    var = "VISIT",
    split_fun = drop_split_levels,
    split_label = "Visit",
    label_pos = "topleft"
  ) %>%
  split_rows_by(
    var = "NOMTPT",
    split_fun = drop_split_levels,
    split_label = "Nominal Time (hr) / Timepoint",
    label_pos = "topleft",
    child_labels = "hidden"
  )

Reproducibility

Timestamp

[1] "2024-11-02 18:19:32 UTC"

Session Info

─ Session info ───────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.4.1 (2024-06-14)
 os       Ubuntu 22.04.5 LTS
 system   x86_64, linux-gnu
 ui       X11
 language (EN)
 collate  en_US.UTF-8
 ctype    en_US.UTF-8
 tz       Etc/UTC
 date     2024-11-02
 pandoc   3.4 @ /usr/bin/ (via rmarkdown)

─ Packages ───────────────────────────────────────────────────────────────────
 package           * version     date (UTC) lib source
 backports           1.5.0       2024-05-23 [1] CRAN (R 4.4.1)
 brio                1.1.5       2024-04-24 [1] CRAN (R 4.4.1)
 broom               1.0.7       2024-09-26 [1] CRAN (R 4.4.1)
 checkmate           2.3.2       2024-07-29 [1] CRAN (R 4.4.1)
 cli                 3.6.3       2024-06-21 [1] CRAN (R 4.4.1)
 codetools           0.2-20      2024-03-31 [2] CRAN (R 4.4.1)
 colorspace          2.1-1       2024-07-26 [1] CRAN (R 4.4.1)
 digest              0.6.37      2024-08-19 [1] CRAN (R 4.4.1)
 dplyr             * 1.1.4       2023-11-17 [1] CRAN (R 4.4.1)
 evaluate            1.0.1       2024-10-10 [1] CRAN (R 4.4.1)
 fansi               1.0.6       2023-12-08 [1] CRAN (R 4.4.1)
 fastmap             1.2.0       2024-05-15 [1] CRAN (R 4.4.1)
 formatters        * 0.5.9.9003  2024-11-02 [1] git2r (https://github.com/insightsengineering/formatters.git@84e8c3e)
 generics            0.1.3       2022-07-05 [1] CRAN (R 4.4.1)
 ggplot2             3.5.1       2024-04-23 [1] CRAN (R 4.4.1)
 glue                1.8.0       2024-09-30 [1] CRAN (R 4.4.1)
 gtable              0.3.5       2024-04-22 [1] CRAN (R 4.4.1)
 htmltools           0.5.8.1     2024-04-04 [1] CRAN (R 4.4.1)
 htmlwidgets         1.6.4       2023-12-06 [1] CRAN (R 4.4.1)
 jsonlite            1.8.9       2024-09-20 [1] CRAN (R 4.4.1)
 knitr               1.48        2024-07-07 [1] CRAN (R 4.4.1)
 lattice             0.22-6      2024-03-20 [2] CRAN (R 4.4.1)
 lifecycle           1.0.4       2023-11-07 [1] CRAN (R 4.4.1)
 magrittr          * 2.0.3       2022-03-30 [1] CRAN (R 4.4.1)
 Matrix              1.7-0       2024-04-26 [1] CRAN (R 4.4.1)
 munsell             0.5.1       2024-04-01 [1] CRAN (R 4.4.1)
 nestcolor           0.1.2.9017  2024-11-02 [1] git2r (https://github.com/insightsengineering/nestcolor.git@3d2ce62)
 pillar              1.9.0       2023-03-22 [1] CRAN (R 4.4.1)
 pkgconfig           2.0.3       2019-09-22 [1] CRAN (R 4.4.1)
 purrr               1.0.2       2023-08-10 [1] CRAN (R 4.4.1)
 R6                  2.5.1       2021-08-19 [1] CRAN (R 4.4.1)
 random.cdisc.data   0.3.16.9001 2024-11-02 [1] git2r (https://github.com/insightsengineering/random.cdisc.data.git@a65bfbe)
 rbibutils           2.3         2024-10-04 [1] CRAN (R 4.4.1)
 Rdpack              2.6.1       2024-08-06 [1] CRAN (R 4.4.1)
 rlang               1.1.4       2024-06-04 [1] CRAN (R 4.4.1)
 rmarkdown           2.28        2024-08-17 [1] CRAN (R 4.4.1)
 rtables           * 0.6.10.9002 2024-11-02 [1] git2r (https://github.com/insightsengineering/rtables.git@d2cc7a0)
 scales              1.3.0       2023-11-28 [1] CRAN (R 4.4.1)
 sessioninfo         1.2.2       2021-12-06 [1] CRAN (R 4.4.1)
 stringi             1.8.4       2024-05-06 [1] CRAN (R 4.4.1)
 stringr             1.5.1       2023-11-14 [1] CRAN (R 4.4.1)
 survival            3.7-0       2024-06-05 [2] CRAN (R 4.4.1)
 tern              * 0.9.6.9013  2024-11-02 [1] git2r (https://github.com/insightsengineering/tern.git@435fd51)
 testthat            3.2.1.1     2024-04-14 [1] CRAN (R 4.4.1)
 tibble              3.2.1       2023-03-20 [1] CRAN (R 4.4.1)
 tidyr               1.3.1       2024-01-24 [1] CRAN (R 4.4.1)
 tidyselect          1.2.1       2024-03-11 [1] CRAN (R 4.4.1)
 utf8                1.2.4       2023-10-22 [1] CRAN (R 4.4.1)
 vctrs               0.6.5       2023-12-01 [1] CRAN (R 4.4.1)
 withr               3.0.1       2024-07-31 [1] CRAN (R 4.4.1)
 xfun                0.48        2024-10-03 [1] CRAN (R 4.4.1)
 yaml                2.3.10      2024-07-26 [1] CRAN (R 4.4.1)

 [1] /usr/local/lib/R/site-library
 [2] /usr/local/lib/R/library

──────────────────────────────────────────────────────────────────────────────

`.lock` file

Download the .lock file and use renv::restore() on it to recreate environment used to generate this website.

Download

Reproducibility

Timestamp

Session Info

.lock file

`.lock` file