from pharmadata import cdiscpilotadam
meta = cdiscpilotadam.meta('adnpix')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 31,140 Columns: 41adnpix
adnpix
NPI-X Item Analysis Data
Structure: one record per subject per parameter per analysis visit per analysis date
Variables
Show variable specs
shape: (41, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | null |
| "STUDYID" | "Study Identifier" | "String" | "No" | null |
| "SITEID" | "Study Site Identifier" | "String" | "No" | null |
| "SITEGR1" | "Pooled Site Group 1" | "String" | "No" | null |
| "USUBJID" | "Unique Subject Identifier" | "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 |
| "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 |
| "ITTFL" | "Intent-to-Treat Population Flag" | "String" | "No" | null |
| "EFFFL" | "Efficacy Population Flag" | "String" | "No" | null |
| "COMP24FL" | "Completers of Week 24 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 |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "PARAM" | "Parameter" | "String" | "No" | null |
| "PARAMCD" | "Parameter Code" | "String" | "No" | null |
| "PARAMN" | "Parameter (N)" | "Float64" | "No" | null |
| "PARAMTYP" | "Parameter Type" | "String" | "No" | null |
| "AVAL" | "Analysis Value" | "Float64" | "No" | null |
| "BASE" | "Baseline Value" | "Float64" | "No" | null |
| "CHG" | "Change from Baseline" | "Float64" | "No" | null |
| "PCHG" | "Percent Change from Baseline" | "Float64" | "No" | null |
| "ABLFL" | "Baseline Record Flag" | "String" | "No" | null |
| "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null |
| "DTYPE" | "Derivation Type" | "String" | "No" | null |
| "AWRANGE" | "Analysis Window Valid Relative Range" | "String" | "No" | null |
| "AWTARGET" | "Analysis Window Target" | "Float64" | "No" | null |
| "AWTDIFF" | "Analysis Window Diff from Target" | "Float64" | "No" | null |
| "AWLO" | "Analysis Window Beginning Timepoint" | "Float64" | "No" | null |
| "AWHI" | "Analysis Window Ending Timepoint" | "Float64" | "No" | null |
| "AWU" | "Analysis Window Unit" | "String" | "No" | null |
| "QSSEQ" | "Sequence Number" | "Float64" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotadam
tbl_explorer(cdiscpilotadam.adnpix.head(10))PolarsRows10Columns41 | |||||||||||||||||||||||||||||||||||||||||
STUDYID str |
SITEID str |
SITEGR1 str |
USUBJID str |
TRTSDT date |
TRTEDT date |
TRTP str |
TRTPN f64 |
AGE f64 |
AGEGR1 str |
AGEGR1N f64 |
RACE str |
RACEN f64 |
SEX str |
ITTFL str |
EFFFL str |
COMP24FL str |
AVISIT str |
AVISITN f64 |
ADY f64 |
ADT date |
VISITNUM f64 |
VISIT str |
PARAM str |
PARAMCD str |
PARAMN f64 |
PARAMTYP str |
AVAL f64 |
BASE f64 |
CHG f64 |
PCHG f64 |
ABLFL str |
ANL01FL str |
DTYPE str |
AWRANGE str |
AWTARGET f64 |
AWTDIFF f64 |
AWLO f64 |
AWHI f64 |
AWU str |
QSSEQ f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Baseline | 0 | 1 | 2014-01-02 | 3 | BASELINE | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | Y | Y | None | <= 1 | 1 | 0 | None | 1 | DAYS | 3002 |
| 1 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 2 | 2 | 15 | 2014-01-16 | 4 | WEEK 2 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 2 - 21 | 14 | 1 | 2 | 21 | DAYS | 3027 |
| 2 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 4 | 4 | 29 | 2014-01-30 | 5 | WEEK 4 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 22 - 35 | 28 | 1 | 22 | 35 | DAYS | 3052 |
| 3 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 6 | 6 | 42 | 2014-02-12 | 7 | WEEK 6 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 36 - 49 | 42 | 0 | 36 | 49 | DAYS | 3077 |
| 4 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 8 | 8 | 63 | 2014-03-05 | 8 | WEEK 8 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 50 - 63 | 56 | 7 | 50 | 63 | DAYS | 3102 |
| 5 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 12 | 12 | 84 | 2014-03-26 | 9 | WEEK 12 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 78 - 91 | 84 | 0 | 78 | 91 | DAYS | 3127 |
| 6 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 14 | 14 | 98 | 2014-04-09 | 9.1 | WEEK 14 (T) | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 92 - 105 | 98 | 0 | 92 | 105 | DAYS | 3152 |
| 7 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 18 | 18 | 126 | 2014-05-07 | 10 | WEEK 16 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 120 - 133 | 126 | 0 | 120 | 133 | DAYS | 3177 |
| 8 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 20 | 20 | 140 | 2014-05-21 | 11 | WEEK 20 | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 134 - 147 | 140 | 0 | 134 | 147 | DAYS | 3202 |
| 9 | CDISCPILOT01 | 701 | 701 | 01-701-1015 | 2014-01-02 | 2014-07-02 | Placebo | 0 | 63 | <65 | 1 | WHITE | 1 | F | Y | Y | Y | Week 22 | 22 | 154 | 2014-06-04 | 11.1 | WEEK 22 (T) | NPI-X Item A (Delusion) Score | NPITM01S | 1 | None | 0 | 0 | 0 | None | None | Y | None | 148 - 161 | 154 | 0 | 148 | 161 | DAYS | 3227 |