Retail Sales Data

Retail data from Turkish sector

@kaggle.berkayalan_retail_sales_data

Table List

2 tables(26.02 KB)

Product Hierarchy

@kaggle.berkayalan_retail_sales_data.product_hierarchy

21.47 KB
699 rows
10 columns

product_id Product Id	product_length Product Length	product_depth Product Depth	product_width Product Width	cluster_id Cluster Id	hierarchy1_id Hierarchy1 Id	hierarchy2_id Hierarchy2 Id	hierarchy3_id Hierarchy3 Id	hierarchy4_id Hierarchy4 Id	hierarchy5_id Hierarchy5 Id
P0000	5	20	12	nan	H00	H0004	H000401	H00040105	H0004010534
P0001	13.5	22	20	cluster_5	H01	H0105	H010501	H01050100	H0105010006
P0002	22	40	22	cluster_0	H03	H0315	H031508	H03150800	H0315080028
P0004	2	13	4	cluster_3	H03	H0314	H031405	H03140500	H0314050003
P0005	16	30	16	cluster_9	H03	H0312	H031211	H03121109	H0312110917
P0006	8.5	15	15	cluster_0	H03	H0316	H031608	H03160817	H0316081708
P0007	2	22	9.5	cluster_4	H03	H0313	H031305	H03130519	H0313051904
P0008	5	16	5	cluster_0	H00	H0000	H000004	H00000400	H0000040017
P0009	5	18	14	cluster_6	H00	H0002	H000201	H00020100	H0002010012
P0010	2	22	3	cluster_0	H01	H0108	H010801	H01080109	H0108010917


CREATE TABLE product_hierarchy (
  "product_id" VARCHAR,
  "product_length" DOUBLE,
  "product_depth" DOUBLE,
  "product_width" DOUBLE,
  "cluster_id" VARCHAR,
  "hierarchy1_id" VARCHAR,
  "hierarchy2_id" VARCHAR,
  "hierarchy3_id" VARCHAR,
  "hierarchy4_id" VARCHAR,
  "hierarchy5_id" VARCHAR
);