from pharmadata import cdiscpilotadam
meta = cdiscpilotadam.meta('advs')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 32,139 Columns: 35advs
advs
Vital Signs Analysis Dataset
Structure: one record per subject per parameter per analysis visit per analysis timepoint
Variables
Show variable specs
shape: (35, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | null |
| "STUDYID" | "Study Identifier" | "String" | "No" | null |
| "SITEID" | "Study Site Identifier" | "String" | "No" | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | "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 |
| "SAFFL" | "Safety Population Flag" | "String" | "No" | null |
| "TRTSDT" | "Date of First Exposure to Treatment" | "Date" | "No" | null |
| "TRTEDT" | "Date of Last Exposure to Treatment" | "Date" | "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 |
| "PARAMCD" | "Parameter Code" | "String" | "No" | null |
| "PARAM" | "Parameter" | "String" | "No" | null |
| "PARAMN" | "Parameter (N)" | "Float64" | "No" | null |
| "ADT" | "Analysis Date" | "Date" | "No" | null |
| "ADY" | "Analysis Relative Day" | "Float64" | "No" | null |
| "ATPTN" | "Analysis Timepoint (N)" | "Float64" | "No" | null |
| "ATPT" | "Analysis Timepoint" | "String" | "No" | null |
| "AVISIT" | "Analysis Visit" | "String" | "No" | null |
| "AVISITN" | "Analysis Visit (N)" | "Float64" | "No" | null |
| "AVAL" | "Analysis Value" | "Float64" | "No" | null |
| "BASE" | "Baseline Value" | "Float64" | "No" | null |
| "BASETYPE" | "Baseline Type" | "String" | "No" | null |
| "CHG" | "Change from Baseline" | "Float64" | "No" | null |
| "PCHG" | "Percent Change from Baseline" | "Float64" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VSSEQ" | "Sequence Number" | "Float64" | "No" | null |
| "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null |
| "ABLFL" | "Baseline Record Flag" | "String" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotadam
tbl_explorer(cdiscpilotadam.advs.head(10))PolarsRows10Columns35 | |||||||||||||||||||||||||||||||||||
STUDYID str |
SITEID str |
USUBJID str |
AGE f64 |
AGEGR1 str |
AGEGR1N f64 |
RACE str |
RACEN f64 |
SEX str |
SAFFL str |
TRTSDT date |
TRTEDT date |
TRTP str |
TRTPN f64 |
TRTA str |
TRTAN f64 |
PARAMCD str |
PARAM str |
PARAMN f64 |
ADT date |
ADY f64 |
ATPTN f64 |
ATPT str |
AVISIT str |
AVISITN f64 |
AVAL f64 |
BASE f64 |
BASETYPE str |
CHG f64 |
PCHG f64 |
VISITNUM f64 |
VISIT str |
VSSEQ f64 |
ANL01FL str |
ABLFL str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2013-12-26 | -7 | 815 | AFTER LYING DOWN FOR 5 MINUTES | None | None | 64 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 8 | 14.2857142857 | 1 | SCREENING 1 | 1 | None | None |
| 1 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2013-12-31 | -2 | 815 | AFTER LYING DOWN FOR 5 MINUTES | None | None | 68 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 12 | 21.4285714286 | 2 | SCREENING 2 | 4 | None | None |
| 2 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-01-02 | 1 | 815 | AFTER LYING DOWN FOR 5 MINUTES | Baseline | 0 | 56 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 0 | 0 | 3 | BASELINE | 7 | Y | Y |
| 3 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-01-14 | 13 | 815 | AFTER LYING DOWN FOR 5 MINUTES | None | None | 67 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 11 | 19.6428571429 | 3.5 | AMBUL ECG PLACEMENT | 10 | None | None |
| 4 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-01-16 | 15 | 815 | AFTER LYING DOWN FOR 5 MINUTES | Week 2 | 2 | 56 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 0 | 0 | 4 | WEEK 2 | 13 | Y | None |
| 5 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-01-30 | 29 | 815 | AFTER LYING DOWN FOR 5 MINUTES | Week 4 | 4 | 64 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 8 | 14.2857142857 | 5 | WEEK 4 | 16 | Y | None |
| 6 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-02-01 | 31 | 815 | AFTER LYING DOWN FOR 5 MINUTES | None | None | 72 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 16 | 28.5714285714 | 6 | AMBUL ECG REMOVAL | 19 | None | None |
| 7 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-02-12 | 42 | 815 | AFTER LYING DOWN FOR 5 MINUTES | Week 6 | 6 | 55 | 56 | AFTER LYING DOWN FOR 5 MINUTES | -1 | -1.78571428571 | 7 | WEEK 6 | 22 | Y | None |
| 8 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-03-05 | 63 | 815 | AFTER LYING DOWN FOR 5 MINUTES | Week 8 | 8 | 67 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 11 | 19.6428571429 | 8 | WEEK 8 | 25 | Y | None |
| 9 | CDISCPILOT01 | 701 | 01-701-1015 | 63 | <65 | 1 | WHITE | 1 | F | Y | 2014-01-02 | 2014-07-02 | Placebo | 0 | Placebo | 0 | DIABP | Diastolic Blood Pressure (mmHg) | 2 | 2014-03-26 | 84 | 815 | AFTER LYING DOWN FOR 5 MINUTES | Week 12 | 12 | 68 | 56 | AFTER LYING DOWN FOR 5 MINUTES | 12 | 21.4285714286 | 9 | WEEK 12 | 28 | Y | None |