from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adlb_metabolic')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 371 Columns: 43adlb_metabolic
adlb_metabolic
Laboratory Analysis for Metabolic
Structure: One or more records per subject per analysis parameter per analysis timepoint
Variables
Show variable specs
shape: (43, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | null |
| "STUDYID" | "Study Identifier" | "String" | "Yes" | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | "Yes" | null |
| "DOMAIN" | "Domain Abbreviation" | "String" | "No" | null |
| "TRT01P" | "Planned Treatment for Period 01" | "String" | "No" | null |
| "TRT01A" | "Actual Treatment for Period 01" | "String" | "No" | null |
| "TRTSDT" | "Date of First Exposure to Treatment" | "Date" | "No" | null |
| "TRTEDT" | "Date of Last Exposure to Treatment" | "Date" | "No" | null |
| "ADT" | "Analysis Date" | "Date" | "No" | null |
| "ADY" | "Analysis Relative Day" | "Float64" | "No" | null |
| "AVISIT" | "Analysis Visit" | "String" | "No" | null |
| "AVISITN" | "Analysis Visit (N)" | "Float64" | "No" | null |
| "PARAM" | "Parameter" | "String" | "Yes" | null |
| "PARAMCD" | "Parameter Code" | "String" | "Yes" | null |
| "PARAMN" | "Parameter (N)" | "Float64" | "No" | null |
| "PARCAT1" | "Parameter Category 1" | "String" | "No" | null |
| "PARCAT2" | "Parameter Category 2" | "String" | "No" | null |
| "AVAL" | "Analysis Value" | "Float64" | "No" | null |
| "AVALC" | "Analysis Value (C)" | "String" | "No" | null |
| "ANRLO" | "Analysis Normal Range Lower Limit" | "Float64" | "No" | null |
| "ANRHI" | "Analysis Normal Range Upper Limit" | "Float64" | "No" | null |
| "LBSEQ" | "Sequence Number" | "Int32" | "No" | null |
| "LBTESTCD" | "Lab Test or Examination Short Name" | "String" | "No" | null |
| "LBTEST" | "Lab Test or Examination Name" | "String" | "No" | null |
| "LBCAT" | "Category for Lab Test" | "String" | "No" | null |
| "LBORRES" | "Result or Finding in Original Units" | "String" | "No" | null |
| "LBORRESU" | "Original Units" | "String" | "No" | null |
| "LBORNRLO" | "Reference Range Lower Limit in Orig Unit" | "String" | "No" | null |
| "LBORNRHI" | "Reference Range Upper Limit in Orig Unit" | "String" | "No" | null |
| "LBSTRESC" | "Character Result/Finding in Std Format" | "String" | "No" | null |
| "LBSTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "LBSTRESU" | "Standard Units" | "String" | "No" | null |
| "LBSTNRLO" | "Reference Range Lower Limit-Std Units" | "Float64" | "No" | null |
| "LBSTNRHI" | "Reference Range Upper Limit-Std Units" | "Float64" | "No" | null |
| "LBNRIND" | "Reference Range Indicator" | "String" | "No" | null |
| "LBBLFL" | "Baseline Flag" | "String" | "No" | null |
| "LBFAST" | "Fasting Status" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | "No" | null |
| "LBDTC" | "Date/Time of Specimen Collection" | "String" | "No" | null |
| "LBDY" | "Study Day of Specimen Collection" | "Float64" | "No" | null |
| "BMI" | "Body Mass Index (kg/m2)" | "Float64" | "No" | null |
| "WSTCIR" | "Waist Circumference (cm)" | "Float64" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import pharmaverseadam
tbl_explorer(pharmaverseadam.adlb_metabolic.head(10))PolarsRows10Columns43 | |||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
USUBJID str |
DOMAIN str |
TRT01P str |
TRT01A str |
TRTSDT date |
TRTEDT date |
ADT date |
ADY f64 |
AVISIT str |
AVISITN f64 |
PARAM str |
PARAMCD str |
PARAMN f64 |
PARCAT1 str |
PARCAT2 str |
AVAL f64 |
AVALC str |
ANRLO f64 |
ANRHI f64 |
LBSEQ i32 |
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 |
LBFAST str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
LBDTC str |
LBDY f64 |
BMI f64 |
WSTCIR f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 01-701-1015 | LB | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2013-12-26 | -7 | Baseline | 0 | Insulin (mIU/L) | INSULIN | 8 | CHEMISTRY | CV | 14.4 | None | 2 | 25 | 8 | INSULIN | Insulin | CHEMISTRY | 14.4 | mIU/L | 2 | 25 | 86.4 | 86.4 | pmol/L | 12 | 150 | NORMAL | Y | Y | 1 | SCREENING 1 | -7 | 2013-12-26T14:45 | -7 | 38.1050023495 | 99 |
| 1 | CDISCPILOT01 | 01-701-1023 | LB | Placebo | Placebo | 2012-08-05 | 2012-09-01 | 2012-07-22 | -14 | Baseline | 0 | Insulin (mIU/L) | INSULIN | 8 | CHEMISTRY | CV | 27.5 | None | 2 | 25 | 8 | INSULIN | Insulin | CHEMISTRY | 27.5 | mIU/L | 2 | 25 | 165 | 165 | pmol/L | 12 | 150 | HIGH | Y | Y | 1 | SCREENING 1 | -7 | 2012-07-22T12:13 | -14 | 38.5525716887 | 106 |
| 2 | CDISCPILOT01 | 01-701-1028 | LB | Insulin | Insulin | 2013-07-19 | 2014-01-14 | 2013-07-11 | -8 | Baseline | 0 | Insulin (mIU/L) | INSULIN | 8 | CHEMISTRY | CV | 26.1 | None | 2 | 25 | 8 | INSULIN | Insulin | CHEMISTRY | 26.1 | mIU/L | 2 | 25 | 156.6 | 156.6 | pmol/L | 12 | 150 | HIGH | Y | Y | 1 | SCREENING 1 | -7 | 2013-07-11T12:02 | -8 | 37.6330050235 | 105 |
| 3 | CDISCPILOT01 | 01-701-1033 | LB | Insulin | Insulin | 2014-03-18 | 2014-03-31 | 2014-03-10 | -8 | Baseline | 0 | Insulin (mIU/L) | INSULIN | 8 | CHEMISTRY | CV | 30.7 | None | 2 | 25 | 8 | INSULIN | Insulin | CHEMISTRY | 30.7 | mIU/L | 2 | 25 | 184.2 | 184.2 | pmol/L | 12 | 150 | HIGH | Y | Y | 1 | SCREENING 1 | -7 | 2014-03-10T12:31 | -8 | 40.7867328954 | 108 |
| 4 | CDISCPILOT01 | 01-701-1034 | LB | Insulin | Insulin | 2014-07-01 | 2014-12-30 | 2014-06-24 | -7 | Baseline | 0 | Insulin (mIU/L) | INSULIN | 8 | CHEMISTRY | CV | 19.7 | None | 2 | 25 | 8 | INSULIN | Insulin | CHEMISTRY | 19.7 | mIU/L | 2 | 25 | 118.2 | 118.2 | pmol/L | 12 | 150 | NORMAL | Y | Y | 1 | SCREENING 1 | -7 | 2014-06-24T15:30 | -7 | 40.6940419286 | 115 |
| 5 | CDISCPILOT01 | 01-701-1015 | LB | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2013-12-26 | -7 | Baseline | 0 | Triglycerides (mg/dL) | TRIG | 9 | CHEMISTRY | CV | 111.1 | None | 0 | 150 | 9 | TRIG | Triglycerides | CHEMISTRY | 111.1 | mg/dL | 0 | 150 | 1.254319 | 1.254319 | mmol/L | 0 | 1.6935 | NORMAL | Y | Y | 1 | SCREENING 1 | -7 | 2013-12-26T14:45 | -7 | 38.1050023495 | 99 |
| 6 | CDISCPILOT01 | 01-701-1023 | LB | Placebo | Placebo | 2012-08-05 | 2012-09-01 | 2012-07-22 | -14 | Baseline | 0 | Triglycerides (mg/dL) | TRIG | 9 | CHEMISTRY | CV | 49.6 | None | 0 | 150 | 9 | TRIG | Triglycerides | CHEMISTRY | 49.6 | mg/dL | 0 | 150 | 0.559984 | 0.559984 | mmol/L | 0 | 1.6935 | NORMAL | Y | Y | 1 | SCREENING 1 | -7 | 2012-07-22T12:13 | -14 | 38.5525716887 | 106 |
| 7 | CDISCPILOT01 | 01-701-1028 | LB | Insulin | Insulin | 2013-07-19 | 2014-01-14 | 2013-07-11 | -8 | Baseline | 0 | Triglycerides (mg/dL) | TRIG | 9 | CHEMISTRY | CV | 45 | None | 0 | 150 | 9 | TRIG | Triglycerides | CHEMISTRY | 45 | mg/dL | 0 | 150 | 0.50805 | 0.50805 | mmol/L | 0 | 1.6935 | NORMAL | Y | Y | 1 | SCREENING 1 | -7 | 2013-07-11T12:02 | -8 | 37.6330050235 | 105 |
| 8 | CDISCPILOT01 | 01-701-1033 | LB | Insulin | Insulin | 2014-03-18 | 2014-03-31 | 2014-03-10 | -8 | Baseline | 0 | Triglycerides (mg/dL) | TRIG | 9 | CHEMISTRY | CV | 200.2 | None | 0 | 150 | 9 | TRIG | Triglycerides | CHEMISTRY | 200.2 | mg/dL | 0 | 150 | 2.260258 | 2.260258 | mmol/L | 0 | 1.6935 | HIGH | Y | Y | 1 | SCREENING 1 | -7 | 2014-03-10T12:31 | -8 | 40.7867328954 | 108 |
| 9 | CDISCPILOT01 | 01-701-1034 | LB | Insulin | Insulin | 2014-07-01 | 2014-12-30 | 2014-06-24 | -7 | Baseline | 0 | Triglycerides (mg/dL) | TRIG | 9 | CHEMISTRY | CV | 234.8 | None | 0 | 150 | 9 | TRIG | Triglycerides | CHEMISTRY | 234.8 | mg/dL | 0 | 150 | 2.650892 | 2.650892 | mmol/L | 0 | 1.6935 | HIGH | Y | Y | 1 | SCREENING 1 | -7 | 2014-06-24T15:30 | -7 | 40.6940419286 | 115 |