unsubscribe_predict/common/constant.py

general_columns = [

]

general_drop_columns = [
    "THEMONTH_V",
    "EVENT_CPNAME_C",
    "EVENT_SPNAME_C",
    "EVENT_CATEGORYNAME_C",
    "EVENT_CHANNEL_C",
    "EVENT_CHANNEL_BELONGTO_C",
    "EVENT_ORDER_MONTH_C",
    "EVENT_ORDER_MONTH_V",
    "EVENT_CANCEL_DIFF_C",
    "EVENT_CANCEL_DIFF_V",
    "EVENT_ORDER_PRICE_C",
    "EVENT_ORDER_PRICE_V",
    "EVENT_ORDER_FLOWP_C",
    "EVENT_ORDER_FLOWP_V",
    "EVENT_ORDER_STATE_C",
    "EVENT_ORDER_SUMMONTH_C",
    "EVENT_ORDER_SUMMONTH_V",
    "TAG_INTIME_V",
    "TAG_PACKAGE_C",
    "TAG_PACKAGE_PIC_C",
    "EVENT_PHONETYPE_C",
    "TAG_AREA_C",
    "EVENT_APP_USE.V",
    "I_appuse"

]

origin_column_names = [
    "THEMONTH_V",
    "uuid",
    "TAG_AREA_C",
    "EVENT_CPNAME_C",
    "EVENT_SPNAME_C",
    "EVENT_CATEGORYNAME_C",
    "EVENT_CHANNEL_C",
    "EVENT_CHANNEL_BELONGTO_C",
    "EVENT_ORDER_MONTH_C",
    "EVENT_ORDER_MONTH_V",
    "EVENT_CANCEL_DIFF_C",
    "EVENT_CANCEL_DIFF_V",
    "EVENT_ORDER_PRICE_C",
    "EVENT_ORDER_PRICE_V",
    "EVENT_ORDER_FLOWP_C",
    "EVENT_ORDER_FLOWP_V",
    "EVENT_ORDER_STATE_C",
    "EVENT_ORDER_SUMMONTH_C",
    "EVENT_ORDER_SUMMONTH_V",
    "TAG_INTIME_C",
    "TAG_INTIME_V",
    "TAG_PACKAGE_C",
    "TAG_PACKAGE_PIC_C",
    "EVENT_FLUX_C",
    "EVENT_FLUX_V",
    "EVENT_CONSUM_C",
    "EVENT_CONSUM_V",
    "EVENT_PHONETYPE_C",
    "EVENT_VIDEO_FLUX_C",
    "EVENT_VIDEO_FLUX_V",
    "EVENT_IS_ACCT_C",
    "TAG_GENDER_C",
    "TAG_PROVINCE_C",
    "TAG_NETTYPE_C",
    "TAG_AGE_C",
    "EVENT_APP_USE.C",
    "EVENT_APP_USE.V",
    "EVENT_USER_OSTATE_C",
    "I_appuse"
]

low_dim_cols = [
    "uuid",
    "MAvg_TOTAL_FLUX_1_3_zs",
    "MPer1_TOTAL_FLUX_zs",
    "MAvg_TOTAL_VIDEO_FLUX_1_3_zs",
    "MPer1_TOTAL_VIDEO_FLUX_zs",
    "MAvg_Flow_kuaishou_1_3_zs",
    "MPer1_Flow_kuaishou_zs",
    "Div_kuaishou_vFlux_1_3"
]

pkl_columns = [
    "row_id",
    "month",
    "EVENT_FLUX_V",
    "EVENT_CONSUM_V",
    "EVENT_VIDEO_FLUX_V",
    "TAG_GENDER_C_0",
    "TAG_GENDER_C_1",
    "TAG_GENDER_C_2",
    "TAG_NETTYPE_C_0",
    "TAG_NETTYPE_C_1",
    "TAG_NETTYPE_C_2",
    "TAG_NETTYPE_C_3",
    "TAG_NETTYPE_C_4",
    "TAG_AGE_C_0",
    "TAG_AGE_C_1",
    "TAG_AGE_C_2",
    "TAG_AGE_C_3",
    "TAG_AGE_C_4",
    "TAG_AGE_C_5",
    "TAG_INTIME_C_0",
    "TAG_INTIME_C_1",
    "TAG_INTIME_C_2",
    "TAG_INTIME_C_3",
    "TAG_INTIME_C_4",
    "TAG_INTIME_C_5",
    "EVENT_IS_ACCT_C_0",
    "EVENT_IS_ACCT_C_1",
    "EVENT_IS_ACCT_C_2",
    "EVENT_FLUX_C_0",
    "EVENT_FLUX_C_1",
    "EVENT_FLUX_C_2",
    "EVENT_FLUX_C_3",
    "EVENT_FLUX_C_4",
    "EVENT_FLUX_C_5",
    "EVENT_FLUX_C_6",
    "EVENT_FLUX_C_7",
    "EVENT_FLUX_C_8",
    "EVENT_CONSUM_C_0",
    "EVENT_CONSUM_C_1",
    "EVENT_CONSUM_C_2",
    "EVENT_CONSUM_C_3",
    "EVENT_CONSUM_C_4",
    "EVENT_CONSUM_C_5",
    "EVENT_CONSUM_C_6",
    "EVENT_CONSUM_C_7",
    "EVENT_VIDEO_FLUX_C_0",
    "EVENT_VIDEO_FLUX_C_1",
    "EVENT_VIDEO_FLUX_C_2",
    "EVENT_VIDEO_FLUX_C_3",
    "EVENT_VIDEO_FLUX_C_4",
    "EVENT_VIDEO_FLUX_C_5",
    "EVENT_VIDEO_FLUX_C_6",
    "EVENT_VIDEO_FLUX_C_7",
    "TAG_PROVINCE_C_0",
    "TAG_PROVINCE_C_1",
    "TAG_PROVINCE_C_2",
    "TAG_PROVINCE_C_3",
    "TAG_PROVINCE_C_4",
    "TAG_PROVINCE_C_5",
    "TAG_PROVINCE_C_6",
    "TAG_PROVINCE_C_7",
    "TAG_PROVINCE_C_8",
    "TAG_PROVINCE_C_9",
    "TAG_PROVINCE_C_10",
    "TAG_PROVINCE_C_11",
    "TAG_PROVINCE_C_12",
    "TAG_PROVINCE_C_13",
    "TAG_PROVINCE_C_14",
    "TAG_PROVINCE_C_15",
    "TAG_PROVINCE_C_16",
    "TAG_PROVINCE_C_17",
    "TAG_PROVINCE_C_18",
    "TAG_PROVINCE_C_19",
    "TAG_PROVINCE_C_20",
    "TAG_PROVINCE_C_21",
    "TAG_PROVINCE_C_22",
    "TAG_PROVINCE_C_23",
    "TAG_PROVINCE_C_24",
    "TAG_PROVINCE_C_25",
    "TAG_PROVINCE_C_26",
    "TAG_PROVINCE_C_27",
    "TAG_PROVINCE_C_28",
    "TAG_PROVINCE_C_29",
    "TAG_PROVINCE_C_30",
    "TAG_PROVINCE_C_31",
    "app_use_tencent_0",
    "app_use_tencent_1",
    "app_use_tencent_2",
    "app_use_tencent_3",
    "app_use_tencent_4",
    "app_use_tencent_5",
    "app_use_tencent_6",
    "app_use_tencent_7",
    "app_use_mangguo_0",
    "app_use_mangguo_1",
    "app_use_mangguo_2",
    "app_use_mangguo_3",
    "app_use_mangguo_4",
    "app_use_mangguo_5",
    "app_use_mangguo_6",
    "app_use_mangguo_7",
    "app_use_youku_0",
    "app_use_youku_1",
    "app_use_youku_2",
    "app_use_youku_3",
    "app_use_youku_4",
    "app_use_youku_5",
    "app_use_youku_6",
    "app_use_youku_7",
    "app_use_iqiyi_0",
    "app_use_iqiyi_1",
    "app_use_iqiyi_2",
    "app_use_iqiyi_3",
    "app_use_iqiyi_4",
    "app_use_iqiyi_5",
    "app_use_iqiyi_6",
    "app_use_iqiyi_7",
    "app_use_bilibili_0",
    "app_use_bilibili_1",
    "app_use_bilibili_2",
    "app_use_bilibili_3",
    "app_use_bilibili_4",
    "app_use_bilibili_5",
    "app_use_bilibili_6",
    "app_use_bilibili_7",
    "app_use_kuaishou_0",
    "app_use_kuaishou_1",
    "app_use_kuaishou_2",
    "app_use_kuaishou_3",
    "app_use_kuaishou_4",
    "app_use_kuaishou_5",
    "app_use_kuaishou_6",
    "app_use_kuaishou_7"
]

process_column_names = [
    "row_id",
    "month",
    "EVENT_CATEGORYNAME_C",
    "EVENT_CHANNEL_BELONGTO_C",
    "EVENT_CANCEL_DIFF_C",
    "TAG_INTIME_C",
    "EVENT_FLUX_C",
    "EVENT_FLUX_V",
    "EVENT_CONSUM_C",
    "EVENT_CONSUM_V",
    "EVENT_VIDEO_FLUX_C",
    "EVENT_VIDEO_FLUX_V",
    "TAG_GENDER_C",
    "TAG_NETTYPE_C",
    "TAG_AGE_C",
    "app_use_tencent",
    "app_use_mangguo",
    "app_use_youku",
    "app_use_iqiyi",
    "app_use_bilibili",
    "app_use_kuaishou"
]

feature_column_names = [
    "row_id",
    "month",
    "TAG_INTIME_C_0",
    "TAG_INTIME_C_1",
    "TAG_INTIME_C_2",
    "TAG_INTIME_C_3",
    "TAG_INTIME_C_4",
    "TAG_INTIME_C_5",
    "EVENT_FLUX_C",
    "EVENT_FLUX_V",
    "EVENT_CONSUM_V",
    "EVENT_VIDEO_FLUX_V",
    "EVENT_CONSUM_C",
    "EVENT_VIDEO_FLUX_C",
    "app_use_tencent",
    "app_use_mangguo",
    "app_use_youku",
    "app_use_iqiyi",
    "app_use_bilibili",
    "app_use_kuaishou",
    "TAG_GENDER_C_0",
    "TAG_GENDER_C_1",
    "TAG_GENDER_C_2",
    "TAG_NETTYPE_C_1",
    "TAG_NETTYPE_C_2",
    "TAG_NETTYPE_C_3",
    "TAG_NETTYPE_C_4",
    "TAG_NETTYPE_C_5",
    "EVENT_CATEGORYNAME_C_0",
    "EVENT_CATEGORYNAME_C_1",
    "EVENT_CATEGORYNAME_C_2",
    "EVENT_CATEGORYNAME_C_3",
    "EVENT_CATEGORYNAME_C_4",
    "EVENT_CATEGORYNAME_C_5",
    "EVENT_CATEGORYNAME_C_6",
    "EVENT_CATEGORYNAME_C_7",
    "EVENT_CATEGORYNAME_C_8",
    "EVENT_CATEGORYNAME_C_9",
    "EVENT_CATEGORYNAME_C_10",
    "EVENT_CHANNEL_BELONGTO_C_0",
    "EVENT_CHANNEL_BELONGTO_C_1",
    "EVENT_CHANNEL_BELONGTO_C_2",
    "EVENT_CHANNEL_BELONGTO_C_3",
    "EVENT_CHANNEL_BELONGTO_C_4",
    "EVENT_CHANNEL_BELONGTO_C_5",
    "EVENT_CHANNEL_BELONGTO_C_6",
    "TAG_AGE_C_0",
    "TAG_AGE_C_1",
    "TAG_AGE_C_2",
    "TAG_AGE_C_3",
    "TAG_AGE_C_4",
    "TAG_AGE_C_5",
    "EVENT_CANCEL_DIFF_C_0",
    "EVENT_CANCEL_DIFF_C_1",
    "EVENT_CANCEL_DIFF_C_2",
    "EVENT_CANCEL_DIFF_C_3",
    "EVENT_CANCEL_DIFF_C_4",
    "EVENT_CANCEL_DIFF_C_5",
    "EVENT_CANCEL_DIFF_C_6"
]

insert_origin_tb_name = "lu_origin_data_neg"
insert_pos_tb_name = "lu_pos_data_0218_07"
insert_pos_tb_test_name = "lu_pos_data_test_7"
insert_neg_tb_test_name = "lu_neg_data_test_7"
insert_neg_tb_name = "lu_neg_data_0218_07"


def is_number(s):
    try:
        float(s)
        return True
    except ValueError:
        pass

    try:
        import unicodedata
        unicodedata.numeric(s)
        return True
    except (TypeError, ValueError):
        pass

    return False