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