Data.xlsx
20260509T141951Z
Validation: FAIL
Translation memory was updated since this run.
Re-process to apply newly-imported translations.
Project info
- Display nameLifestyle
- Input fileData.xlsx
- Rows × Columns342 × 57
- Run ID
20260509T141951Z
Status
- Validation FAIL (57/59)
- Translations needed complete
- Deliverables produced2/2
- Suspicious values flagged1
1 suspicious value(s) flagged for review
| row_id | column | raw value | cleaned value | reason |
|---|---|---|---|---|
| 248 | triglycerides_at_6_months | 5.47 | 5.47 | >3·IQR from median |
Codebook preview (57 variables)
| Variable | Label | Measurement | Allowed values |
|---|---|---|---|
row_id |
row_id | nominal | 1..N (sequential) |
age_years |
Age ; years | scale | numeric |
gender |
Gender | nominal | 1=Male, 2=Female, 999=Missing |
nationality |
Nationality | nominal | 1=Saudi, 999=Missing |
education_level |
Education level | ordinal | 1=Secondary, 2=University, 3=Primary, 999=Missing |
employment_status |
Employment status | nominal | 1=Employed, 2=Retained, 3=Unemployed, 4=Student, 999=Missing |
diabetes_status |
Diabetes status | nominal | 1=Yes, 2=No, 999=Missing |
hypertention_status |
Hypertention status | nominal | 1=Yes, 2=No, 999=Missing |
dyslipidemia_status |
Dyslipidemia status | nominal | 1=Yes, 2=No, 999=Missing |
history_of_cvd |
History of CVD | nominal | 1=Yes, 2=No, 999=Missing |
reason_for_visiting |
Reason for visiting | nominal | 1=Smoking cessation, 2=Weight management, 3=Pre DM, 4=Behavioral therapy, 5=Uncontrolled DM, 6=Other, 999=Missing |
weight_at_first_visit |
Weight at first visit | scale | numeric |
weight_at_3_months |
Weight at 3 months | scale | numeric |
weight_at_6_months |
Weight at 6 months | scale | numeric |
height_at_first_visit |
Height at first visit | scale | numeric |
height_at_3_months |
Height at 3 months | scale | numeric |
height_at_6_months |
Height at 6 months | scale | numeric |
bmi_at_first_visit |
BMI at first visit | scale | numeric |
bmi_at_3_months |
BMI at 3 months | scale | numeric |
bmi_at_6_months |
BMI at 6 months | scale | numeric |
waist_circumference_first_visit |
Waist circumference : first visit | scale | numeric |
waist_circumference_3_months |
Waist circumference : 3 months | scale | numeric |
waist_circumference_6_months |
Waist circumference : 6 months | scale | numeric |
systolic_bp_at_first_visit |
Systolic BP at first visit | scale | numeric |
systolic_bp_at_3_months |
Systolic BP at 3 months | scale | numeric |
systolic_bp_at_6_months |
Systolic BP at 6 months | scale | numeric |
diastolic_bp_at_first_visit |
Diastolic BP at first visit | scale | numeric |
diastolic_bp_at_3_months |
Diastolic BP at 3 months | scale | numeric |
diastolic_bp_at_6_months |
Diastolic BP at 6 months | nominal | integer codes (30 levels); 999=Missing |
hba1c_at_first_visit |
HbA1c at first visit | scale | numeric |
hba1c_at_3_months |
HbA1c at 3 months | scale | numeric |
hba1c_at_6_months |
HbA1c at 6 months | scale | numeric |
total_cholesterol_at_first_visit |
Total cholesterol at first visit | scale | numeric |
total_cholesterol_at_3_months |
Total cholesterol at 3 months | scale | numeric |
total_cholesterol_at_6_months |
Total cholesterol at 6 months | scale | numeric (range observed); 999=Missing |
ldl_at_first_visit |
LDL at first visit | scale | numeric |
ldl_at_3_months |
LDL at 3 months | scale | numeric |
ldl_at_6_months |
LDL at 6 months | scale | numeric (range observed); 999=Missing |
hdl_at_first_visit |
HDL at first visit | scale | numeric |
hdl_at_3_months |
HDL at 3 months | scale | numeric |
hdl_at_6_months |
HDL at 6 months | scale | numeric (range observed); 999=Missing |
triglycerides_at_first_visit |
Triglycerides at first visit | scale | numeric |
triglycerides_at_3_months |
Triglycerides at 3 months | scale | numeric |
triglycerides_at_6_months |
Triglycerides at 6 months | scale | numeric (range observed); 999=Missing |
smoking_status_at_first_visit |
Smoking status at first visit | nominal | 1=Behavioral therapy, 2=Never smoked, 3=Former, 999=Missing |
smoking_status_at_3_months |
Smoking status at 3 months | nominal | 1=Never smoked, 2=Reduced, 3=No change, 4=Quit, 999=Missing |
smoking_status_at_6_months |
Smoking status at 6 months | nominal | 1=Never smoked, 2=No change, 3=Reduced, 4=Quit, 999=Missing |
physical_activity_level_at_first_visit |
Physical activity level at first visit | ordinal | 1=Light, 2=Sedentary, 3=Moderate, 4=Other, 999=Missing |
physical_activity_level_at_3_months |
Physical activity level at 3 months | ordinal | 1=No improvement, 2=Improved, 999=Missing |
physical_activity_level_at_6_months |
Physical activity level at 6 months | ordinal | 1=No improvement, 2=Improved, 999=Missing |
dietary_habits_at_first_visit |
Dietary habits at first visit | nominal | 1=Fare, 2=Poor, 3=Good, 999=Missing |
dietary_habits_at_3_months |
Dietary habits at 3 months | nominal | 1=No improvement, 2=Improved, 999=Missing |
dietary_habits_at_6_months |
Dietary habits at 6 months | nominal | 1=No improvement, 2=Improved, 999=Missing |
type_of_intervention |
Type of intervention | nominal | 1=Behavioral therapy, 2=Smoking counselling, 999=Missing |
sessions_attended_number_of_sessions |
Sessions attended ( number of sessions) | nominal | integer codes (26 levels); 999=Missing |
sessions_scheduled_number |
Sessions scheduled ( number ) | scale | numeric |
program_completion |
Program completion | nominal | 1=Drop out, 2=On going (f/u), 3=Behavioral therapy, 999=Missing |
Notes