from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('lbch')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 32,740 Columns: 24
lbch
Structure: One record per analyte per planned time point number per time point reference per visit per subject
from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('lbch')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 32,740 Columns: 24
| 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" |
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.lbch.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 | 1 | ALB | Albumin | CHEMISTRY | 3.8 | g/dL | 3.3 | 4.9 | 38 | 38 | g/L | 33 | 49 | NORMAL | Y | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26T14:45 | -7 |
| 1 | CDISCPILOT01 | LB | 01-701-1015 | 39 | ALB | Albumin | CHEMISTRY | 3.9 | g/dL | 3.3 | 4.9 | 39 | 39 | g/L | 33 | 49 | NORMAL | None | 4 | WEEK 2 | 14 | TREATMENT | 2014-01-16T13:17 | 15 |
| 2 | CDISCPILOT01 | LB | 01-701-1015 | 74 | ALB | Albumin | CHEMISTRY | 3.8 | g/dL | 3.3 | 4.9 | 38 | 38 | g/L | 33 | 49 | NORMAL | None | 5 | WEEK 4 | 28 | TREATMENT | 2014-01-30T08:50 | 29 |
| 3 | CDISCPILOT01 | LB | 01-701-1015 | 104 | ALB | Albumin | CHEMISTRY | 3.7 | g/dL | 3.3 | 4.9 | 37 | 37 | g/L | 33 | 49 | NORMAL | None | 7 | WEEK 6 | 42 | TREATMENT | 2014-02-12T12:56 | 42 |
| 4 | CDISCPILOT01 | LB | 01-701-1015 | 134 | ALB | Albumin | CHEMISTRY | 3.8 | g/dL | 3.3 | 4.9 | 38 | 38 | g/L | 33 | 49 | NORMAL | None | 8 | WEEK 8 | 56 | TREATMENT | 2014-03-05T12:25 | 63 |
| 5 | CDISCPILOT01 | LB | 01-701-1015 | 164 | ALB | Albumin | CHEMISTRY | 3.8 | g/dL | 3.3 | 4.9 | 38 | 38 | g/L | 33 | 49 | NORMAL | None | 9 | WEEK 12 | 84 | TREATMENT | 2014-03-26T15:15 | 84 |
| 6 | CDISCPILOT01 | LB | 01-701-1015 | 199 | ALB | Albumin | CHEMISTRY | 3.7 | g/dL | 3.3 | 4.9 | 37 | 37 | g/L | 33 | 49 | NORMAL | None | 10 | WEEK 16 | 112 | TREATMENT | 2014-05-07T11:21 | 126 |
| 7 | CDISCPILOT01 | LB | 01-701-1015 | 229 | ALB | Albumin | CHEMISTRY | 3.7 | g/dL | 3.3 | 4.9 | 37 | 37 | g/L | 33 | 49 | NORMAL | None | 11 | WEEK 20 | 140 | TREATMENT | 2014-05-21T10:58 | 140 |
| 8 | CDISCPILOT01 | LB | 01-701-1015 | 259 | ALB | Albumin | CHEMISTRY | 3.8 | g/dL | 3.3 | 4.9 | 38 | 38 | g/L | 33 | 49 | NORMAL | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18T13:00 | 168 |
| 9 | CDISCPILOT01 | LB | 01-701-1015 | 294 | ALB | Albumin | CHEMISTRY | 3.8 | g/dL | 3.3 | 4.9 | 38 | 38 | g/L | 33 | 49 | NORMAL | None | 13 | WEEK 26 | 182 | TREATMENT | 2014-07-02T11:45 | 182 |