from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('qshi')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 3,302 Columns: 23qshi
qshi
Questionnaires
Structure: One record per questionnaire per question per time point per visit per subject
Variables
Show variable specs
shape: (23, 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" |
| "QSSEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "QSTESTCD" | "Question Short Name" | "String" | "Yes" | "TOPIC" |
| "QSTEST" | "Question Name" | "String" | "Yes" | "SYNONYM QUALIFIER" |
| "QSCAT" | "Category of Question" | "String" | "Yes" | "GROUPING QUALIFIER" |
| "QSSCAT" | "Subcategory for Question" | "String" | "No" | "GROUPING QUALIFIER" |
| "QSORRES" | "Finding in Original Units" | "String" | "No" | "RESULT QUALIFIER" |
| "QSORRESU" | "Original Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "QSSTRESC" | "Result or Finding in Standard Format" | "String" | "No" | "RESULT QUALIFIER" |
| "QSSTRESN" | "Numeric Finding in Standard Units" | "Float64" | "No" | "RESULT QUALIFIER" |
| "QSSTRESU" | "Standard Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "QSSTAT" | "Completion Status" | "String" | "No" | "RECORD QUALIFIER" |
| "QSREASND" | "Reason Not Performed" | "String" | "No" | null |
| "QSBLFL" | "Baseline Flag" | "String" | "No" | "RECORD QUALIFIER" |
| "QSDRVFL" | "Derived Flag" | "String" | "No" | "RECORD 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" |
| "QSDTC" | "Date/Time of Finding" | "String" | "No" | "TIMING" |
| "QSDY" | "Study Day of Finding" | "Float64" | "No" | "TIMING" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.qshi.head(10))PolarsRows10Columns23 | |||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
QSSEQ f64 |
QSTESTCD str |
QSTEST str |
QSCAT str |
QSSCAT str |
QSORRES str |
QSORRESU str |
QSSTRESC str |
QSSTRESN f64 |
QSSTRESU str |
QSSTAT str |
QSREASND str |
QSBLFL str |
QSDRVFL str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
EPOCH str |
QSDTC str |
QSDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | QS | 01-701-1015 | 1001 | MHITM01 | ABRUPT ONSET | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 1 | CDISCPILOT01 | QS | 01-701-1015 | 1002 | MHITM02 | STEPWISE DETERIORATION | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 2 | CDISCPILOT01 | QS | 01-701-1015 | 1003 | MHITM03 | FLUCTUATING COURSE | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 3 | CDISCPILOT01 | QS | 01-701-1015 | 1004 | MHITM04 | NOCTURNAL CONFUSION | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 4 | CDISCPILOT01 | QS | 01-701-1015 | 1005 | MHITM05 | RELATIVE PRESERVATION OF PERSONALITY | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 5 | CDISCPILOT01 | QS | 01-701-1015 | 1006 | MHITM06 | DEPRESSION | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 6 | CDISCPILOT01 | QS | 01-701-1015 | 1007 | MHITM07 | SOMATIC COMPLAINTS | MHIS-NACC | None | PRESENT | None | 1 | 1 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 7 | CDISCPILOT01 | QS | 01-701-1015 | 1008 | MHITM08 | EMOTIONAL INCONTINENCE | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 8 | CDISCPILOT01 | QS | 01-701-1015 | 1009 | MHITM09 | HISTORY OF HYPERTENSION | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 9 | CDISCPILOT01 | QS | 01-701-1015 | 1010 | MHITM10 | HISTORY OF STROKES | MHIS-NACC | None | ABSENT | None | 0 | 0 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |