-
Notifications
You must be signed in to change notification settings - Fork 1
/
Dataset_Schema.txt
44 lines (44 loc) · 3.26 KB
/
Dataset_Schema.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|-- ONLINE_STORE_CATEGORY: string (nullable = true) - Category of the online store
|-- TRN_SLS_DTE: string (nullable = true) - Item Shipped Date
|-- TRN_STRT_TM: string (nullable = true) - Item Shipped time
|-- MSTR_PERSONA_KEY: string (nullable = true) - Customer Identification Number
|-- PRIMARY_PRODUCT_CODE: string (nullable = true) - Primary Product Code
|-- SIZE_CDE: string (nullable = true) - Size Code of the product
|-- CLOR_CDE: string (nullable = true) - COlor Code of the product
|-- DEPT_NBR: string (nullable = true) - Product Department
|-- SELLING_PRICE: string (nullable = true) - Selling price
|-- PRODUCT_CLASS_01: string (nullable = true) - Primary class of product
|-- PRODUCT_CLASS_02: string (nullable = true) - Secondary class of product
|-- BRTH_DTE: string (nullable = true) - Date of birth
|-- FMALE_IND: string (nullable = true) - Gender
|-- MRYD_IND: string (nullable = true) - Marital Status
|-- STORE_INVENTORY_CODE: string (nullable = true) - Store Inventory Identification Code
|-- ORD_DTE: string (nullable = true) - Item order date
|-- STOCK_CODE: string (nullable = true) - Inventory Code
|-- BRAND_CODE: string (nullable = true) - Brand of the product
|-- PRD_TYPE: string (nullable = true) - Product Type
|-- PRD_SUBTYPE: string (nullable = true) - Product subtype
|-- RETURN_INDICATION: string (nullable = true) - Item Return Indication
|-- RETURN_SLS_DTE: string (nullable = true) - Return Date
|-- RETURN_SLS_TM: string (nullable = true) - Return Time
|-- EDUC_LVL_NBR: string (nullable = true) - Education level of the customer
|-- MRYD: string (nullable = true) - Marital Status
|-- OCPTN_CDE: string (nullable = true) - Occupation Code
|-- AGE: string (nullable = true) - Age of the customer
|-- TOTAL_ACC_PERIOD: string (nullable = true) - Customer Active time
|-- CUSTOMER_LIFETIME: string (nullable = true) - Customer life time
|-- FREQUENCY_OF_VISIT: string (nullable = true) - Frequency of Visit
|-- CART_AMOUNT: string (nullable = true) - Cart Amount in $
|-- RETURN_LENGTH: string (nullable = true) - Return duration
|-- 2017_M7_PURCHASE_AMT: string (nullable = true) - Total purchase amount last seven months(2017)
|-- 2017_M7_RETURNED_AMT: string (nullable = true) - Total return amount last seven months(2017)
|-- 2017_M8_PURCHASE_AMT: string (nullable = true) - Total purchase amount last eight months(2017)
|-- 2017_M8_RETURNED_AMT: string (nullable = true) - Total return amount last eight months(2017)
|-- 2017_M9_PURCHASE_AMT: string (nullable = true) - Total purchase amount last nine months(2017)
|-- 2017_M9_RETURNED_AMT: string (nullable = true) - Total return amount last nine months(2017)
|-- 2017_M10_PURCHASE_AMT: string (nullable = true)- Total purchase amount last ten months(2017)
|-- 2017_M10_RETURNED_AMT: string (nullable = true) - Total return amount last ten months(2017)
|-- 2017_M11_PURCHASE_AMT: string (nullable = true)- Total purchase amount last eleven months (2017)
|-- 2017_M11_RETURNED_AMT: string (nullable = true) - Total return amount last eleven months(2017)
|-- 2017_M12_PURCHASE_AMT: string (nullable = true) - Total purchase amount last twelve months(2017)
|-- 2017_M12_RETURNED_AMT: string (nullable = true) - Total return amount last nine months(2017)