from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('smq_db')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 44 Columns: 6
smq_db
from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('smq_db')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 44 Columns: 6
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | null | null |
| "termchar" | "Reported Term" | "String" | null | null |
| "scope" | "Scope" | "String" | null | null |
| "smq_name" | "Name" | "String" | null | null |
| "smq_id" | "Name ID" | "Int32" | null | null |
| "version" | "Version" | "String" | null | null |
| "termvar" | "Variable" | "String" | null | null |
from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm
tbl_explorer(pharmaversesdtm.smq_db.head(10))PolarsRows10Columns6 | ||||||
termchar str |
scope str |
smq_name str |
smq_id i32 |
version str |
termvar str |
|
|---|---|---|---|---|---|---|
| 0 | Achromotrichia congenital | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 1 | Craniosynostosis | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 2 | Hypophosphatasia | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 3 | Congenital pyelocaliectasis | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 4 | Uterine contractions during pregnancy | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 5 | Uterine contractions during pregnancy | broad | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 6 | Ductus arteriosus premature closure | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 7 | Pseudotruncus arteriosus | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 8 | Lipomeningocele | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |
| 9 | Macrocephaly | narrow | Pregnancy and neonatal topics (SMQ) | 20000185 | 20.1 | AEDECOD |