from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('supplbch')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 37,124 Columns: 10supplbch
supplbch
Supplemental Qualifiers for LB
Structure: One record per IDVAR, IDVARVAL, and QNAM value per subject
Variables
Show variable specs
shape: (10, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | str |
| "STUDYID" | "Study Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "RDOMAIN" | "Related Domain Abbreviation" | "String" | "Yes" | "IDENTIFIER" |
| "USUBJID" | "Unique Subject Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "IDVAR" | "Identifying Variable" | "String" | "No" | "IDENTIFIER" |
| "IDVARVAL" | "Identifying Variable Value" | "String" | "No" | "IDENTIFIER" |
| "QNAM" | "Qualifier Variable Name" | "String" | "Yes" | "TOPIC" |
| "QLABEL" | "Qualifier Variable Label" | "String" | "Yes" | "SYNONYM QUALIFIER" |
| "QVAL" | "Data Value" | "String" | "Yes" | "RESULT" |
| "QORIG" | "Origin" | "String" | "Yes" | "RESULT QUALIFIER" |
| "QEVAL" | "Evaluator" | "String" | "No" | "RESULT QUALIFIER" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.supplbch.head(10))PolarsRows10Columns10 | ||||||||||
STUDYID str |
RDOMAIN str |
USUBJID str |
IDVAR str |
IDVARVAL str |
QNAM str |
QLABEL str |
QVAL str |
QORIG str |
QEVAL str |
|
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 1 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.8 | DERIVED | CLINICAL STUDY SPONSOR |
| 1 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 2 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.3 | DERIVED | CLINICAL STUDY SPONSOR |
| 2 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 3 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.8 | DERIVED | CLINICAL STUDY SPONSOR |
| 3 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 5 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 1.2 | DERIVED | CLINICAL STUDY SPONSOR |
| 4 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 7 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.5 | DERIVED | CLINICAL STUDY SPONSOR |
| 5 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 8 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.4 | DERIVED | CLINICAL STUDY SPONSOR |
| 6 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 9 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.9 | DERIVED | CLINICAL STUDY SPONSOR |
| 7 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 10 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.8 | DERIVED | CLINICAL STUDY SPONSOR |
| 8 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 11 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.4 | DERIVED | CLINICAL STUDY SPONSOR |
| 9 | CDISCPILOT01 | LB | 01-701-1015 | LBSEQ | 12 | LBTMSHI | LAB RESULT/UPPER LIMIT OF NORMAL | 0.9 | DERIVED | CLINICAL STUDY SPONSOR |