from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('lbur')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 4,913 Columns: 24lbur
lbur
Laboratory Tests Results
Structure: One record per analyte per planned time point number per time point reference per visit per subject
Variables
Show variable specs
shape: (24, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | str |
| "STUDYID" | "Study Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "DOMAIN" | "Domain Abbreviation" | "String" | "Yes" | "IDENTIFIER" |
| "USUBJID" | "Unique Subject Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "LBSEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "LBTESTCD" | "Lab Test or Examination Short Name" | "String" | "Yes" | "TOPIC" |
| "LBTEST" | "Lab Test or Examination Name" | "String" | "Yes" | "SYNONYM QUALIFIER" |
| "LBCAT" | "Category for Lab Test" | "String" | "No" | "GROUPING QUALIFIER" |
| "LBORRES" | "Result or Finding in Original Units" | "String" | "No" | "RESULT QUALIFIER" |
| "LBORRESU" | "Original Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "LBORNRLO" | "Reference Range Lower Limit in Orig Unit" | "String" | "No" | "VARIABLE QUALIFIER" |
| "LBORNRHI" | "Reference Range Upper Limit in Orig Unit" | "String" | "No" | "VARIABLE QUALIFIER" |
| "LBSTRESC" | "Character Result/Finding in Std Format" | "String" | "No" | "RESULT QUALIFIER" |
| "LBSTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | "RESULT QUALIFIER" |
| "LBSTRESU" | "Standard Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "LBSTNRLO" | "Reference Range Lower Limit-Std Units" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "LBSTNRHI" | "Reference Range Upper Limit-Std Units" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "LBNRIND" | "Reference Range Indicator" | "String" | "No" | "VARIABLE QUALIFIER" |
| "LBBLFL" | "Baseline Flag" | "String" | "No" | "RECORD QUALIFIER" |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | "TIMING" |
| "VISIT" | "Visit Name" | "String" | "No" | "TIMING" |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | "No" | "TIMING" |
| "EPOCH" | "Epoch" | "String" | "No" | "TIMING" |
| "LBDTC" | "Date/Time of Specimen Collection" | "String" | "No" | "TIMING" |
| "LBDY" | "Study Day of Specimen Collection" | "Float64" | "No" | "TIMING" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.lbur.head(10))PolarsRows10Columns24 | ||||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
LBSEQ f64 |
LBTESTCD str |
LBTEST str |
LBCAT str |
LBORRES str |
LBORRESU str |
LBORNRLO str |
LBORNRHI str |
LBSTRESC str |
LBSTRESN f64 |
LBSTRESU str |
LBSTNRLO f64 |
LBSTNRHI f64 |
LBNRIND str |
LBBLFL str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
EPOCH str |
LBDTC str |
LBDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | LB | 01-701-1015 | 13 | COLOR | Color | URINALYSIS | N | None | None | None | N | None | None | None | None | NORMAL | Y | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26T14:45 | -7 |
| 1 | CDISCPILOT01 | LB | 01-701-1015 | 50 | COLOR | Color | URINALYSIS | N | None | None | None | N | None | None | None | None | NORMAL | None | 4 | WEEK 2 | 14 | TREATMENT | 2014-01-16T13:17 | 15 |
| 2 | CDISCPILOT01 | LB | 01-701-1015 | 175 | COLOR | Color | URINALYSIS | N | None | None | None | N | None | None | None | None | NORMAL | None | 9 | WEEK 12 | 84 | TREATMENT | 2014-03-26T15:15 | 84 |
| 3 | CDISCPILOT01 | LB | 01-701-1015 | 270 | COLOR | Color | URINALYSIS | N | None | None | None | N | None | None | None | None | NORMAL | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18T13:00 | 168 |
| 4 | CDISCPILOT01 | LB | 01-701-1015 | 21 | KETONES | Ketones | URINALYSIS | 0 | None | None | None | 0 | 0 | None | None | None | NORMAL | Y | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26T14:45 | -7 |
| 5 | CDISCPILOT01 | LB | 01-701-1015 | 58 | KETONES | Ketones | URINALYSIS | 0 | None | None | None | 0 | 0 | None | None | None | NORMAL | None | 4 | WEEK 2 | 14 | TREATMENT | 2014-01-16T13:17 | 15 |
| 6 | CDISCPILOT01 | LB | 01-701-1015 | 183 | KETONES | Ketones | URINALYSIS | 0 | None | None | None | 0 | 0 | None | None | None | NORMAL | None | 9 | WEEK 12 | 84 | TREATMENT | 2014-03-26T15:15 | 84 |
| 7 | CDISCPILOT01 | LB | 01-701-1015 | 278 | KETONES | Ketones | URINALYSIS | 0 | None | None | None | 0 | 0 | None | None | None | NORMAL | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18T13:00 | 168 |
| 8 | CDISCPILOT01 | LB | 01-701-1015 | 28 | PH | pH | URINALYSIS | 5.0 | None | 5 | 8 | 5 | 5 | None | 5 | 8 | NORMAL | Y | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26T14:45 | -7 |
| 9 | CDISCPILOT01 | LB | 01-701-1015 | 65 | PH | pH | URINALYSIS | 5.0 | None | 5 | 8 | 5 | 5 | None | 5 | 8 | NORMAL | None | 4 | WEEK 2 | 14 | TREATMENT | 2014-01-16T13:17 | 15 |