from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('qsgi')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 562 Columns: 23qsgi
qsgi
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.qsgi.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 | 6001 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 8 | WEEK 8 | 56 | TREATMENT | 2014-03-05 | 63 |
| 1 | CDISCPILOT01 | QS | 01-701-1015 | 6002 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 10 | WEEK 16 | 112 | TREATMENT | 2014-05-07 | 126 |
| 2 | CDISCPILOT01 | QS | 01-701-1015 | 6003 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18 | 168 |
| 3 | CDISCPILOT01 | QS | 01-701-1023 | 6001 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | MINIMAL IMPROVEMENT | None | 3 | 3 | None | None | None | None | None | 5 | WEEK 4 | 28 | TREATMENT | 2012-09-02 | 29 |
| 4 | CDISCPILOT01 | QS | 01-701-1023 | 6002 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | MINIMAL WORSENING | None | 5 | 5 | None | None | None | None | None | 201 | RETRIEVAL | 168 | TREATMENT | 2013-02-18 | 198 |
| 5 | CDISCPILOT01 | QS | 01-701-1028 | 6001 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 8 | WEEK 8 | 56 | TREATMENT | 2013-09-10 | 54 |
| 6 | CDISCPILOT01 | QS | 01-701-1028 | 6002 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 10 | WEEK 16 | 112 | TREATMENT | 2013-11-06 | 111 |
| 7 | CDISCPILOT01 | QS | 01-701-1028 | 6003 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-01-06 | 172 |
| 8 | CDISCPILOT01 | QS | 01-701-1033 | 6001 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 5 | WEEK 4 | 28 | TREATMENT | 2014-04-14 | 28 |
| 9 | CDISCPILOT01 | QS | 01-701-1033 | 6002 | CIBIC | EXTENT OF CHANGE, IF ANY, SINCE BASELINE | ADCS-CGIC | None | NO CHANGE | None | 4 | 4 | None | None | None | None | None | 201 | RETRIEVAL | 168 | TREATMENT | 2014-09-15 | 182 |