from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adppk')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 3,522 Columns: 61
adppk
from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adppk')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 3,522 Columns: 61
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | null |
| "PROJID" | "Project Identifier" | "String" | "No" | null |
| "PROJIDN" | "Project Identifier (N)" | "Float64" | "No" | null |
| "STUDYID" | "Study Identifier" | "String" | "No" | null |
| "STUDYIDN" | "Study Identifier (N)" | "Float64" | "No" | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | "No" | null |
| "USUBJIDN" | "Unique Subject Identifier (N)" | "Float64" | "No" | null |
| "SUBJID" | "Subject Identifier for the Study" | "String" | "No" | null |
| "SUBJIDN" | "Subject Identifier for the Study (N)" | "Float64" | "No" | null |
| "SITEID" | "Study Site Identifier" | "String" | "No" | null |
| "SITEIDN" | "Study Site Identifier (N)" | "Float64" | "No" | null |
| "RECSEQ" | "Record Sequence" | "Int32" | "No" | null |
| "AFRLT" | "Act. Rel. Time from Analyte First Dose" | "Float64" | "No" | null |
| "APRLT" | "Actual Rel Time from Previous Dose" | "Float64" | "No" | null |
| "NFRLT" | "Nom. Rel. Time from Analyte First Dose" | "Float64" | "No" | null |
| "NPRLT" | "Nominal Rel Time from Previous Dose" | "Float64" | "No" | null |
| "EVID" | "Event ID" | "Float64" | "No" | null |
| "CMT" | "Compartment" | "Float64" | "No" | null |
| "DV" | "Dependent Variable Result" | "Float64" | "No" | null |
| "PARAMCD" | "Parameter Code" | "String" | "No" | null |
| "PARAM" | "Parameter" | "String" | "No" | null |
| "PARAMN" | "Parameter (N)" | "Float64" | "No" | null |
| "ASEQ" | "Analysis Sequence Number" | "Int32" | "No" | null |
| "AVAL" | "Analysis Value" | "Float64" | "No" | null |
| "AVALU" | "Analysis Value Unit" | "String" | "No" | null |
| "MDV" | "Missing Dependent Variable Result" | "Float64" | "No" | null |
| "ALLOQ" | "Analysis Lower Limit of Quantitation" | "Float64" | "No" | null |
| "BLQFL" | "Below Lower Limit of Quant Flag" | "String" | "No" | null |
| "BLQFN" | "Below Lower Limit of Quant Flag (N)" | "Float64" | "No" | null |
| "AMT" | "Actual Amount of Dose Received (unit)" | "Float64" | "No" | null |
| "DOSEA" | "Actual Treatment Dose" | "Float64" | "No" | null |
| "II" | "Dosing Interval (unit)" | "Float64" | "No" | null |
| "SS" | "Steady State" | "Float64" | "No" | null |
| "FORM" | "Drug Formulation" | "String" | "No" | null |
| "FORMN" | "Drug Formulation (N)" | "Float64" | "No" | null |
| "ROUTE" | "Route of Administration" | "String" | "No" | null |
| "ROUTEN" | "Route of Administration (N)" | "Float64" | "No" | null |
| "COHORT" | "Cohort Subject Enrolled Into" | "Float64" | "No" | null |
| "COHORTC" | "Description of Planned Arm" | "String" | "No" | null |
| "UDTC" | "Date/Time" | "String" | "No" | null |
| "WTBL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "HTBL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "BMIBL" | "Baseline Body Mass Index (kg/m2)" | "Float64" | "No" | null |
| "BSABL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "AGE" | "Age" | "Float64" | "No" | null |
| "SEX" | "Sex" | "String" | "No" | null |
| "SEXN" | "Sex (N)" | "Float64" | "No" | null |
| "RACE" | "Race" | "String" | "No" | null |
| "RACEN" | "Race (N)" | "Float64" | "No" | null |
| "ETHNIC" | "Ethnicity" | "String" | "No" | null |
| "ETHNICN" | "Ethnicity (N)" | "Float64" | "No" | null |
| "COUNTRY" | "Country" | "String" | "No" | null |
| "COUNTRYL" | "Country Name" | "String" | "No" | null |
| "COUNTRYN" | "Country (N)" | "Float64" | "No" | null |
| "CREATBL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "CRCLBL" | "Baseline Creatinine Clearance" | "Float64" | "No" | null |
| "EGFRBL" | "Age" | "Float64" | "No" | null |
| "TBILBL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "ASTBL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "ALTBL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "DOSEP" | "Planned Treatment Dose" | "Float64" | "No" | null |
| "DVL" | "Log DV" | "Float64" | "No" | null |
from great_docs import tbl_explorer
from pharmadata import pharmaverseadam
tbl_explorer(pharmaverseadam.adppk.head(10))PolarsRows10Columns61 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PROJID str |
PROJIDN f64 |
STUDYID str |
STUDYIDN f64 |
USUBJID str |
USUBJIDN f64 |
SUBJID str |
SUBJIDN f64 |
SITEID str |
SITEIDN f64 |
RECSEQ i32 |
AFRLT f64 |
APRLT f64 |
NFRLT f64 |
NPRLT f64 |
EVID f64 |
CMT f64 |
DV f64 |
PARAMCD str |
PARAM str |
PARAMN f64 |
ASEQ i32 |
AVAL f64 |
AVALU str |
MDV f64 |
ALLOQ f64 |
BLQFL str |
BLQFN f64 |
AMT f64 |
DOSEA f64 |
II f64 |
SS f64 |
FORM str |
FORMN f64 |
ROUTE str |
ROUTEN f64 |
COHORT f64 |
COHORTC str |
UDTC str |
WTBL f64 |
HTBL f64 |
BMIBL f64 |
BSABL f64 |
AGE f64 |
SEX str |
SEXN f64 |
RACE str |
RACEN f64 |
ETHNIC str |
ETHNICN f64 |
COUNTRY str |
COUNTRYL str |
COUNTRYN f64 |
CREATBL f64 |
CRCLBL f64 |
EGFRBL f64 |
TBILBL f64 |
ASTBL f64 |
ALTBL f64 |
DOSEP f64 |
DVL f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 1 | -0.5 | -0.5 | 0 | 0 | 0 | 2 | 0 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 1 | 0 | ug/ml | 0 | 0.01 | Y | 1 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-13T23:30:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | None |
| 1 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | None | DOSE | Xanomeline Patch Dose | 2 | 2 | None | None | 1 | None | N | 0 | 54 | 54 | 1 | 1 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T00:00:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | None |
| 2 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 3 | 0.0833333333333 | 0.0833333333333 | 0.0833333333333 | 0.0833333333333 | 0 | 2 | 0.105496883528 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 3 | 0.105496883528 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T00:05:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | -2.24907386652 |
| 3 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 4 | 0.5 | 0.5 | 0.5 | 0.5 | 0 | 2 | 0.570037010595 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 4 | 0.570037010595 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T00:30:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | -0.562053989392 |
| 4 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 5 | 1 | 1 | 1 | 1 | 0 | 2 | 0.968127680411 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 5 | 0.968127680411 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T01:00:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | -0.0323912991532 |
| 5 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 6 | 1.5 | 1.5 | 1.5 | 1.5 | 0 | 2 | 1.24613801737 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 6 | 1.24613801737 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T01:30:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | 0.220049182584 |
| 6 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 7 | 2 | 2 | 2 | 2 | 0 | 2 | 1.44028913247 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 7 | 1.44028913247 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T02:00:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | 0.364843879869 |
| 7 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 8 | 4 | 4 | 4 | 4 | 0 | 2 | 1.7828718612 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 8 | 1.7828718612 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T04:00:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | 0.578225469331 |
| 8 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 9 | 6 | 6 | 6 | 6 | 0 | 2 | 1.86435753194 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 9 | 1.86435753194 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T06:00:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | 0.622916506852 |
| 9 | XANOMELINE | 1 | CDISCPILOT01 | 1 | 01-710-1002 | 1002 | 1002 | 1002 | 710 | 710 | 10 | 6 | 6 | 3 | 3 | 0 | 3 | 25.7735062269 | XAN | Pharmacokinetic concentration of Xanomeline | 1 | 10 | 25.7735062269 | ug/ml | 0 | 0.01 | N | 0 | None | 54 | 0 | 0 | PATCH | 3 | TRANSDERMAL | 3 | 1 | Xanomeline Low Dose | 2014-01-14T06:00:00 | 70.31 | 165.1 | 25.7942527719 | 1.79568781313 | 88 | M | 1 | WHITE | 5 | NOT HISPANIC OR LATINO | 2 | USA | United States of America | 235 | 123.76 | 36.3366806723 | 48.3565089209 | 11.97 | 20 | 14 | 54 | 3.24934707388 |