from pharmadata import cdiscpilotadam
meta = cdiscpilotadam.meta('adlbh')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 24,966 Columns: 46adlbh
adlbh
Analysis Dataset Lab Hematology
Structure: one record per subject per parameter per analysis visit
Variables
Show variable specs
shape: (46, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | null |
| "STUDYID" | "Study Identifier" | "String" | "No" | null |
| "SUBJID" | "Subject Identifier for the Study" | "String" | "No" | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | "No" | null |
| "TRTP" | "Planned Treatment" | "String" | "No" | null |
| "TRTPN" | "Planned Treatment (N)" | "Float64" | "No" | null |
| "TRTA" | "Actual Treatment" | "String" | "No" | null |
| "TRTAN" | "Actual Treatment (N)" | "Float64" | "No" | null |
| "TRTSDT" | "Date of First Exposure to Treatment" | "Float64" | "No" | null |
| "TRTEDT" | "Date of Last Exposure to Treatment" | "Float64" | "No" | null |
| "AGE" | "Age" | "Float64" | "No" | null |
| "AGEGR1" | "Pooled Age Group 1" | "String" | "No" | null |
| "AGEGR1N" | "Pooled Age Group 1 (N)" | "Float64" | "No" | null |
| "RACE" | "Race" | "String" | "No" | null |
| "RACEN" | "Race (N)" | "Float64" | "No" | null |
| "SEX" | "Sex" | "String" | "No" | null |
| "COMP24FL" | "Completers of Week 24 Population Flag" | "String" | "No" | null |
| "DSRAEFL" | "Discontinued due to AE?" | "String" | "No" | null |
| "SAFFL" | "Safety Population Flag" | "String" | "No" | null |
| "AVISIT" | "Analysis Visit" | "String" | "No" | null |
| "AVISITN" | "Analysis Visit (N)" | "Float64" | "No" | null |
| "ADY" | "Analysis Relative Day" | "Float64" | "No" | null |
| "ADT" | "Analysis Date" | "Float64" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "PARAM" | "Parameter" | "String" | "No" | null |
| "PARAMCD" | "Parameter Code" | "String" | "No" | null |
| "PARAMN" | "Parameter (N)" | "Float64" | "No" | null |
| "PARCAT1" | "Parameter Category 1" | "String" | "No" | null |
| "AVAL" | "Analysis Value" | "Float64" | "No" | null |
| "BASE" | "Baseline Value" | "Float64" | "No" | null |
| "CHG" | "Change from Baseline" | "Float64" | "No" | null |
| "A1LO" | "Analysis Range 1 Lower Limit" | "Float64" | "No" | null |
| "A1HI" | "Analysis Range 1 Upper Limit" | "Float64" | "No" | null |
| "R2A1LO" | "Ratio to Analysis Range 1 Lower Limit" | "Float64" | "No" | null |
| "R2A1HI" | "Ratio to Analysis Range 1 Upper Limit" | "Float64" | "No" | null |
| "BR2A1LO" | "Base Ratio to Analysis Range 1 Lower Lim" | "Float64" | "No" | null |
| "BR2A1HI" | "Base Ratio to Analysis Range 1 Upper Lim" | "Float64" | "No" | null |
| "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null |
| "ALBTRVAL" | "Amount Threshold Range" | "Float64" | "No" | null |
| "ANRIND" | "Analysis Reference Range Indicator" | "String" | "No" | null |
| "BNRIND" | "Baseline Reference Range Indicator" | "String" | "No" | null |
| "ABLFL" | "Baseline Record Flag" | "String" | "No" | null |
| "AENTMTFL" | "Last value in treatment visit" | "String" | "No" | null |
| "LBSEQ" | "Sequence Number" | "Float64" | "No" | null |
| "LBNRIND" | "Reference Range Indicator" | "String" | "No" | null |
| "LBSTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotadam
tbl_explorer(cdiscpilotadam.adlbh.head(10))PolarsRows10Columns46 | ||||||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
SUBJID str |
USUBJID str |
TRTP str |
TRTPN f64 |
TRTA str |
TRTAN f64 |
TRTSDT f64 |
TRTEDT f64 |
AGE f64 |
AGEGR1 str |
AGEGR1N f64 |
RACE str |
RACEN f64 |
SEX str |
COMP24FL str |
DSRAEFL str |
SAFFL str |
AVISIT str |
AVISITN f64 |
ADY f64 |
ADT f64 |
VISIT str |
VISITNUM f64 |
PARAM str |
PARAMCD str |
PARAMN f64 |
PARCAT1 str |
AVAL f64 |
BASE f64 |
CHG f64 |
A1LO f64 |
A1HI f64 |
R2A1LO f64 |
R2A1HI f64 |
BR2A1LO f64 |
BR2A1HI f64 |
ANL01FL str |
ALBTRVAL f64 |
ANRIND str |
BNRIND str |
ABLFL str |
AENTMTFL str |
LBSEQ f64 |
LBNRIND str |
LBSTRESN f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Hemoglobin (mmol/L) | HGB | 1 | HEM | 8.87458 | 8.87458 | None | 7.14 | 9.81 | 1.24293837535 | 0.904646279307 | 1.24293837535 | 0.904646279307 | None | 5.84042 | N | N | Y | None | 19 | NORMAL | 8.87458 |
| 1 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Hematocrit | HCT | 2 | HEM | 0.42 | 0.42 | None | 0.34 | 0.48 | 1.23529411765 | 0.875 | 1.23529411765 | 0.875 | None | 0.3 | N | N | Y | None | 18 | NORMAL | 0.42 |
| 2 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Ery. Mean Corpuscular Volume (fL) | MCV | 3 | HEM | 80 | 80 | None | 80 | 100 | 1 | 0.8 | 1 | 0.8 | None | 70 | N | N | Y | None | 25 | NORMAL | 80 |
| 3 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Ery. Mean Corpuscular Hemoglobin (fmol(Fe)) | MCH | 4 | HEM | 1.67562 | 1.67562 | None | 1.6 | 2.1 | 1.0472625 | 0.797914285714 | 1.0472625 | 0.797914285714 | None | 1.47438 | N | N | Y | None | 23 | NORMAL | 1.67562 |
| 4 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Ery. Mean Corpuscular HGB Concentration (mmol/L) | MCHC | 5 | HEM | 21.1004 | 21.1004 | None | 19 | 24 | 1.11054736842 | 0.879183333333 | 1.11054736842 | 0.879183333333 | None | 14.8996 | N | N | Y | None | 24 | NORMAL | 21.1004 |
| 5 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Leukocytes (GI/L) | WBC | 6 | HEM | 5.78 | 5.78 | None | 3.8 | 10.7 | 1.52105263158 | 0.540186915888 | 1.52105263158 | 0.540186915888 | None | 10.27 | N | N | Y | None | 38 | NORMAL | 5.78 |
| 6 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Lymphocytes (GI/L) | LYM | 7 | HEM | 2.11 | 2.11 | None | 0.8 | 3 | 2.6375 | 0.703333333333 | 2.6375 | 0.703333333333 | None | 2.39 | N | N | Y | None | 22 | NORMAL | 2.11 |
| 7 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Monocytes (GI/L) | MONO | 8 | HEM | 0.22 | 0.22 | None | 0.12 | 0.92 | 1.83333333333 | 0.239130434783 | 1.83333333333 | 0.239130434783 | None | 1.16 | N | N | Y | None | 26 | NORMAL | 0.22 |
| 8 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Eosinophils (GI/L) | EOS | 9 | HEM | 0.13 | 0.13 | None | None | 0.57 | None | 0.228070175439 | None | 0.228070175439 | None | 0.725 | N | N | Y | None | 15 | NORMAL | 0.13 |
| 9 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 19725 | 19906 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 19718 | SCREENING 1 | 1 | Basophils (GI/L) | BASO | 10 | HEM | 0.05 | 0.05 | None | None | 0.2 | None | 0.25 | None | 0.25 | None | 0.25 | N | N | Y | None | 6 | NORMAL | 0.05 |