![[Experimental]](figures/lifecycle-experimental.svg)
Creates listings by using cols and key_cols to produce a compact and
elegant representation of the data.frame or tibble in input.
Usage
as_listing(
df,
key_cols = names(df)[1],
disp_cols = NULL,
non_disp_cols = NULL,
main_title = NULL,
subtitles = NULL,
main_footer = NULL,
prov_footer = NULL
)
as_keycol(vec)
is_keycol(vec)
get_keycols(df)
# S4 method for listing_df
matrix_form(obj, indent_rownames = FALSE)
listing_dispcols(df)
add_listing_dispcol(df, new)
listing_dispcols(df) <- value
add_listing_col(df, name, fun = NULL, format = NULL, na_str = "-")Arguments
- df
data.frame or listing_df. The (non-listing) data.frame to be converted to a listing or the listing_df to be modified.
- key_cols
character. Names of columns which should be treated as key columns when rendering the listing. Key columns allow you to group repeat occurrences.
- disp_cols
character or NULL. Names of non-key columns which should be displayed when the listing is rendered. Defaults to all columns of
dfnot named inkey_colsornon_disp_cols.- non_disp_cols
character or NULL. Names of non-key columns to be excluded as display columns. All other non-key columns are then treated as display columns. Invalid if
disp_colsis non-NULL.- main_title
character(1) or NULL. The main title for the listing, or
NULL(the default). Must be length 1 non-NULL.- subtitles
character or NULL. A vector of subtitle(s) for the listing, or
NULL(the default).- main_footer
character or NULL. A vector of main footer lines for the listing, or
NULL(the default).- prov_footer
character or NULL. A vector of provenance strings for the listing, or
NULL(the default). Each string element is placed on a new line.- vec
any. A column vector from a
listing_dfto be annotated as a key column.- obj
ANY. Object to be transformed into a ready-to-render form (a MatrixPrintForm object)
- indent_rownames
logical(1). Silently ignored, as listings do not have row names nor indenting structure.
- new
character. Names of columns to be added to the set of display columns.
- value
character. New value.
- name
character(1). Name of the existing or new column to be displayed when the listing is rendered.
- fun
function or NULL. A function which accepts
dfand returns the vector for a new column, which is added todfasname, or NULL if marking an existing column as a listing column.- format
character(1) or function. The format label (string) or formatter function to apply to
x.- na_str
character(1). String that should be displayed when the value of
xis missing. Defaults to"NA".
Value
A listing_df object, sorted by the key columns.
df, with name created (if necessary) and marked for
display during rendering.
Details
At its core, a listing_df object is a tbl_df object with a customized
print method and support for the formatting and pagination machinery provided by
the formatters package.
listing_df objects have two 'special' types of columns: key columns and display columns.
Key columns act as indexes, which means a number of things in practice.
All key columns are also display columns.
listing_df objects are always sorted by their set of key_columns at creation time.
Any listing_df object which is not sorted by its full set of key columns (e.g.,
one whose rows have been reordered explicitly creation) is invalid and the behavior
when rendering or paginating that object is undefined.
Each value of a key column is printed only once per page and per unique combination of values for all higher-priority (i.e., to the left of it) key columns. Locations where a repeated value would have been printed within a key column for the same higher-priority-key combination on the same page are rendered as empty space. Note, determination of which elements to display within a key column at rendering is based on the underlying value; any non-default formatting applied to the column has no effect on this behavior.
Display columns are columns which should be rendered, but are not key columns. By default this is all non-key columns in the incoming data, but in need not be. Columns in the underlying data which are neither key nor display columns remain within the object available for computations but are not rendered during printing or export of the listing.
See also
formatters::matrix_form() This is partially inherited from formatters' function
Examples
dat <- ex_adae
# This example demonstrates the listing with key_cols (values are grouped by USUBJID) and
# multiple lines in prov_footer
lsting <- as_listing(dat[1:25, ],
key_cols = c("USUBJID", "AESOC"),
main_title = "Example Title for Listing",
subtitles = "This is the subtitle for this Adverse Events Table",
main_footer = "Main footer for the listing",
prov_footer = c(
"You can even add a subfooter", "Second element is place on a new line",
"Third string"
)
) %>%
add_listing_col("AETOXGR") %>%
add_listing_col("BMRKR1", format = "xx.x") %>%
add_listing_col("AESER / AREL", fun = function(df) paste(df$AESER, df$AREL, sep = " / "))
#> sorting incoming data by key columns
mat <- matrix_form(lsting)
cat(toString(mat))
#> Example Title for Listing
#> This is the subtitle for this Adverse Events Table
#>
#> —————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
#> Unique Subject Identifier Primary System Organ Class Study Identifier Subject Identifier for the Study Study Site Identifier Age Sex Race Country Investigator Identifier Description of Planned Arm Planned Arm Code Description of Actual Arm Actual Arm Code Stratification Factor 1 Stratification Factor 2 Continous Level Biomarker 1 Categorical Level Biomarker 2 Intent-To-Treat Population Flag Safety Population Flag Response Evaluable Population Flag Biomarker Evaluable Population Flag Date of Randomization Datetime of First Exposure to Treatment Datetime of Last Exposure to Treatment End of Study Status End of Study Date End of Study Relative Day Reason for Discontinuation from Study Date of Death Date Last Known Alive NOT A STANDARD BUT NEEDED FOR RCD Analysis Sequence Number Sponsor-Defined Identifier Reported Term for the Adverse Event Lowest Level Term Dictionary-Derived Term High Level Term High Level Group Term Body System or Organ Class Severity/Intensity Serious Event Analysis Causality Analysis Start Datetime Analysis End Datetime Analysis Start Relative Day Analysis End Relative Day Analysis Toxicity Grade AESER / AREL
#> —————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
#> AB12345-BRA-1-id-134 cl A AB12345 id-134 BRA-1 47 M WHITE BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S2 6.5 LOW Y Y Y N 2021-06-09 2021-06-10 13:26:53 2023-06-11 01:05:17 COMPLETED 2023-06-11 731 NA 2023-06-11 2023-06-29 63113904 3 3 trm A.1.1.1.2 llt A.1.1.1.2 dcd A.1.1.1.2 hlt A.1.1.1 hlgt A.1.1 cl A.1 MODERATE Y N 2022-10-20 2023-06-05 497 725 2 Y / N
#> AB12345 id-134 BRA-1 47 M WHITE BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S2 6.5 LOW Y Y Y N 2021-06-09 2021-06-10 13:26:53 2023-06-11 01:05:17 COMPLETED 2023-06-11 731 NA 2023-06-11 2023-06-29 63113904 4 4 trm A.1.1.1.2 llt A.1.1.1.2 dcd A.1.1.1.2 hlt A.1.1.1 hlgt A.1.1 cl A.1 MODERATE Y N 2023-02-08 2023-04-15 608 674 2 Y / N
#> cl B AB12345 id-134 BRA-1 47 M WHITE BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S2 6.5 LOW Y Y Y N 2021-06-09 2021-06-10 13:26:53 2023-06-11 01:05:17 COMPLETED 2023-06-11 731 NA 2023-06-11 2023-06-29 63113904 1 1 trm B.2.1.2.1 llt B.2.1.2.1 dcd B.2.1.2.1 hlt B.2.1.2 hlgt B.2.1 cl B.2 MODERATE N N 2022-02-16 2022-11-10 251 518 3 N / N
#> cl D AB12345 id-134 BRA-1 47 M WHITE BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S2 6.5 LOW Y Y Y N 2021-06-09 2021-06-10 13:26:53 2023-06-11 01:05:17 COMPLETED 2023-06-11 731 NA 2023-06-11 2023-06-29 63113904 2 2 trm D.1.1.4.2 llt D.1.1.4.2 dcd D.1.1.4.2 hlt D.1.1.4 hlgt D.1.1 cl D.1 MODERATE N N 2022-04-10 2022-12-21 304 559 3 N / N
#> AB12345-BRA-1-id-141 cl A AB12345 id-141 BRA-1 35 F WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C B S1 7.5 HIGH Y Y Y Y 2021-02-25 2021-02-28 23:47:16 2023-03-01 11:25:40 COMPLETED 2023-03-01 731 NA 2023-03-01 2023-03-30 63113904 3 3 trm A.1.1.1.1 llt A.1.1.1.1 dcd A.1.1.1.1 hlt A.1.1.1 hlgt A.1.1 cl A.1 MILD N N 2022-07-06 2022-07-29 493 516 1 N / N
#> AB12345 id-141 BRA-1 35 F WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C B S1 7.5 HIGH Y Y Y Y 2021-02-25 2021-02-28 23:47:16 2023-03-01 11:25:40 COMPLETED 2023-03-01 731 NA 2023-03-01 2023-03-30 63113904 4 4 trm A.1.1.1.2 llt A.1.1.1.2 dcd A.1.1.1.2 hlt A.1.1.1 hlgt A.1.1 cl A.1 MODERATE Y N 2022-10-21 2023-01-22 600 693 2 Y / N
#> AB12345 id-141 BRA-1 35 F WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C B S1 7.5 HIGH Y Y Y Y 2021-02-25 2021-02-28 23:47:16 2023-03-01 11:25:40 COMPLETED 2023-03-01 731 NA 2023-03-01 2023-03-30 63113904 5 5 trm A.1.1.1.1 llt A.1.1.1.1 dcd A.1.1.1.1 hlt A.1.1.1 hlgt A.1.1 cl A.1 MILD N N 2022-11-25 2023-01-07 635 678 1 N / N
#> cl B AB12345 id-141 BRA-1 35 F WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C B S1 7.5 HIGH Y Y Y Y 2021-02-25 2021-02-28 23:47:16 2023-03-01 11:25:40 COMPLETED 2023-03-01 731 NA 2023-03-01 2023-03-30 63113904 1 1 trm B.2.1.2.1 llt B.2.1.2.1 dcd B.2.1.2.1 hlt B.2.1.2 hlgt B.2.1 cl B.2 MODERATE N N 2021-11-14 2021-11-21 259 266 3 N / N
#> cl D AB12345 id-141 BRA-1 35 F WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C B S1 7.5 HIGH Y Y Y Y 2021-02-25 2021-02-28 23:47:16 2023-03-01 11:25:40 COMPLETED 2023-03-01 731 NA 2023-03-01 2023-03-30 63113904 2 2 trm D.2.1.5.3 llt D.2.1.5.3 dcd D.2.1.5.3 hlt D.2.1.5 hlgt D.2.1 cl D.2 MILD N Y 2021-12-28 2023-02-21 303 723 1 N / Y
#> AB12345 id-141 BRA-1 35 F WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C B S1 7.5 HIGH Y Y Y Y 2021-02-25 2021-02-28 23:47:16 2023-03-01 11:25:40 COMPLETED 2023-03-01 731 NA 2023-03-01 2023-03-30 63113904 6 6 trm D.1.1.1.1 llt D.1.1.1.1 dcd D.1.1.1.1 hlt D.1.1.1 hlgt D.1.1 cl D.1 SEVERE Y N 2023-02-28 2023-03-01 730 731 5 Y / N
#> AB12345-BRA-1-id-236 cl B AB12345 id-236 BRA-1 32 M BLACK OR AFRICAN AMERICAN BRA BRA-1 B: Placebo ARM B B: Placebo ARM B A S2 7.7 HIGH Y Y Y Y 2021-08-17 2021-08-21 18:13:25 2023-08-22 05:51:49 COMPLETED 2023-08-22 731 NA 2023-08-22 2023-09-14 63113904 1 1 trm B.1.1.1.1 llt B.1.1.1.1 dcd B.1.1.1.1 hlt B.1.1.1 hlgt B.1.1 cl B.1 SEVERE N Y 2021-09-12 2022-10-27 22 432 5 N / Y
#> AB12345 id-236 BRA-1 32 M BLACK OR AFRICAN AMERICAN BRA BRA-1 B: Placebo ARM B B: Placebo ARM B A S2 7.7 HIGH Y Y Y Y 2021-08-17 2021-08-21 18:13:25 2023-08-22 05:51:49 COMPLETED 2023-08-22 731 NA 2023-08-22 2023-09-14 63113904 2 2 trm B.1.1.1.1 llt B.1.1.1.1 dcd B.1.1.1.1 hlt B.1.1.1 hlgt B.1.1 cl B.1 SEVERE N Y 2022-02-18 2023-07-20 181 698 5 N / Y
#> AB12345 id-236 BRA-1 32 M BLACK OR AFRICAN AMERICAN BRA BRA-1 B: Placebo ARM B B: Placebo ARM B A S2 7.7 HIGH Y Y Y Y 2021-08-17 2021-08-21 18:13:25 2023-08-22 05:51:49 COMPLETED 2023-08-22 731 NA 2023-08-22 2023-09-14 63113904 3 3 trm B.1.1.1.1 llt B.1.1.1.1 dcd B.1.1.1.1 hlt B.1.1.1 hlgt B.1.1 cl B.1 SEVERE N Y 2023-07-24 2023-07-28 702 706 5 N / Y
#> AB12345-BRA-1-id-265 cl C AB12345 id-265 BRA-1 25 M WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C A S2 10.3 MEDIUM Y Y Y N 2020-05-09 2020-05-13 00:38:12 2021-09-18 15:23:35 DISCONTINUED 2021-09-18 494 WITHDRAWAL BY PARENT/GUARDIAN 2021-09-18 2021-10-08 63113904 1 1 trm C.2.1.2.1 llt C.2.1.2.1 dcd C.2.1.2.1 hlt C.2.1.2 hlgt C.2.1 cl C.2 MODERATE N Y 2020-06-30 2020-08-13 48 92 2 N / Y
#> AB12345 id-265 BRA-1 25 M WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C A S2 10.3 MEDIUM Y Y Y N 2020-05-09 2020-05-13 00:38:12 2021-09-18 15:23:35 DISCONTINUED 2021-09-18 494 WITHDRAWAL BY PARENT/GUARDIAN 2021-09-18 2021-10-08 63113904 4 4 trm C.1.1.1.3 llt C.1.1.1.3 dcd C.1.1.1.3 hlt C.1.1.1 hlgt C.1.1 cl C.1 SEVERE N Y 2021-06-20 2021-07-27 403 440 4 N / Y
#> cl D AB12345 id-265 BRA-1 25 M WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C A S2 10.3 MEDIUM Y Y Y N 2020-05-09 2020-05-13 00:38:12 2021-09-18 15:23:35 DISCONTINUED 2021-09-18 494 WITHDRAWAL BY PARENT/GUARDIAN 2021-09-18 2021-10-08 63113904 2 2 trm D.1.1.4.2 llt D.1.1.4.2 dcd D.1.1.4.2 hlt D.1.1.4 hlgt D.1.1 cl D.1 MODERATE N N 2020-11-29 2021-05-10 200 362 3 N / N
#> AB12345 id-265 BRA-1 25 M WHITE BRA BRA-1 C: Combination ARM C C: Combination ARM C A S2 10.3 MEDIUM Y Y Y N 2020-05-09 2020-05-13 00:38:12 2021-09-18 15:23:35 DISCONTINUED 2021-09-18 494 WITHDRAWAL BY PARENT/GUARDIAN 2021-09-18 2021-10-08 63113904 3 3 trm D.1.1.1.1 llt D.1.1.1.1 dcd D.1.1.1.1 hlt D.1.1.1 hlgt D.1.1 cl D.1 SEVERE Y N 2021-06-09 2021-06-30 392 413 5 Y / N
#> AB12345-BRA-1-id-42 cl A AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 4 4 trm A.1.1.1.2 llt A.1.1.1.2 dcd A.1.1.1.2 hlt A.1.1.1 hlgt A.1.1 cl A.1 MODERATE Y N 2021-01-14 2021-09-30 160 419 2 Y / N
#> AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 6 6 trm A.1.1.1.2 llt A.1.1.1.2 dcd A.1.1.1.2 hlt A.1.1.1 hlgt A.1.1 cl A.1 MODERATE Y N 2021-11-10 2022-05-23 460 654 2 Y / N
#> AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 8 8 trm A.1.1.1.2 llt A.1.1.1.2 dcd A.1.1.1.2 hlt A.1.1.1 hlgt A.1.1 cl A.1 MODERATE Y N 2021-11-26 2022-03-18 476 588 2 Y / N
#> cl B AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 5 5 trm B.2.2.3.1 llt B.2.2.3.1 dcd B.2.2.3.1 hlt B.2.2.3 hlgt B.2.2 cl B.2 MILD Y N 2021-05-26 2021-07-15 292 342 1 Y / N
#> AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 7 7 trm B.1.1.1.1 llt B.1.1.1.1 dcd B.1.1.1.1 hlt B.1.1.1 hlgt B.1.1 cl B.1 SEVERE N Y 2021-11-20 2022-03-30 470 600 5 N / Y
#> cl C AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 1 1 trm C.2.1.2.1 llt C.2.1.2.1 dcd C.2.1.2.1 hlt C.2.1.2 hlgt C.2.1 cl C.2 MODERATE N Y 2020-09-15 2022-02-03 39 545 2 N / Y
#> AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 3 3 trm C.2.1.2.1 llt C.2.1.2.1 dcd C.2.1.2.1 hlt C.2.1.2 hlgt C.2.1 cl C.2 MODERATE N Y 2020-11-10 2021-09-12 95 401 2 N / Y
#> cl D AB12345 id-42 BRA-1 36 M BLACK OR AFRICAN AMERICAN BRA BRA-1 A: Drug X ARM A A: Drug X ARM A B S1 2.3 MEDIUM Y Y Y Y 2020-08-06 2020-08-07 06:44:59 NA ONGOING NA NA NA NA NA 63113904 2 2 trm D.1.1.1.1 llt D.1.1.1.1 dcd D.1.1.1.1 hlt D.1.1.1 hlgt D.1.1 cl D.1 SEVERE Y N 2020-10-11 2022-07-02 65 694 5 Y / N
#> —————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
#>
#> Main footer for the listing
#>
#> You can even add a subfooter
#> Second element is place on a new line
#> Third string
# This example demonstrates the listing table without key_cols
# and specifying the cols with disp_cols.
dat <- ex_adae
lsting <- as_listing(dat[1:25, ], disp_cols = c("USUBJID", "AESOC", "RACE", "AETOXGR", "BMRKR1"))
mat <- matrix_form(lsting)
cat(toString(mat))
#> Study Identifier Unique Subject Identifier Primary System Organ Class Race Analysis Toxicity Grade Continous Level Biomarker 1
#> —————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
#> AB12345 AB12345-BRA-1-id-134 cl B WHITE 3 6.46299057842479
#> AB12345-BRA-1-id-134 cl D WHITE 3 6.46299057842479
#> AB12345-BRA-1-id-134 cl A WHITE 2 6.46299057842479
#> AB12345-BRA-1-id-134 cl A WHITE 2 6.46299057842479
#> AB12345-BRA-1-id-141 cl B WHITE 3 7.51607612428241
#> AB12345-BRA-1-id-141 cl D WHITE 1 7.51607612428241
#> AB12345-BRA-1-id-141 cl A WHITE 1 7.51607612428241
#> AB12345-BRA-1-id-141 cl A WHITE 2 7.51607612428241
#> AB12345-BRA-1-id-141 cl A WHITE 1 7.51607612428241
#> AB12345-BRA-1-id-141 cl D WHITE 5 7.51607612428241
#> AB12345-BRA-1-id-236 cl B BLACK OR AFRICAN AMERICAN 5 7.66300121077566
#> AB12345-BRA-1-id-236 cl B BLACK OR AFRICAN AMERICAN 5 7.66300121077566
#> AB12345-BRA-1-id-236 cl B BLACK OR AFRICAN AMERICAN 5 7.66300121077566
#> AB12345-BRA-1-id-265 cl C WHITE 2 10.323346349886
#> AB12345-BRA-1-id-265 cl D WHITE 3 10.323346349886
#> AB12345-BRA-1-id-265 cl D WHITE 5 10.323346349886
#> AB12345-BRA-1-id-265 cl C WHITE 4 10.323346349886
#> AB12345-BRA-1-id-42 cl C BLACK OR AFRICAN AMERICAN 2 2.26753940777848
#> AB12345-BRA-1-id-42 cl D BLACK OR AFRICAN AMERICAN 5 2.26753940777848
#> AB12345-BRA-1-id-42 cl C BLACK OR AFRICAN AMERICAN 2 2.26753940777848
#> AB12345-BRA-1-id-42 cl A BLACK OR AFRICAN AMERICAN 2 2.26753940777848
#> AB12345-BRA-1-id-42 cl B BLACK OR AFRICAN AMERICAN 1 2.26753940777848
#> AB12345-BRA-1-id-42 cl A BLACK OR AFRICAN AMERICAN 2 2.26753940777848
#> AB12345-BRA-1-id-42 cl B BLACK OR AFRICAN AMERICAN 5 2.26753940777848
#> AB12345-BRA-1-id-42 cl A BLACK OR AFRICAN AMERICAN 2 2.26753940777848