from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('mh')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 1,817 Columns: 19mh
mh
Medical History
Structure: One record per medical history event per subject
Variables
Show variable specs
shape: (19, 5)
| 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" |
| "MHSEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "MHSPID" | "Sponsor-Defined Identifier" | "String" | "No" | "IDENTIFIER" |
| "MHTERM" | "Reported Term for the Medical History" | "String" | "Yes" | "TOPIC" |
| "MHLLT" | "Lowest Level Term" | "String" | "No" | "VARIABLE QUALIFIER" |
| "MHDECOD" | "Dictionary-Derived Term" | "String" | "No" | "SYNONYM QUALIFIER" |
| "MHHLT" | "High Level Term" | "String" | "No" | "VARIABLE QUALIFIER" |
| "MHHLGT" | "High Level Group Term" | "String" | "No" | "VARIABLE QUALIFIER" |
| "MHCAT" | "Category for Medical History" | "String" | "No" | "GROUPING QUALIFIER" |
| "MHBODSYS" | "Body System or Organ Class" | "String" | "No" | "RECORD QUALIFIER" |
| "MHSEV" | "Severity/Intensity" | "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" |
| "MHDTC" | "Date/Time of History Collection" | "String" | "No" | "TIMING" |
| "MHSTDTC" | "Start Date/Time of Medical History Event" | "String" | "No" | "TIMING" |
| "MHDY" | "Study Day of History Collection" | "Float64" | "No" | "TIMING" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.mh.head(10))PolarsRows10Columns19 | |||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
MHSEQ f64 |
MHSPID str |
MHTERM str |
MHLLT str |
MHDECOD str |
MHHLT str |
MHHLGT str |
MHCAT str |
MHBODSYS str |
MHSEV str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
MHDTC str |
MHSTDTC str |
MHDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | MH | 01-701-1015 | 9 | None | ALZHEIMER'S DISEASE | None | None | None | None | PRIMARY DIAGNOSIS | None | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 2010-04-30 | -7 |
| 1 | CDISCPILOT01 | MH | 01-701-1015 | 10 | None | VERBATIM_0539 | GALLBLADDER STONES | CHOLELITHIASIS | HLT_0084 | HLGT_0177 | HISTORICAL DIAGNOSIS | HEPATOBILIARY DISORDERS | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 2012 | -7 |
| 2 | CDISCPILOT01 | MH | 01-701-1015 | 4 | E02 | VERBATIM_0841 | HEARTBURN | DYSPEPSIA | HLT_0244 | HLGT_0716 | SIGNIFICANT PRE-EXISTING CONDITION | GASTROINTESTINAL DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 |
| 3 | CDISCPILOT01 | MH | 01-701-1015 | 2 | E03 | VERBATIM_0301 | HEADACHE | HEADACHE | HLT_0064 | HLGT_0344 | SIGNIFICANT PRE-EXISTING CONDITION | NERVOUS SYSTEM DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 |
| 4 | CDISCPILOT01 | MH | 01-701-1015 | 5 | E04 | VERBATIM_1779 | NUMBNESS IN LEG | HYPOAESTHESIA | HLT_0014 | HLGT_0528 | SIGNIFICANT PRE-EXISTING CONDITION | NERVOUS SYSTEM DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 |
| 5 | CDISCPILOT01 | MH | 01-701-1015 | 8 | None | VERBATIM_0140 | SUBTOTAL HYSTERECTOMY | HYSTERECTOMY | HLT_0675 | HLGT_0657 | HISTORICAL DIAGNOSIS | SURGICAL AND MEDICAL PROCEDURES | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 1986 | -7 |
| 6 | CDISCPILOT01 | MH | 01-701-1015 | 1 | E01 | VERBATIM_0135 | PALPITATIONS | PALPITATIONS | HLT_0493 | HLGT_0593 | SIGNIFICANT PRE-EXISTING CONDITION | CARDIAC DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 |
| 7 | CDISCPILOT01 | MH | 01-701-1015 | 11 | None | VERBATIM_1230 | SORE THROAT | PHARYNGOLARYNGEAL PAIN | HLT_0130 | HLGT_0402 | HISTORICAL DIAGNOSIS | RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 2013-12 | -7 |
| 8 | CDISCPILOT01 | MH | 01-701-1015 | 6 | None | VERBATIM_1004 | THYROIDECTOMY PARTIAL | THYROIDECTOMY PARTIAL | HLT_0243 | HLGT_0016 | HISTORICAL DIAGNOSIS | SURGICAL AND MEDICAL PROCEDURES | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 1973 | -7 |
| 9 | CDISCPILOT01 | MH | 01-701-1015 | 3 | E05 | VERBATIM_0825 | TINNITUS | TINNITUS | HLT_0570 | HLGT_0180 | SIGNIFICANT PRE-EXISTING CONDITION | EAR AND LABYRINTH DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 |