from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('sc')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 254 Columns: 14sc
sc
Subject Characteristics
Structure: One record per characteristic per subject
Variables
Show variable specs
shape: (14, 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" |
| "SCSEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "SCTESTCD" | "Subject Characteristic Short Name" | "String" | "Yes" | "TOPIC" |
| "SCTEST" | "Subject Characteristic" | "String" | "Yes" | "SYNONYM QUALIFIER" |
| "SCCAT" | "Category for Subject Characteristic" | "String" | "No" | "GROUPING QUALIFIER" |
| "SCORRES" | "Result or Finding in Original Units" | "String" | "No" | "RESULT QUALIFIER" |
| "SCORRESU" | "Original Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "SCSTRESC" | "Character Result/Finding in Std Format" | "String" | "No" | "RESULT QUALIFIER" |
| "SCSTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | "RESULT QUALIFIER" |
| "SCSTRESU" | "Standard Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "SCDTC" | "Date/Time of Collection" | "String" | "No" | "TIMING" |
| "SCDY" | "Study Day of Examination" | "Float64" | "No" | "TIMING" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.sc.head(10))PolarsRows10Columns14 | ||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
SCSEQ f64 |
SCTESTCD str |
SCTEST str |
SCCAT str |
SCORRES str |
SCORRESU str |
SCSTRESC str |
SCSTRESN f64 |
SCSTRESU str |
SCDTC str |
SCDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | SC | 01-701-1015 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 16 | YEARS | 16 | 16 | YEARS | 2013-12-26 | -7 |
| 1 | CDISCPILOT01 | SC | 01-701-1023 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 14 | YEARS | 14 | 14 | YEARS | 2012-07-22 | -14 |
| 2 | CDISCPILOT01 | SC | 01-701-1028 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 16 | YEARS | 16 | 16 | YEARS | 2013-07-11 | -8 |
| 3 | CDISCPILOT01 | SC | 01-701-1033 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 12 | YEARS | 12 | 12 | YEARS | 2014-03-10 | -8 |
| 4 | CDISCPILOT01 | SC | 01-701-1034 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 9 | YEARS | 9 | 9 | YEARS | 2014-06-24 | -7 |
| 5 | CDISCPILOT01 | SC | 01-701-1047 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 8 | YEARS | 8 | 8 | YEARS | 2013-01-22 | -21 |
| 6 | CDISCPILOT01 | SC | 01-701-1097 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 18 | YEARS | 18 | 18 | YEARS | 2013-12-23 | -9 |
| 7 | CDISCPILOT01 | SC | 01-701-1111 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 22 | YEARS | 22 | 22 | YEARS | 2012-08-25 | -13 |
| 8 | CDISCPILOT01 | SC | 01-701-1115 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 12 | YEARS | 12 | 12 | YEARS | 2012-11-23 | -7 |
| 9 | CDISCPILOT01 | SC | 01-701-1118 | 1 | EDULEVEL | Level of Education Attained | EDUCATION | 14 | YEARS | 14 | 14 | YEARS | 2014-02-27 | -13 |