Dataset: Groceries Dataset For Market Basket Analysis(MBA)

About this Dataset

Groceries Dataset For Market Basket Analysis(MBA)

The initial dataset was collected from Groceries dataset. Then data was modified and fragmented into 2 datasets for ease of MBA implementation. Here the "groceries data.csv" contains groceries transaction data from which you can do EDA and pre-process the data to feed it in the apriori algorithm. But I have also added pre-processed data as "basket.csv" from which you'll just need to replace nan and encode it using TransactionEncoder after that you can feed the encoded data into the apriori algorithm.

Tables

Basket

@kaggle.rashikrahmanpritom_groceries_for_market_basket_analysismba.basket

72.43 KB
14963 rows
11 columns


CREATE TABLE basket (
  "n_0" VARCHAR,
  "n_1" VARCHAR,
  "n_2" VARCHAR,
  "n_3" VARCHAR,
  "n_4" VARCHAR,
  "n_5" VARCHAR,
  "n_6" VARCHAR,
  "n_7" VARCHAR,
  "n_8" VARCHAR,
  "n_9" VARCHAR,
  "n_10" VARCHAR
);

Groceries Data

@kaggle.rashikrahmanpritom_groceries_for_market_basket_analysismba.groceries_data

226.52 KB
38765 rows
7 columns


CREATE TABLE groceries_data (
  "member_number" BIGINT,
  "date" TIMESTAMP,
  "itemdescription" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "day_of_week" BIGINT
);