from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('qsda')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 32,920 Columns: 23qsda
qsda
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.qsda.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 | 4001 | DAITM01 | UNDERTAKE TO WASH HIMSELF/HERSELF | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | Y | None | 3 | BASELINE | 1 | TREATMENT | 2014-01-02 | 1 |
| 1 | CDISCPILOT01 | QS | 01-701-1015 | 4041 | DAITM01 | UNDERTAKE TO WASH HIMSELF/HERSELF | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 8 | WEEK 8 | 56 | TREATMENT | 2014-03-05 | 63 |
| 2 | CDISCPILOT01 | QS | 01-701-1015 | 4081 | DAITM01 | UNDERTAKE TO WASH HIMSELF/HERSELF | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 10 | WEEK 16 | 112 | TREATMENT | 2014-05-07 | 126 |
| 3 | CDISCPILOT01 | QS | 01-701-1015 | 4121 | DAITM01 | UNDERTAKE TO WASH HIMSELF/HERSELF | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18 | 168 |
| 4 | CDISCPILOT01 | QS | 01-701-1015 | 4002 | DAITM02 | UNDERTAKE TO BRUSH HIS/HER TEETH | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | Y | None | 3 | BASELINE | 1 | TREATMENT | 2014-01-02 | 1 |
| 5 | CDISCPILOT01 | QS | 01-701-1015 | 4042 | DAITM02 | UNDERTAKE TO BRUSH HIS/HER TEETH | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 8 | WEEK 8 | 56 | TREATMENT | 2014-03-05 | 63 |
| 6 | CDISCPILOT01 | QS | 01-701-1015 | 4082 | DAITM02 | UNDERTAKE TO BRUSH HIS/HER TEETH | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 10 | WEEK 16 | 112 | TREATMENT | 2014-05-07 | 126 |
| 7 | CDISCPILOT01 | QS | 01-701-1015 | 4122 | DAITM02 | UNDERTAKE TO BRUSH HIS/HER TEETH | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 12 | WEEK 24 | 168 | TREATMENT | 2014-06-18 | 168 |
| 8 | CDISCPILOT01 | QS | 01-701-1015 | 4003 | DAITM03 | DECIDE TO CARE FOR HIS/HER HAIR | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | Y | None | 3 | BASELINE | 1 | TREATMENT | 2014-01-02 | 1 |
| 9 | CDISCPILOT01 | QS | 01-701-1015 | 4043 | DAITM03 | DECIDE TO CARE FOR HIS/HER HAIR | DAD | HYGIENE | Y | None | 1 | 1 | None | None | None | None | None | 8 | WEEK 8 | 56 | TREATMENT | 2014-03-05 | 63 |