from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('sdg_db')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 16 Columns: 5
sdg_db
from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('sdg_db')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 16 Columns: 5
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | null | null |
| "termchar" | "Reported Term" | "String" | null | null |
| "sdg_name" | "Name" | "String" | null | null |
| "sdg_id" | "Name ID" | "Int32" | null | null |
| "termvar" | "Variable" | "String" | null | null |
| "version" | "Version" | "String" | null | null |
from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm
tbl_explorer(pharmaversesdtm.sdg_db.head(10))PolarsRows10Columns5 | |||||
termchar str |
sdg_name str |
sdg_id i32 |
termvar str |
version str |
|
|---|---|---|---|---|---|
| 0 | AMINOSALICYLIC ACID | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 1 | AMINOSALICYLATE CALCIUM | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 2 | AMINOSALICYLATE CALCIUM ALUMINIUM | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 3 | AMINOSALICYLATE SODIUM | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 4 | SODIUM AMINOSALICYLATE DIHYDRATE | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 5 | AMINOSALICYLATE SODIUM;AMINOSALICYLIC ACID | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 6 | SULFASALAZINE | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 7 | CALCIUM BENZAMIDOSALICYLATE | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 8 | OLSALAZINE | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |
| 9 | OLSALAZINE SODIUM | 5-aminosalicylates for ulcerative colitis | 220 | CMDECOD | 2019-09 |