from pharmadata import cdiscpilotadam
meta = cdiscpilotadam.meta('adlbhy')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 9,954 Columns: 43adlbhy
adlbhy
Analysis Dataset Lab Hy’s Law
Structure: one record per subject per parameter per analysis visit
Variables
Show variable specs
shape: (43, 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" | "Date" | "No" | null |
| "TRTEDT" | "Date of Last Exposure to Treatment" | "Date" | "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" | "Date" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "PARAMTYP" | "Parameter Type" | "String" | "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 |
| "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 |
| "ABLFL" | "Baseline Record Flag" | "String" | "No" | null |
| "SHIFT1" | "Shift 1" | "String" | "No" | null |
| "SHIFT1N" | "Shift 1 (N)" | "Float64" | "No" | null |
| "CRIT1" | "Analysis Criterion 1" | "String" | "No" | null |
| "CRIT1FL" | "Criterion 1 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT1FN" | "Criterion 1 Evaluation Result Flag (N)" | "Float64" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotadam
tbl_explorer(cdiscpilotadam.adlbhy.head(10))PolarsRows10Columns43 | |||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
SUBJID str |
USUBJID str |
TRTP str |
TRTPN f64 |
TRTA str |
TRTAN f64 |
TRTSDT date |
TRTEDT date |
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 date |
VISIT str |
VISITNUM f64 |
PARAMTYP str |
PARAM str |
PARAMCD str |
PARAMN f64 |
PARCAT1 str |
AVAL f64 |
BASE f64 |
A1LO f64 |
A1HI f64 |
R2A1LO f64 |
R2A1HI f64 |
BR2A1LO f64 |
BR2A1HI f64 |
ABLFL str |
SHIFT1 str |
SHIFT1N f64 |
CRIT1 str |
CRIT1FL str |
CRIT1FN f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 2013-12-26 | SCREENING 1 | 1 | None | Alanine Aminotransferase (U/L) | ALT | 1 | CHEM | 27 | 27 | 6 | 34 | 4.5 | 0.794117647059 | 4.5 | 0.794117647059 | Y | None | None | R2A1HI > 1.5 | N | 0 |
| 1 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 2013-12-26 | SCREENING 1 | 1 | None | Aspartate Aminotransferase (U/L) | AST | 2 | CHEM | 40 | 40 | 9 | 34 | 4.44444444444 | 1.17647058824 | 4.44444444444 | 1.17647058824 | Y | None | None | R2A1HI > 1.5 | N | 0 |
| 2 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | -7 | 2013-12-26 | SCREENING 1 | 1 | None | Bilirubin (umol/L) | BILI | 3 | CHEM | 10.26 | 10.26 | 3 | 21 | 3.42 | 0.488571428571 | 3.42 | 0.488571428571 | Y | None | None | R2A1HI > 1.5 | N | 0 |
| 3 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | None | None | None | None | DERIVED | Bilirubin 1.5 x ULN | BILIHY | 4 | HYLAW | 0 | 0 | None | None | None | None | None | None | Y | Normal to Normal | 1 | None | None | None |
| 4 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | None | None | None | None | DERIVED | Transaminase 1.5 x ULN | TRANSHY | 5 | HYLAW | 0 | 0 | None | None | None | None | None | None | Y | Normal to Normal | 1 | None | None | None |
| 5 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Baseline | 0 | None | None | None | None | DERIVED | Total Bili 1.5 x ULN and Transaminase 1.5 x ULN | HYLAW | 6 | HYLAW | 0 | 0 | None | None | None | None | None | None | Y | Normal to Normal | 1 | None | None | None |
| 6 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Week 2 | 2 | 15 | 2014-01-16 | WEEK 2 | 4 | None | Alanine Aminotransferase (U/L) | ALT | 1 | CHEM | 41 | 27 | 6 | 34 | 6.83333333333 | 1.20588235294 | 4.5 | 0.794117647059 | None | None | None | R2A1HI > 1.5 | N | 0 |
| 7 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Week 2 | 2 | 15 | 2014-01-16 | WEEK 2 | 4 | None | Aspartate Aminotransferase (U/L) | AST | 2 | CHEM | 33 | 40 | 9 | 34 | 3.66666666667 | 0.970588235294 | 4.44444444444 | 1.17647058824 | None | None | None | R2A1HI > 1.5 | N | 0 |
| 8 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Week 2 | 2 | 15 | 2014-01-16 | WEEK 2 | 4 | None | Bilirubin (umol/L) | BILI | 3 | CHEM | 8.55 | 10.26 | 3 | 21 | 2.85 | 0.407142857143 | 3.42 | 0.488571428571 | None | None | None | R2A1HI > 1.5 | N | 0 |
| 9 | CDISCPILOT01 | 1015 | 01-701-1015 | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 63 | <65 | 1 | WHITE | 1 | F | Y | None | Y | Week 2 | 2 | None | None | None | None | DERIVED | Bilirubin 1.5 x ULN | BILIHY | 4 | HYLAW | 0 | 0 | None | None | None | None | None | None | None | Normal to Normal | 1 | None | None | None |