from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('ex')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 591 Columns: 18
ex
Structure: One record per constant dosing interval per subject
from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('ex')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 591 Columns: 18
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | str |
| "STUDYID" | "Study Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "DOMAIN" | "Domain Abbreviation" | "String" | "Yes" | "IDENTIFIER" |
| "USUBJID" | "Unique Subject Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "EXSEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "EXTRT" | "Name of Treatment" | "String" | "Yes" | "TOPIC" |
| "EXDOSE" | "Dose" | "Float64" | "No" | "RECORD QUALIFIER" |
| "EXDOSU" | "Dose Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "EXDOSFRM" | "Dose Form" | "String" | "No" | "RECORD QUALIFIER" |
| "EXDOSFRQ" | "Dosing Frequency per Interval" | "String" | "No" | "VARIABLE QUALIFIER" |
| "EXROUTE" | "Route of Administration" | "String" | "No" | "VARIABLE QUALIFIER" |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | "TIMING" |
| "VISIT" | "Visit Name" | "String" | "No" | "TIMING" |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | "No" | "TIMING" |
| "EPOCH" | "Epoch" | "String" | "No" | "TIMING" |
| "EXSTDTC" | "Start Date/Time of Treatment" | "String" | "No" | "TIMING" |
| "EXENDTC" | "End Date/Time of Treatment" | "String" | "No" | "TIMING" |
| "EXSTDY" | "Study Day of Start of Treatment" | "Float64" | "No" | "TIMING" |
| "EXENDY" | "Study Day of End of Treatment" | "Float64" | "No" | "TIMING" |
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.ex.head(10))PolarsRows10Columns18 | ||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
EXSEQ f64 |
EXTRT str |
EXDOSE f64 |
EXDOSU str |
EXDOSFRM str |
EXDOSFRQ str |
EXROUTE str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
EPOCH str |
EXSTDTC str |
EXENDTC str |
EXSTDY f64 |
EXENDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | EX | 01-701-1015 | 1 | PLACEBO | 0 | mg | PATCH | QD | TRANSDERMAL | 3 | BASELINE | 1 | TREATMENT | 2014-01-02 | 2014-01-16 | 1 | 15 |
| 1 | CDISCPILOT01 | EX | 01-701-1015 | 2 | PLACEBO | 0 | mg | PATCH | QD | TRANSDERMAL | 4 | WEEK 2 | 14 | TREATMENT | 2014-01-17 | 2014-06-18 | 16 | 168 |
| 2 | CDISCPILOT01 | EX | 01-701-1015 | 3 | PLACEBO | 0 | mg | PATCH | QD | TRANSDERMAL | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-19 | 2014-07-02 | 169 | 182 |
| 3 | CDISCPILOT01 | EX | 01-701-1023 | 1 | PLACEBO | 0 | mg | PATCH | QD | TRANSDERMAL | 3 | BASELINE | 1 | TREATMENT | 2012-08-05 | 2012-08-27 | 1 | 23 |
| 4 | CDISCPILOT01 | EX | 01-701-1023 | 2 | PLACEBO | 0 | mg | PATCH | QD | TRANSDERMAL | 4 | WEEK 2 | 14 | TREATMENT | 2012-08-28 | 2012-09-01 | 24 | 28 |
| 5 | CDISCPILOT01 | EX | 01-701-1028 | 1 | XANOMELINE | 54 | mg | PATCH | QD | TRANSDERMAL | 3 | BASELINE | 1 | TREATMENT | 2013-07-19 | 2013-08-01 | 1 | 14 |
| 6 | CDISCPILOT01 | EX | 01-701-1028 | 2 | XANOMELINE | 81 | mg | PATCH | QD | TRANSDERMAL | 4 | WEEK 2 | 14 | TREATMENT | 2013-08-02 | 2014-01-06 | 15 | 172 |
| 7 | CDISCPILOT01 | EX | 01-701-1028 | 3 | XANOMELINE | 54 | mg | PATCH | QD | TRANSDERMAL | 12 | WEEK 24 | 168 | TREATMENT | 2014-01-07 | 2014-01-14 | 173 | 180 |
| 8 | CDISCPILOT01 | EX | 01-701-1033 | 1 | XANOMELINE | 54 | mg | PATCH | QD | TRANSDERMAL | 3 | BASELINE | 1 | TREATMENT | 2014-03-18 | 2014-03-31 | 1 | 14 |
| 9 | CDISCPILOT01 | EX | 01-701-1034 | 1 | XANOMELINE | 54 | mg | PATCH | QD | TRANSDERMAL | 3 | BASELINE | 1 | TREATMENT | 2014-07-01 | 2014-07-15 | 1 | 15 |