BrandCultivationDataAnalysis/database/feature.py

class CustConfig:
    FEATURES_COLUMNS = [
        "cust_uuid",                    # 客户唯一标识
        "cust_code",                    # 零售户编码
        "busi_place_area_section",      # 营业面积区间
        "rent_section",                 # 租金区间
        "rent_price_section",           # 租金单价区间
        "busi_open_section",            # 营业开始时间区间
        "busi_close_section",           # 营业结束时间区间
        "is_chain_storename",           # 是否连锁
        "criterion_codename",           # 守法经营情况
        "market_info_codename",         # 市场采集点情况
        "tag_codename",                 # 卷烟价格执行情况
        "cooperate_codename",           # 配合程度
        "store_appearance_name",        # 店面形象
        "position_codename",            # 商圈名称
        "sub_position_codename",        # 次级商圈名称
        "zone_appraise_name",           # 地段评价
        "choose_road_name",             # 路段评价
        "choose_address_name",          # 选址
        "area_position_type_name",      # 区域位置划分
        "area_func_type_name",          # 区域功能划分
        "community_func_type_name",     # 社区功能划分
        "rate_pay_type_name",           # 纳税性质
        "order_cycle_type_name",        # 订货周期
        "is_modern_terminalname",       # 是否现代终端
        "modern_terminal_name",         # 现代终端类型
        "cooperate_type_name",          # 加盟类型
        "terminal_star_name",           # 终端星级
        "star_terminal_name",           # 星级终端类型
        "appearance_span_section",      # 门面跨度区间
        "upholster_name",               # 店内装潢名称
        "shop_feature_name",            # 门店特色名称
        "shop_char_type_name",          # 经营特色名称
        "has_taste_name",               # 是否卷烟品吸区
        "show_area_section",            # 卷烟成列面积区间
        "sign_status_name",             # 是否有店招门头（店招门头状态）
        "shopsunny_vi_name",            # 现代终端VI门头名称
        "header_name",                  # 门头标识
        "counter_status_name",          # 地柜状态
        "counter_number",               # 地柜个数
        "counter_put_type_name",        # 地柜陈列样式
        "back_counter_status_name",     # 背柜状态
        "back_counter_put_type_name",   # 背柜陈列样式
        "back_counter_style_name",      # 背柜样式
        "back_counter_number",          # 背柜个数
        "back_counter_has_show_name",   # 背柜条烟陈列区状态
        "legal_person_gender",          # 法人性别
        "legal_education_name",         # 法人文化程度
        "legal_is_cpc_member",          # 法人是否为党员
        "operator_person_gender",       # 经营者性别
        "operator_education_name",      # 经营者文化程度
        "operator_is_cpc_member",       # 经营者是否为党员
        "market_type_name",             # 市场类型名称
        "busi_place_codename",          # 经营业态名称
        "sub_busi_codename",            # 业态细分名称
        "sub_market_type_name",         # 城乡分类名称
        "creditclass_name",             # 信用等级名称
    ]
    
    ONEHOT_CAT = {
        "busi_place_area_section":      ["0", "10（含）㎡以下", "10-20（含）㎡", "20-30（含）㎡", "30-40（含）㎡", "40-50（含）㎡", "50-60（含）㎡", 
                                         "60-70（含）㎡", "70-80（含）㎡", "80-90（含）㎡", "90-100（含）㎡", "100㎡以上"],
        "rent_section":                 ["0", "500（含）元以下", "500-1000（含）元", "1000-1500（含）元", "1500-2000（含）元", "2000-2500（含）元", 
                                         "2500-3000（含）元", "3000-3500（含）元", "3500-4000（含）元", "4000-4500（含）元", "4500-5000（含）元", "5000元以上"],
        "rent_price_section":           ["0", "500（含）元/㎡以下", "500-1000（含）元/㎡", "1000-1500（含）元/㎡", "1500-2000（含）元/㎡", "2000-2500（含）元/㎡", 
                                         "2500-3000（含）元/㎡", "3000-3500（含）元/㎡", "3500-4000（含）元/㎡", "4000-4500（含）元/㎡", "4500-5000（含）元/㎡", "5000元/㎡以上"],
        "busi_open_section":            ["未知区间", "0:00~1:00", "1:00~2:00", "2:00~3:00", "3:00~4:00", "4:00~5:00", "5:00~6:00", "6:00~7:00", "7:00~8:00", "8:00~9:00", 
                                         "9:00~10:00", "10:00~11:00", "11:00~12:00", "12:00~13:00", "13:00~14:00", "14:00~15:00", "15:00~16:00", "16:00~17:00", "17:00~18:00", 
                                         "18:00~19:00", "19:00~20:00", "20:00~21:00", "21:00~22:00", "22:00~23:00", "23:00~0:00"],
        "busi_close_section":           ["未知区间", "0:00~1:00", "1:00~2:00", "2:00~3:00", "3:00~4:00", "4:00~5:00", "5:00~6:00", "6:00~7:00", "7:00~8:00", "8:00~9:00", 
                                         "9:00~10:00", "10:00~11:00", "11:00~12:00", "12:00~13:00", "13:00~14:00", "14:00~15:00", "15:00~16:00", "16:00~17:00", "17:00~18:00", 
                                         "18:00~19:00", "19:00~20:00", "20:00~21:00", "21:00~22:00", "22:00~23:00", "23:00~0:00"],
        "is_chain_storename":           ["是", "否"],
        "criterion_codename":           ["1年以内无违法违规情况", "1-3年无违法违规", "3年以上无违法违规情况", "违规"],
        "market_info_codename":         "市场采集点情况",
        "tag_codename":                 "卷烟价格执行情况",
        "cooperate_codename":           "配合程度",
        "store_appearance_name":        "店面形象",
        "position_codename":            "商圈名称",
        "sub_position_codename":        "次级商圈名称",
        "zone_appraise_name":           "地段评价",
        "choose_road_name":             "路段评价",
        "choose_address_name":          "选址",
        "area_position_type_name":      "区域位置划分",
        "area_func_type_name":          "区域功能划分",
        "community_func_type_name":     "社区功能划分",
        "rate_pay_type_name":           "纳税性质",
        "order_cycle_type_name":        "订货周期",
        "is_modern_terminalname":       "是否现代终端",
        "modern_terminal_name":         "现代终端类型",
        "cooperate_type_name":          "加盟类型",
        "terminal_star_name":           "终端星级",
        "star_terminal_name":           "星级终端类型",
        "appearance_span_section":      "门面跨度区间",
        "upholster_name":               "店内装潢名称",
        "shop_feature_name":            "门店特色名称",
        "shop_char_type_name":          "经营特色名称",
        "has_taste_name":               "是否卷烟品吸区",
        "show_area_section":            "卷烟成列面积区间",
        "sign_status_name":             "是否有店招门头（店招门头状态）",
        "shopsunny_vi_name":            "现代终端VI门头名称",
        "header_name":                  "门头标识",
        "counter_status_name":          "地柜状态",
        "counter_number":               "地柜个数",
        "counter_put_type_name":        "地柜陈列样式",
        "back_counter_status_name":     "背柜状态",
        "back_counter_put_type_name":   "背柜陈列样式",
        "back_counter_style_name":      "背柜样式",
        "back_counter_number":          "背柜个数",
        "back_counter_has_show_name":   "背柜条烟陈列区状态",
        "legal_person_gender":          "法人性别",
        "legal_education_name":         "法人文化程度",
        "legal_is_cpc_member":          "法人是否为党员",
        "operator_person_gender":       "经营者性别",
        "operator_education_name":      "经营者文化程度",
        "operator_is_cpc_member":       "经营者是否为党员",
        "market_type_name":             "市场类型名称",
        "busi_place_codename":          "经营业态名称",
        "sub_busi_codename":            "业态细分名称",
        "sub_market_type_name":         "城乡分类名称",
        "creditclass_name":             "信用等级名称"
    }
    
    FEATURES_MAP = {
        "cust_uuid":                    "客户唯一标识",
        "cust_code":                    "零售户编码",
        "busi_place_area_section":      "营业面积区间",
        "rent_section":                 "租金区间",
        "rent_price_section":           "租金单价区间",
        "busi_open_section":            "营业开始时间区间",
        "busi_close_section":           "营业结束时间区间",
        "is_chain_storename":           "是否连锁",
        "criterion_codename":           "守法经营情况",
        "market_info_codename":         "市场采集点情况",
        "tag_codename":                 "卷烟价格执行情况",
        "cooperate_codename":           "配合程度",
        "store_appearance_name":        "店面形象",
        "position_codename":            "商圈名称",
        "sub_position_codename":        "次级商圈名称",
        "zone_appraise_name":           "地段评价",
        "choose_road_name":             "路段评价",
        "choose_address_name":          "选址",
        "area_position_type_name":      "区域位置划分",
        "area_func_type_name":          "区域功能划分",
        "community_func_type_name":     "社区功能划分",
        "rate_pay_type_name":           "纳税性质",
        "order_cycle_type_name":        "订货周期",
        "is_modern_terminalname":       "是否现代终端",
        "modern_terminal_name":         "现代终端类型",
        "cooperate_type_name":          "加盟类型",
        "terminal_star_name":           "终端星级",
        "star_terminal_name":           "星级终端类型",
        "appearance_span_section":      "门面跨度区间",
        "upholster_name":               "店内装潢名称",
        "shop_feature_name":            "门店特色名称",
        "shop_char_type_name":          "经营特色名称",
        "has_taste_name":               "是否卷烟品吸区",
        "show_area_section":            "卷烟成列面积区间",
        "sign_status_name":             "是否有店招门头（店招门头状态）",
        "shopsunny_vi_name":            "现代终端VI门头名称",
        "header_name":                  "门头标识",
        "counter_status_name":          "地柜状态",
        "counter_number":               "地柜个数",
        "counter_put_type_name":        "地柜陈列样式",
        "back_counter_status_name":     "背柜状态",
        "back_counter_put_type_name":   "背柜陈列样式",
        "back_counter_style_name":      "背柜样式",
        "back_counter_number":          "背柜个数",
        "back_counter_has_show_name":   "背柜条烟陈列区状态",
        "legal_person_gender":          "法人性别",
        "legal_education_name":         "法人文化程度",
        "legal_is_cpc_member":          "法人是否为党员",
        "operator_person_gender":       "经营者性别",
        "operator_education_name":      "经营者文化程度",
        "operator_is_cpc_member":       "经营者是否为党员",
        "market_type_name":             "市场类型名称",
        "busi_place_codename":          "经营业态名称",
        "sub_busi_codename":            "业态细分名称",
        "sub_market_type_name":         "城乡分类名称",
        "creditclass_name":             "信用等级名称"
    }