from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('lbhe')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 21,927 Columns: 24
lbhe
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('lbhe')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 21,927 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.lbhe.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 | 4 | ANISO | Anisocytes | HEMATOLOGY | 1 | None | None | None | 1 | 1 | None | None | None | ABNORMAL | Y | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26T14:45 | -7 |
| 1 | CDISCPILOT01 | LB | 01-701-1015 | 6 | BASO | Basophils | HEMATOLOGY | 0.05 | 10^9/L | 0 | 0.2 | 0.05 | 0.05 | 10^9/L | 0 | 0.2 | NORMAL | Y | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26T14:45 | -7 |
| 2 | CDISCPILOT01 | LB | 01-701-1015 | 43 | BASO | Basophils | HEMATOLOGY | 0.03 | 10^9/L | 0 | 0.2 | 0.03 | 0.03 | 10^9/L | 0 | 0.2 | NORMAL | None | 4 | WEEK 2 | 14 | TREATMENT | 2014-01-16T13:17 | 15 |
| 3 | CDISCPILOT01 | LB | 01-701-1015 | 78 | BASO | Basophils | HEMATOLOGY | 0.02 | 10^9/L | 0 | 0.2 | 0.02 | 0.02 | 10^9/L | 0 | 0.2 | NORMAL | None | 5 | WEEK 4 | 28 | TREATMENT | 2014-01-30T08:50 | 29 |
| 4 | CDISCPILOT01 | LB | 01-701-1015 | 108 | BASO | Basophils | HEMATOLOGY | 0.04 | 10^9/L | 0 | 0.2 | 0.04 | 0.04 | 10^9/L | 0 | 0.2 | NORMAL | None | 7 | WEEK 6 | 42 | TREATMENT | 2014-02-12T12:56 | 42 |
| 5 | CDISCPILOT01 | LB | 01-701-1015 | 138 | BASO | Basophils | HEMATOLOGY | 0.05 | 10^9/L | 0 | 0.2 | 0.05 | 0.05 | 10^9/L | 0 | 0.2 | NORMAL | None | 8 | WEEK 8 | 56 | TREATMENT | 2014-03-05T12:25 | 63 |
| 6 | CDISCPILOT01 | LB | 01-701-1015 | 168 | BASO | Basophils | HEMATOLOGY | 0.04 | 10^9/L | 0 | 0.2 | 0.04 | 0.04 | 10^9/L | 0 | 0.2 | NORMAL | None | 9 | WEEK 12 | 84 | TREATMENT | 2014-03-26T15:15 | 84 |
| 7 | CDISCPILOT01 | LB | 01-701-1015 | 203 | BASO | Basophils | HEMATOLOGY | 0.03 | 10^9/L | 0 | 0.2 | 0.03 | 0.03 | 10^9/L | 0 | 0.2 | NORMAL | None | 10 | WEEK 16 | 112 | TREATMENT | 2014-05-07T11:21 | 126 |
| 8 | CDISCPILOT01 | LB | 01-701-1015 | 233 | BASO | Basophils | HEMATOLOGY | 0.03 | 10^9/L | 0 | 0.2 | 0.03 | 0.03 | 10^9/L | 0 | 0.2 | NORMAL | None | 11 | WEEK 20 | 140 | TREATMENT | 2014-05-21T10:58 | 140 |
| 9 | CDISCPILOT01 | LB | 01-701-1015 | 263 | BASO | Basophils | HEMATOLOGY | 0.04 | 10^9/L | 0 | 0.2 | 0.04 | 0.04 | 10^9/L | 0 | 0.2 | NORMAL | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18T13:00 | 168 |