from pharmadata import cdiscpilotadam
meta = cdiscpilotadam.meta('adsl')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 254 Columns: 49adsl
adsl
Subject-Level Analysis
Structure: one record per subject
Variables
Show variable specs
shape: (49, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | null |
| "STUDYID" | "Study Identifier" | "String" | "No" | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | "No" | null |
| "SUBJID" | "Subject Identifier for the Study" | "String" | "No" | null |
| "SITEID" | "Study Site Identifier" | "String" | "No" | null |
| "SITEGR1" | "Pooled Site Group 1" | "String" | "No" | null |
| "ARM" | "Description of Planned Arm" | "String" | "No" | null |
| "TRT01P" | "Planned Treatment for Period 01" | "String" | "No" | null |
| "TRT01PN" | "Planned Treatment for Period 01 (N)" | "Float64" | "No" | null |
| "TRT01A" | "Actual Treatment for Period 01" | "String" | "No" | null |
| "TRT01AN" | "Actual Treatment for Period 01 (N)" | "Float64" | "No" | null |
| "TRTSDT" | "Date of First Exposure to Treatment" | "Date" | "No" | null |
| "TRTEDT" | "Date of Last Exposure to Treatment" | "Date" | "No" | null |
| "TRTDURD" | "Total Treatment Duration (Days)" | "Float64" | "No" | null |
| "AVGDD" | "Avg Daily Dose (as planned)" | "Float64" | "No" | null |
| "CUMDOSE" | "Cumulative Dose (as planned)" | "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 |
| "AGEU" | "Age Units" | "String" | "No" | null |
| "RACE" | "Race" | "String" | "No" | null |
| "RACEN" | "Race (N)" | "Float64" | "No" | null |
| "SEX" | "Sex" | "String" | "No" | null |
| "ETHNIC" | "Ethnicity" | "String" | "No" | null |
| "SAFFL" | "Safety Population Flag" | "String" | "No" | null |
| "ITTFL" | "Intent-To-Treat Population Flag" | "String" | "No" | null |
| "EFFFL" | "Efficacy Population Flag" | "String" | "No" | null |
| "COMP8FL" | "Completers of Week 8 Population Flag" | "String" | "No" | null |
| "COMP16FL" | "Completers of Week 16 Population Flag" | "String" | "No" | null |
| "COMP24FL" | "Completers of Week 24 Population Flag" | "String" | "No" | null |
| "DISCONFL" | "Did the Subject Discontinue the Study?" | "String" | "No" | null |
| "DSRAEFL" | "Discontinued due to AE?" | "String" | "No" | null |
| "DTHFL" | "Subject Died?" | "String" | "No" | null |
| "BMIBL" | "Baseline BMI (kg/m^2)" | "Float64" | "No" | null |
| "BMIBLGR1" | "Pooled Baseline BMI Group 1" | "String" | "No" | null |
| "HEIGHTBL" | "Baseline Height (cm)" | "Float64" | "No" | null |
| "WEIGHTBL" | "Baseline Weight (kg)" | "Float64" | "No" | null |
| "EDUCLVL" | "Years of Education" | "Float64" | "No" | null |
| "DISONSDT" | "Date of Onset of Disease" | "Date" | "No" | null |
| "DURDIS" | "Duration of Disease (Months)" | "Float64" | "No" | null |
| "DURDSGR1" | "Pooled Disease Duration Group 1" | "String" | "No" | null |
| "VISIT1DT" | "Date of Visit 1" | "Date" | "No" | null |
| "RFSTDTC" | "Subject Reference Start Date/Time" | "String" | "No" | null |
| "RFENDTC" | "Subject Reference End Date/Time" | "String" | "No" | null |
| "VISNUMEN" | "End of Trt Visit (Vis 12 or Early Term.)" | "Float64" | "No" | null |
| "RFENDT" | "Date of Discontinuation/Completion" | "Date" | "No" | null |
| "DCDECOD" | "Standardized Disposition Term" | "String" | "No" | null |
| "EOSSTT" | "End of Study Status" | "String" | "No" | null |
| "DCSREAS" | "Reason for Discontinuation from Study" | "String" | "No" | null |
| "MMSETOT" | "MMSE Total" | "Float64" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotadam
tbl_explorer(cdiscpilotadam.adsl.head(10))PolarsRows10Columns49 | |||||||||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
USUBJID str |
SUBJID str |
SITEID str |
SITEGR1 str |
ARM str |
TRT01P str |
TRT01PN f64 |
TRT01A str |
TRT01AN f64 |
TRTSDT date |
TRTEDT date |
TRTDURD f64 |
AVGDD f64 |
CUMDOSE f64 |
AGE f64 |
AGEGR1 str |
AGEGR1N f64 |
AGEU str |
RACE str |
RACEN f64 |
SEX str |
ETHNIC str |
SAFFL str |
ITTFL str |
EFFFL str |
COMP8FL str |
COMP16FL str |
COMP24FL str |
DISCONFL str |
DSRAEFL str |
DTHFL str |
BMIBL f64 |
BMIBLGR1 str |
HEIGHTBL f64 |
WEIGHTBL f64 |
EDUCLVL f64 |
DISONSDT date |
DURDIS f64 |
DURDSGR1 str |
VISIT1DT date |
RFSTDTC str |
RFENDTC str |
VISNUMEN f64 |
RFENDT date |
DCDECOD str |
EOSSTT str |
DCSREAS str |
MMSETOT f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | 701 | Placebo | Placebo | 0 | Placebo | 0 | 2014-01-02 | 2014-07-02 | 182 | 0 | 0 | 63 | <65 | 1 | YEARS | WHITE | 1 | F | HISPANIC OR LATINO | Y | Y | Y | Y | Y | Y | None | None | None | 25.1 | 25-<30 | 147.3 | 54.4 | 16 | 2010-04-30 | 43.9 | >=12 | 2013-12-26 | 2014-01-02 | 2014-07-02 | 12 | 2014-07-02 | COMPLETED | COMPLETED | None | 23 |
| 1 | CDISCPILOT01 | 01-701-1023 | 1023 | 701 | 701 | Placebo | Placebo | 0 | Placebo | 0 | 2012-08-05 | 2012-09-01 | 28 | 0 | 0 | 64 | <65 | 1 | YEARS | WHITE | 1 | M | HISPANIC OR LATINO | Y | Y | Y | N | N | N | Y | Y | None | 30.4 | >=30 | 162.6 | 80.3 | 14 | 2006-03-11 | 76.4 | >=12 | 2012-07-22 | 2012-08-05 | 2012-09-02 | 5 | 2012-09-02 | ADVERSE EVENT | DISCONTINUED | Adverse Event | 23 |
| 2 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | 701 | Xanomeline High Dose | Xanomeline High Dose | 81 | Xanomeline High Dose | 81 | 2013-07-19 | 2014-01-14 | 180 | 77.7 | 13986 | 71 | 65-80 | 2 | YEARS | WHITE | 1 | M | NOT HISPANIC OR LATINO | Y | Y | Y | Y | Y | Y | None | None | None | 31.4 | >=30 | 177.8 | 99.3 | 16 | 2009-12-16 | 42.8 | >=12 | 2013-07-11 | 2013-07-19 | 2014-01-14 | 12 | 2014-01-14 | COMPLETED | COMPLETED | None | 23 |
| 3 | CDISCPILOT01 | 01-701-1033 | 1033 | 701 | 701 | Xanomeline Low Dose | Xanomeline Low Dose | 54 | Xanomeline Low Dose | 54 | 2014-03-18 | 2014-03-31 | 14 | 54 | 756 | 74 | 65-80 | 2 | YEARS | WHITE | 1 | M | NOT HISPANIC OR LATINO | Y | Y | Y | N | N | N | Y | None | None | 28.8 | 25-<30 | 175.3 | 88.5 | 12 | 2009-08-02 | 55.3 | >=12 | 2014-03-10 | 2014-03-18 | 2014-04-14 | 5 | 2014-04-14 | STUDY TERMINATED BY SPONSOR | DISCONTINUED | Sponsor Decision | 23 |
| 4 | CDISCPILOT01 | 01-701-1034 | 1034 | 701 | 701 | Xanomeline High Dose | Xanomeline High Dose | 81 | Xanomeline High Dose | 81 | 2014-07-01 | 2014-12-30 | 183 | 76.9 | 14067 | 77 | 65-80 | 2 | YEARS | WHITE | 1 | F | NOT HISPANIC OR LATINO | Y | Y | Y | Y | Y | Y | None | None | None | 26.1 | 25-<30 | 154.9 | 62.6 | 9 | 2011-09-29 | 32.9 | >=12 | 2014-06-24 | 2014-07-01 | 2014-12-30 | 12 | 2014-12-30 | COMPLETED | COMPLETED | None | 21 |
| 5 | CDISCPILOT01 | 01-701-1047 | 1047 | 701 | 701 | Placebo | Placebo | 0 | Placebo | 0 | 2013-02-12 | 2013-03-09 | 26 | 0 | 0 | 85 | >80 | 3 | YEARS | WHITE | 1 | F | NOT HISPANIC OR LATINO | Y | Y | Y | N | N | N | Y | Y | None | 30.4 | >=30 | 148.6 | 67.1 | 8 | 2009-07-26 | 42 | >=12 | 2013-01-22 | 2013-02-12 | 2013-03-29 | 6 | 2013-03-29 | ADVERSE EVENT | DISCONTINUED | Adverse Event | 23 |
| 6 | CDISCPILOT01 | 01-701-1097 | 1097 | 701 | 701 | Xanomeline Low Dose | Xanomeline Low Dose | 54 | Xanomeline Low Dose | 54 | 2014-01-01 | 2014-07-09 | 190 | 54 | 10260 | 68 | 65-80 | 2 | YEARS | WHITE | 1 | M | NOT HISPANIC OR LATINO | Y | Y | Y | Y | Y | Y | None | None | None | 27.3 | 25-<30 | 168.9 | 78 | 18 | 2005-09-22 | 99.1 | >=12 | 2013-12-23 | 2014-01-01 | 2014-07-09 | 12 | 2014-07-09 | COMPLETED | COMPLETED | None | 10 |
| 7 | CDISCPILOT01 | 01-701-1111 | 1111 | 701 | 701 | Xanomeline Low Dose | Xanomeline Low Dose | 54 | Xanomeline Low Dose | 54 | 2012-09-07 | 2012-09-16 | 10 | 54 | 540 | 81 | >80 | 3 | YEARS | WHITE | 1 | F | NOT HISPANIC OR LATINO | Y | Y | Y | N | N | N | Y | Y | None | 23.9 | <25 | 158.2 | 59.9 | 22 | 2009-04-04 | 40.7 | >=12 | 2012-08-25 | 2012-09-07 | 2012-09-17 | 4 | 2012-09-17 | ADVERSE EVENT | DISCONTINUED | Adverse Event | 23 |
| 8 | CDISCPILOT01 | 01-701-1115 | 1115 | 701 | 701 | Xanomeline Low Dose | Xanomeline Low Dose | 54 | Xanomeline Low Dose | 54 | 2012-11-30 | 2013-01-23 | 55 | 54 | 2970 | 84 | >80 | 3 | YEARS | WHITE | 1 | M | NOT HISPANIC OR LATINO | Y | Y | Y | Y | N | N | Y | Y | None | 23.9 | <25 | 181.6 | 78.9 | 12 | 2004-05-28 | 101.9 | >=12 | 2012-11-23 | 2012-11-30 | 2013-01-23 | 8 | 2013-01-23 | ADVERSE EVENT | DISCONTINUED | Adverse Event | 20 |
| 9 | CDISCPILOT01 | 01-701-1118 | 1118 | 701 | 701 | Placebo | Placebo | 0 | Placebo | 0 | 2014-03-12 | 2014-09-09 | 182 | 0 | 0 | 52 | <65 | 1 | YEARS | WHITE | 1 | M | NOT HISPANIC OR LATINO | Y | Y | Y | Y | Y | Y | None | None | None | 21.9 | <25 | 180.3 | 71.2 | 14 | 2010-06-24 | 44.2 | >=12 | 2014-02-27 | 2014-03-12 | 2014-09-09 | 12 | 2014-09-09 | COMPLETED | COMPLETED | None | 20 |