from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('cm')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 7,510 Columns: 23
cm
Structure: One record per recorded medication occurrence or constant-dosing interval per subject
from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('cm')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 7,510 Columns: 23
| 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" |
| "CMSEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "CMSPID" | "Sponsor-Defined Identifier" | "String" | "No" | "IDENTIFIER" |
| "CMTRT" | "Reported Name of Drug, Med, or Therapy" | "String" | "Yes" | "TOPIC" |
| "CMDECOD" | "Standardized Medication Name" | "String" | "No" | "SYNONYM QUALIFIER" |
| "CMINDC" | "Indication" | "String" | "No" | "RECORD QUALIFIER" |
| "CMCLAS" | "Medication Class" | "String" | "No" | "VARIABLE QUALIFIER" |
| "CMDOSE" | "Dose per Administration" | "Float64" | "No" | "RECORD QUALIFIER" |
| "CMDOSU" | "Dose Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "CMDOSFRQ" | "Dosing Frequency per Interval" | "String" | "No" | "VARIABLE QUALIFIER" |
| "CMROUTE" | "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" |
| "CMDTC" | "Date/Time of Collection" | "String" | "No" | "TIMING" |
| "CMSTDTC" | "Start Date/Time of Medication" | "String" | "No" | "TIMING" |
| "CMENDTC" | "End Date/Time of Medication" | "String" | "No" | "TIMING" |
| "CMDY" | "Study Day of Visit/Collection/Exam" | "Float64" | "No" | "TIMING" |
| "CMSTDY" | "Study Day of Start of Medication" | "Float64" | "No" | "TIMING" |
| "CMENDY" | "Study Day of End of Medication" | "Float64" | "No" | "TIMING" |
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.cm.head(10))PolarsRows10Columns23 | |||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
CMSEQ f64 |
CMSPID str |
CMTRT str |
CMDECOD str |
CMINDC str |
CMCLAS str |
CMDOSE f64 |
CMDOSU str |
CMDOSFRQ str |
CMROUTE str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
EPOCH str |
CMDTC str |
CMSTDTC str |
CMENDTC str |
CMDY f64 |
CMSTDY f64 |
CMENDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | CM | 01-701-1015 | 1 | 1 | ASPIRIN | ACETYLSALICYLIC ACID | None | NERVOUS SYSTEM | 1 | TABLET | PRN | ORAL | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26 | 2003 | None | -7 | None | None |
| 1 | CDISCPILOT01 | CM | 01-701-1015 | 2 | 4 | TYLENOL | UNCODED | None | UNCODED | 1 | TABLET | PRN | ORAL | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26 | 2003 | None | -7 | None | None |
| 2 | CDISCPILOT01 | CM | 01-701-1015 | 3 | 3 | PREMARIN | ESTROGENS CONJUGATED | PROPHYLAXIS OR NON-THERAPEUTIC USE | GENITO URINARY SYSTEM AND SEX HORMONES | 0.625 | mg | QD | ORAL | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26 | 2006 | None | -7 | None | None |
| 3 | CDISCPILOT01 | CM | 01-701-1015 | 4 | 2 | CALCIUM | CALCIUM | PROPHYLAXIS OR NON-THERAPEUTIC USE | ALIMENTARY TRACT AND METABOLISM | 1 | TABLET | QD | ORAL | 1 | SCREENING 1 | -7 | SCREENING | 2013-12-26 | 2013 | None | -7 | None | None |
| 4 | CDISCPILOT01 | CM | 01-701-1015 | 5 | 1 | ASPIRIN | ACETYLSALICYLIC ACID | None | NERVOUS SYSTEM | 1 | TABLET | PRN | ORAL | 2 | SCREENING 2 | -1 | SCREENING | 2013-12-31 | 2003 | None | -2 | None | None |
| 5 | CDISCPILOT01 | CM | 01-701-1015 | 6 | 4 | TYLENOL | UNCODED | None | UNCODED | 1 | TABLET | PRN | ORAL | 2 | SCREENING 2 | -1 | SCREENING | 2013-12-31 | 2003 | None | -2 | None | None |
| 6 | CDISCPILOT01 | CM | 01-701-1015 | 7 | 3 | PREMARIN | ESTROGENS CONJUGATED | PROPHYLAXIS OR NON-THERAPEUTIC USE | GENITO URINARY SYSTEM AND SEX HORMONES | 0.625 | mg | QD | ORAL | 2 | SCREENING 2 | -1 | SCREENING | 2013-12-31 | 2006 | None | -2 | None | None |
| 7 | CDISCPILOT01 | CM | 01-701-1015 | 8 | 2 | CALCIUM | CALCIUM | PROPHYLAXIS OR NON-THERAPEUTIC USE | ALIMENTARY TRACT AND METABOLISM | 1 | TABLET | QD | ORAL | 2 | SCREENING 2 | -1 | SCREENING | 2013-12-31 | 2013 | None | -2 | None | None |
| 8 | CDISCPILOT01 | CM | 01-701-1015 | 9 | 1 | ASPIRIN | ACETYLSALICYLIC ACID | None | NERVOUS SYSTEM | 1 | TABLET | PRN | ORAL | 3 | BASELINE | 1 | TREATMENT | 2014-01-02 | 2003 | None | 1 | None | None |
| 9 | CDISCPILOT01 | CM | 01-701-1015 | 10 | 4 | TYLENOL | UNCODED | None | UNCODED | 1 | TABLET | PRN | ORAL | 3 | BASELINE | 1 | TREATMENT | 2014-01-02 | 2003 | None | 1 | None | None |