APHRC Online Microdata Library
    Home / Central Data Catalog / DATA_SCIENCE_AND_EVALUATION / DDI-KEN-APHRC-SUPERMARKET-A-2023-V1.0
Data_Science_and_Evaluation

Analysis of Supermarket Grocery Data for Prediction of Nutritional and Health Outcomes at the Population Level - Supermarket A

Kenya, 2020 - 2023
Data Science and Evaluation (DSE)
Agnes Kiragga
Last modified June 25, 2025 Page views 225 Documentation in PDF Metadata DDI/XML JSON

Data file: clean_analysis_supermarket_a_sample

Cases 473890
Variables 56

Variables

id
Shopper id
county
County acronym
gender
Gender
description
Product name description
price
Unit price of product
quantity
Quantity of product purchased
total
Sales invoice total price
trnref
Transaction id
sdatetime
Transaction date
paymentmode
Payment mode
branch
Branch id of supermarket
transaction_id
Supermarket branch transaction id
dob_new
Date of birth of shopper
supermarket_name
Supermarket name
branch_name
Branch name of supermarket
county_name
Location
sub_county_name
Sub-county
month_date
Month date
total_new
Total product price
customer_type
Shopper type recorded as loyalty and non-loyalty
year
Year
quarter_date
Quarter date
age
Age (years)
item_type
Product type recorded as food item and non-food item
class_name
Food category
subclass_name
Food category sub-groups
food_group
Developed food groups classification
nova
Nova food classification
energy_k_j
Energy (kj)
energy_kcal
Energy (kcal)
water_g
Water (g)
protein_g
Protein (g)
fat_g
Fat (g)
carbohydrate_available_g
Carbohydrate available (g)
fibre_g
Fibre (g)
ash_g
Ash (g)
calcium_ca_mg
Calcium (mg)
iron_fe_mg
Iron (mg)
magnesium_mg_mg
Magnesium (mg)
phosphorus_p_mg
Phosphorus (mg)
potassium_k_mg
Potassium (mg)
sodium_na_mg
Sodium (mg)
zinc_zn_mg
Zinc (mg)
selenium_se_mcg
Selenium (mcg)
vit_a_rae_mcg
Vitamin a-rae (mcg)
vit_a_re_mcg
Vitamin a-re (mcg)
retinol_mcg
Retinol (mcg)
b_carotene_equivalent_mcg
B-carotene equivalent (mcg)
thiamin_mg
Thiamin (mg)
riboflavin_mg
Riboflavin (mg)
niacin_mg
Niacin (mg)
dietary_folate_eq_mcg
Dietary folate equivalent (mcg)
food_folate_mcg
Food folate (mcg)
vit_b12_mcg
Vitamin b12 (mcg)
vit_c_mg
Vitamin c (mg)
cholesterol_chole_mg
Cholesterol (mg)
Total: 56