from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('ms')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 47 Columns: 23ms
ms
Microbiology Susceptibility
Variables
Show variable specs
shape: (23, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | null | null |
| "STUDYID" | "Study Identifier" | "String" | null | null |
| "DOMAIN" | "Domain Abbreviation" | "String" | null | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | null | null |
| "MSSEQ" | "Sequence Number" | "Int32" | null | null |
| "MSREFID" | "Reference ID" | "String" | null | null |
| "NHOID" | "Non-host Organism ID" | "String" | null | null |
| "MSGRPID" | "Group ID" | "Float64" | null | null |
| "MSLNKID" | "Link ID" | "String" | null | null |
| "MSTESTCD" | "Short Name of Assessment" | "String" | null | null |
| "MSTEST" | "Name of Assessment" | "String" | null | null |
| "MSAGENT" | "Agent Name" | "String" | null | null |
| "MSCONC" | "Agent Concentration" | "String" | null | null |
| "MSCONCU" | "Agent Concentration Units" | "String" | null | null |
| "MSORRES" | "Result or Finding in Original Units" | "String" | null | null |
| "MSORRESU" | "Original Units" | "String" | null | null |
| "MSSTRESC" | "Result or Finding in Standard Format" | "String" | null | null |
| "MSSTRESN" | "Numeric Result/Finding in Standard Units" | "String" | null | null |
| "MSSTRESU" | "Standard Units" | "String" | null | null |
| "MSSPEC" | "Specimen Material Type" | "String" | null | null |
| "MSLOC" | "Location Used for the Measurement" | "String" | null | null |
| "MSMETHOD" | "Method of Test or Examination" | "String" | null | null |
| "VISITNUM" | "Visit Number" | "Float64" | null | null |
| "MSDTC" | "Date/Time of Collection" | "String" | null | null |
Examples
from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm
tbl_explorer(pharmaversesdtm.ms.head(10))PolarsRows10Columns23 | |||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
MSSEQ i32 |
MSREFID str |
NHOID str |
MSGRPID f64 |
MSLNKID str |
MSTESTCD str |
MSTEST str |
MSAGENT str |
MSCONC str |
MSCONCU str |
MSORRES str |
MSORRESU str |
MSSTRESC str |
MSSTRESN str |
MSSTRESU str |
MSSPEC str |
MSLOC str |
MSMETHOD str |
VISITNUM f64 |
MSDTC str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | MS | 01-701-1015 | 1 | ALIQ1.1.2 | STAPHYLOCOCCUS AUREUS | 1 | ALIQ1.1.2-C | MIC | Minimum Inhibitory Concentration | VANCOMYCIN | None | None | 3 | ug/dL | 3 | 3 | ug/dL | SKIN TISSUE | SKIN OF THE AXILLA | EPSILOMETER | 1 | 2025-06-14T08:00 |
| 1 | CDISCPILOT01 | MS | 01-701-1015 | 2 | ALIQ1.1.2 | STAPHYLOCOCCUS AUREUS | 1 | ALIQ1.1.2-C | MICROSUS | Microbial Susceptibility | VANCOMYCIN | None | None | RESISTANT | None | RESISTANT | None | None | SKIN TISSUE | SKIN OF THE AXILLA | EPSILOMETER | 1 | 2025-06-14T08:00 |
| 2 | CDISCPILOT01 | MS | 01-701-1015 | 3 | ALIQ1.1.2 | STAPHYLOCOCCUS AUREUS | 2 | ALIQ1.1.2-C | DIAZOINH | Diameter of the Zone of Inhibition | CIPROFLOXACIN | None | None | 14 | mm | 14 | 14 | mm | SKIN TISSUE | SKIN OF THE AXILLA | DISK DIFFUSION | 1 | 2025-06-14T08:00 |
| 3 | CDISCPILOT01 | MS | 01-701-1015 | 4 | ALIQ1.1.2 | STAPHYLOCOCCUS AUREUS | 2 | ALIQ1.1.2-C | MICROSUS | Microbial Susceptibility | CIPROFLOXACIN | None | None | SUSCEPTIBLE | None | SUSCEPTIBLE | None | None | SKIN TISSUE | SKIN OF THE AXILLA | DISK DIFFUSION | 1 | 2025-06-14T08:00 |
| 4 | CDISCPILOT01 | MS | 01-701-1015 | 5 | ALIQ1.1.3 | KLEBSIELLA PNEUMONIAE | 3 | ALIQ1.1.3-C | MIC | Minimum Inhibitory Concentration | AMIKACIN | None | None | 1.5 | ug/dL | 1.5 | 1.5 | ug/dL | SKIN TISSUE | SKIN OF THE AXILLA | EPSILOMETER | 1 | 2025-06-14T08:00 |
| 5 | CDISCPILOT01 | MS | 01-701-1015 | 6 | ALIQ1.1.3 | KLEBSIELLA PNEUMONIAE | 3 | ALIQ1.1.3-C | MICROSUS | Microbial Susceptibility | AMIKACIN | None | None | SUSCEPTIBLE | None | SUSCEPTIBLE | None | None | SKIN TISSUE | SKIN OF THE AXILLA | EPSILOMETER | 1 | 2025-06-14T08:00 |
| 6 | CDISCPILOT01 | MS | 01-701-1015 | 7 | ALIQ1.2.1 | KLEBSIELLA PNEUMONIAE | 4 | ALIQ1.2.1-C | MIC | Minimum Inhibitory Concentration | AMIKACIN | None | None | 10 | ug/dL | 10 | 10 | ug/dL | SKIN TISSUE | SKIN OF THE AXILLA | EPSILOMETER | 2 | 2025-06-21T08:00 |
| 7 | CDISCPILOT01 | MS | 01-701-1015 | 8 | ALIQ1.2.1 | KLEBSIELLA PNEUMONIAE | 4 | ALIQ1.2.1-C | MICROSUS | Microbial Susceptibility | AMIKACIN | None | None | RESISTANT | None | RESISTANT | None | None | SKIN TISSUE | SKIN OF THE AXILLA | EPSILOMETER | 2 | 2025-06-21T08:00 |
| 8 | CDISCPILOT01 | MS | 01-701-1023 | 1 | ALIQ2.1.2 | ENTEROCOCCUS FAECALIS | 1 | ALIQ2.1.2-C | DIAZOINH | Diameter of the Zone of Inhibition | AMOXICILLIN | None | None | 8 | mm | 8 | 8 | mm | URINE | URINARY SYSTEM | DISK DIFFUSION | 1 | 2025-07-15T08:00 |
| 9 | CDISCPILOT01 | MS | 01-701-1023 | 2 | ALIQ2.1.2 | ENTEROCOCCUS FAECALIS | 1 | ALIQ2.1.2-C | MICROSUS | Microbial Susceptibility | AMOXICILLIN | None | None | RESISTANT | None | RESISTANT | None | None | URINE | URINARY SYSTEM | DISK DIFFUSION | 1 | 2025-07-15T08:00 |