from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('qsmm')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 1,524 Columns: 23qsmm
qsmm
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.qsmm.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 | 2001 | MMITM01 | WHAT IS THE (YEAR) (SEASON) (DATE) ? | MMSE | ORIENTATION | 4 | None | 4 | 4 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 1 | CDISCPILOT01 | QS | 01-701-1015 | 2002 | MMITM02 | WHERE ARE WE: (STATE) (COUNTRY) (TOWN) ? | MMSE | ORIENTATION | 4 | None | 4 | 4 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 2 | CDISCPILOT01 | QS | 01-701-1015 | 2003 | MMITM03 | NAME 3 OBJECTS: 1 SECOND TO SAY EACH. | MMSE | REGISTRATION | 3 | None | 3 | 3 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 3 | CDISCPILOT01 | QS | 01-701-1015 | 2004 | MMITM04 | SERIAL 7'S. 1 POINT FOR EACH CORRECT. | MMSE | ATTENTION AND CALCULATI | 3 | None | 3 | 3 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 4 | CDISCPILOT01 | QS | 01-701-1015 | 2005 | MMITM05 | ASK FOR THE 3 OBJECTS REPEATED ABOVE. | MMSE | RECALL | 2 | None | 2 | 2 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 5 | CDISCPILOT01 | QS | 01-701-1015 | 2006 | MMITM06 | NAME A PENCIL, AND WATCH (2 POINTS) | MMSE | LANGUAGE | 7 | None | 7 | 7 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2013-12-26 | -7 |
| 6 | CDISCPILOT01 | QS | 01-701-1023 | 2001 | MMITM01 | WHAT IS THE (YEAR) (SEASON) (DATE) ? | MMSE | ORIENTATION | 4 | None | 4 | 4 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2012-07-22 | -14 |
| 7 | CDISCPILOT01 | QS | 01-701-1023 | 2002 | MMITM02 | WHERE ARE WE: (STATE) (COUNTRY) (TOWN) ? | MMSE | ORIENTATION | 4 | None | 4 | 4 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2012-07-22 | -14 |
| 8 | CDISCPILOT01 | QS | 01-701-1023 | 2003 | MMITM03 | NAME 3 OBJECTS: 1 SECOND TO SAY EACH. | MMSE | REGISTRATION | 3 | None | 3 | 3 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2012-07-22 | -14 |
| 9 | CDISCPILOT01 | QS | 01-701-1023 | 2004 | MMITM04 | SERIAL 7'S. 1 POINT FOR EACH CORRECT. | MMSE | ATTENTION AND CALCULATI | 4 | None | 4 | 4 | None | None | None | None | None | 1 | SCREENING 1 | -7 | TREATMENT | 2012-07-22 | -14 |