advs_metabolic

Vital Signs Analysis for Metabolic

Structure: One or more records per subject per analysis parameter per analysis timepoint

from pharmadata import pharmaverseadam

meta = pharmaverseadam.meta('advs_metabolic')
print(f"Rows: {meta.number_rows:,}  Columns: {meta.number_columns}")

Rows: 760  Columns: 101

Variables

Show variable specs

shape: (101, 5)

variable	label	type	mandatory	role
str	str	str	str	null
"STUDYID"	"Study Identifier"	"String"	"Yes"	null
"USUBJID"	"Unique Subject Identifier"	"String"	"Yes"	null
"SUBJID"	"Subject Identifier for the Study"	"String"	"No"	null
"SITEID"	"Study Site Identifier"	"String"	"No"	null
"COUNTRY"	"Country"	"String"	"No"	null
"DOMAIN"	"Domain Abbreviation"	"String"	"No"	null
"RFSTDTC"	"Subject Reference Start Date/Time"	"String"	"No"	null
"RFENDTC"	"Subject Reference End Date/Time"	"String"	"No"	null
"RFXSTDTC"	"Date/Time of First Study Treatment"	"String"	"No"	null
"RFXENDTC"	"Date/Time of Last Study Treatment"	"String"	"No"	null
"RFPENDTC"	"Date/Time of End of Participation"	"String"	"No"	null
"SCRFDT"	"Screen Failure Date"	"Date"	"No"	null
"FRVDT"	"Final Retrieval Visit Date"	"Date"	"No"	null
"DTHDTC"	"Date/Time of Death"	"String"	"No"	null
"DTHADY"	"Relative Day of Death"	"Float64"	"No"	null
"DTHFL"	"Subject Death Flag"	"String"	"No"	null
"LDDTHELD"	"Elapsed Days from Last Dose to Death"	"Float64"	"No"	null
"LDDTHGR1"	"Last Dose to Death - Days Elapsed Grp 1"	"String"	"No"	null
"DTH30FL"	"Death Within 30 Days of Last Trt Flag"	"String"	"No"	null
"DTHA30FL"	"Death After 30 Days from Last Trt Flag"	"String"	"No"	null
"DTHDOM"	"Domain for Date of Death Collection"	"String"	"No"	null
"DTHB30FL"	"Death Within 30 Days of First Trt Flag"	"String"	"No"	null
"ASEQ"	"Analysis Sequence Number"	"Int32"	"No"	null
"REGION1"	"Geographic Region 1"	"String"	"No"	null
"DMDTC"	"Date/Time of Collection"	"String"	"No"	null
"DMDY"	"Study Day of Collection"	"Float64"	"No"	null
"AGE"	"Age"	"Float64"	"No"	null
"AGEU"	"Age Units"	"String"	"No"	null
"AGEGR1"	"Pooled Age Group 1"	"String"	"No"	null
"SEX"	"Sex"	"String"	"No"	null
"RACE"	"Race"	"String"	"No"	null
"RACEGR1"	"Pooled Race Group 1"	"String"	"No"	null
"ETHNIC"	"Ethnicity"	"String"	"No"	null
"SAFFL"	"Safety Population Flag"	"String"	"No"	null
"ARM"	"Description of Planned Arm"	"String"	"No"	null
"ARMCD"	"Planned Arm Code"	"String"	"No"	null
"ACTARM"	"Description of Actual Arm"	"String"	"No"	null
"ACTARMCD"	"Actual Arm Code"	"String"	"No"	null
"TRT01P"	"Planned Treatment for Period 01"	"String"	"No"	null
"TRT01A"	"Actual Treatment for Period 01"	"String"	"No"	null
"TRTSDT"	"Date of First Exposure to Treatment"	"Date"	"No"	null
"TRTSDTM"	"Datetime of First Exposure to Treatment"	"Datetime"	"No"	null
"TRTSTMF"	"Time of First Exposure Imput. Flag"	"String"	"No"	null
"TRTEDT"	"Date of Last Exposure to Treatment"	"Date"	"No"	null
"TRTEDTM"	"Datetime of Last Exposure to Treatment"	"Datetime"	"No"	null
"TRTETMF"	"Time of Last Exposure Imput. Flag"	"String"	"No"	null
"EOSSTT"	"End of Study Status"	"String"	"No"	null
"EOSDT"	"End of Study Date"	"Date"	"No"	null
"RFICDTC"	"Date/Time of Informed Consent"	"String"	"No"	null
"RANDDT"	"Date of Randomization"	"Date"	"No"	null
"LSTALVDT"	"Date Last Known Alive"	"Date"	"No"	null
"TRTDURD"	"Total Treatment Duration (Days)"	"Float64"	"No"	null
"DTHDT"	"Date of Death"	"Date"	"No"	null
"DTHDTF"	"Date of Death Imputation Flag"	"String"	"No"	null
"DTHCAUS"	"Cause of Death"	"String"	"No"	null
"DTHCGR1"	"Cause of Death Reason 1"	"String"	"No"	null
"ADT"	"Analysis Date"	"Date"	"No"	null
"ADY"	"Analysis Relative Day"	"Float64"	"No"	null
"AVISIT"	"Analysis Visit"	"String"	"No"	null
"AVISITN"	"Analysis Visit (N)"	"Float64"	"No"	null
"ATPT"	"Analysis Timepoint"	"String"	"No"	null
"ATPTN"	"Analysis Timepoint (N)"	"Float64"	"No"	null
"PARAM"	"Parameter"	"String"	"Yes"	null
"PARAMCD"	"Parameter Code"	"String"	"Yes"	null
"PARAMN"	"Parameter (N)"	"Float64"	"No"	null
"PARCAT1"	"Parameter Category 1"	"String"	"No"	null
"PARCAT1N"	"Parameter Category 1 (N)"	"Float64"	"No"	null
"AVAL"	"Analysis Value"	"Float64"	"No"	null
"AVALCAT1"	"Analysis Value Category 1"	"String"	"No"	null
"AVALCA1N"	"Analysis Value Category 1 (N)"	"Float64"	"No"	null
"BASE"	"Baseline Value"	"Float64"	"No"	null
"BASECAT1"	"Baseline Category 1"	"String"	"No"	null
"BASECA1N"	"Baseline Category 1 (N)"	"Float64"	"No"	null
"CHG"	"Change from Baseline"	"Float64"	"No"	null
"PCHG"	"Percent Change from Baseline"	"Float64"	"No"	null
"CRIT1"	"Analysis Criterion 1"	"String"	"No"	null
"CRIT1FL"	"Criterion 1 Evaluation Result Flag"	"String"	"No"	null
"CRIT2"	"Analysis Criterion 2"	"String"	"No"	null
"CRIT2FL"	"Criterion 2 Evaluation Result Flag"	"String"	"No"	null
"ABLFL"	"Baseline Record Flag"	"String"	"No"	null
"VSSEQ"	"Sequence Number"	"Int32"	"No"	null
"VSTESTCD"	"Vital Signs Test Short Name"	"String"	"No"	null
"VSTEST"	"Vital Signs Test Name"	"String"	"No"	null
"VSPOS"	"Vital Signs Position of Subject"	"String"	"No"	null
"VSORRES"	"Result or Finding in Original Units"	"String"	"No"	null
"VSORRESU"	"Original Units"	"String"	"No"	null
"VSSTRESC"	"Character Result/Finding in Std Format"	"String"	"No"	null
"VSSTRESN"	"Numeric Result/Finding in Standard Units"	"Float64"	"No"	null
"VSSTRESU"	"Standard Units"	"String"	"No"	null
"VSSTAT"	"Completion Status"	"String"	"No"	null
"VSLOC"	"Location of Vital Signs Measurement"	"String"	"No"	null
"VSBLFL"	"Baseline Flag"	"String"	"No"	null
"VISITNUM"	"Visit Number"	"Float64"	"No"	null
"VISIT"	"Visit Name"	"String"	"No"	null
"VISITDY"	"Planned Study Day of Visit"	"Float64"	"No"	null
"VSDTC"	"Date/Time of Measurements"	"String"	"No"	null
"VSDY"	"Study Day of Vital Signs"	"Float64"	"No"	null
"VSTPT"	"Planned Time Point Name"	"String"	"No"	null
"VSTPTNUM"	"Planned Time Point Number"	"Float64"	"No"	null
"VSELTM"	"Planned Elapsed Time from Time Point Ref"	"String"	"No"	null
"VSTPTREF"	"Time Point Reference"	"String"	"No"	null

Examples

from great_docs import tbl_explorer
from pharmadata import pharmaverseadam

tbl_explorer(pharmaverseadam.advs_metabolic.head(10))

	STUDYID str	USUBJID str	SUBJID str	SITEID str	COUNTRY str	DOMAIN str	RFSTDTC str	RFENDTC str	RFXSTDTC str	RFXENDTC str	RFPENDTC str	SCRFDT date	FRVDT date	DTHDTC str	DTHADY f64	DTHFL str	LDDTHELD f64	LDDTHGR1 str	DTH30FL str	DTHA30FL str	DTHDOM str	DTHB30FL str	ASEQ i32	REGION1 str	DMDTC str	DMDY f64	AGE f64	AGEU str	AGEGR1 str	SEX str	RACE str	RACEGR1 str	ETHNIC str	SAFFL str	ARM str	ARMCD str	ACTARM str	ACTARMCD str	TRT01P str	TRT01A str	TRTSDT date	TRTSDTM dtime	TRTSTMF str	TRTEDT date	TRTEDTM dtime	TRTETMF str	EOSSTT str	EOSDT date	RFICDTC str	RANDDT date	LSTALVDT date	TRTDURD f64	DTHDT date	DTHDTF str	DTHCAUS str	DTHCGR1 str	ADT date	ADY f64	AVISIT str	AVISITN f64	ATPT str	ATPTN f64	PARAM str	PARAMCD str	PARAMN f64	PARCAT1 str	PARCAT1N f64	AVAL f64	AVALCAT1 str	AVALCA1N f64	BASE f64	BASECAT1 str	BASECA1N f64	CHG f64	PCHG f64	CRIT1 str	CRIT1FL str	CRIT2 str	CRIT2FL str	ABLFL str	VSSEQ i32	VSTESTCD str	VSTEST str	VSPOS str	VSORRES str	VSORRESU str	VSSTRESC str	VSSTRESN f64	VSSTRESU str	VSSTAT str	VSLOC str	VSBLFL str	VISITNUM f64	VISIT str	VISITDY f64	VSDTC str	VSDY f64	VSTPT str	VSTPTNUM f64	VSELTM str	VSTPTREF str
PolarsRows10Columns101
0	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	1	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2013-12-26	-7	Baseline	0	None	None	Height (cm)	HEIGHT	1	Anthropometric measurement	1	153	None	None	153	None	None	None	None	None	None	None	None	Y	54	HEIGHT	Height	None	153	cm	153	153	cm	None	None	None	1	SCREENING 1	-7	2013-12-26	-7	None	None	None	None
1	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	2	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2013-12-26	-7	None	None	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	89.2	None	None	89.1	None	None	None	None	None	None	None	None	None	164	WEIGHT	Weight	None	89.2	kg	89.2	89.2	kg	None	None	None	1	SCREENING 1	-7	2013-12-26	-7	None	None	None	None
2	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	3	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-01-02	1	Baseline	0	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	89.1	None	None	89.1	None	None	None	None	None	None	None	None	Y	165	WEIGHT	Weight	None	89.1	kg	89.1	89.1	kg	None	None	Y	3	BASELINE	1	2014-01-02	1	None	None	None	None
3	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	4	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-01-16	15	Week 2	2	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	90.2	None	None	89.1	None	None	1.1	1.23456790123	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	166	WEIGHT	Weight	None	90.2	kg	90.2	90.2	kg	None	None	None	4	WEEK 2	14	2014-01-16	15	None	None	None	None
4	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	5	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-01-30	29	Week 4	4	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	90.42	None	None	89.1	None	None	1.32	1.48148148148	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	167	WEIGHT	Weight	None	90.42	kg	90.42	90.42	kg	None	None	None	5	WEEK 4	28	2014-01-30	29	None	None	None	None
5	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	6	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-02-12	42	Week 6	6	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	90.54	None	None	89.1	None	None	1.44	1.61616161616	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	168	WEIGHT	Weight	None	90.54	kg	90.54	90.54	kg	None	None	None	7	WEEK 6	42	2014-02-12	42	None	None	None	None
6	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	7	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-03-05	63	Week 8	8	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	90.81	None	None	89.1	None	None	1.71	1.91919191919	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	169	WEIGHT	Weight	None	90.81	kg	90.81	90.81	kg	None	None	None	8	WEEK 8	56	2014-03-05	63	None	None	None	None
7	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	8	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-03-26	84	Week 12	12	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	91.2	None	None	89.1	None	None	2.1	2.3569023569	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	170	WEIGHT	Weight	None	91.2	kg	91.2	91.2	kg	None	None	None	9	WEEK 12	84	2014-03-26	84	None	None	None	None
8	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	9	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-05-07	126	Week 16	16	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	90.31	None	None	89.1	None	None	1.21	1.35802469136	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	171	WEIGHT	Weight	None	90.31	kg	90.31	90.31	kg	None	None	None	10	WEEK 16	112	2014-05-07	126	None	None	None	None
9	CDISCPILOT01	01-701-1015	1015	701	USA	VS	2014-01-02	2014-07-02	2014-01-02	2014-07-02	2014-07-02T11:45	None	None	None	None	None	None	None	None	None	None	None	10	NA	2013-12-26	-7	63	YEARS	18-64	F	WHITE	White	HISPANIC OR LATINO	Y	Placebo	Pbo	Placebo	Pbo	Placebo	Placebo	2014-01-02	2014-01-02 00:00:00+00:00	H	2014-07-02	2014-07-02 23:59:59+00:00	H	COMPLETED	2014-07-02	None	2014-01-02	2014-07-02	182	None	None	None	None	2014-05-21	140	Week 20	20	None	None	Weight (kg)	WEIGHT	2	Anthropometric measurement	1	91.37	None	None	89.1	None	None	2.27	2.54769921437	Achievement of >= 5% weight reduction from baseline	N	Achievement of >= 10% weight reduction from baseline	N	None	172	WEIGHT	Weight	None	91.37	kg	91.37	91.37	kg	None	None	None	11	WEEK 20	140	2014-05-21	140	None	None	None	None