{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["第一次","第二次","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"第一次","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["字段名词","含义"]
["THEMONTH_V","数据月份","移除"]
["uuid","用户id"]
["TAG_AREA_C","城市","onehot或者移除吧"]
["EVENT_CPNAME_C","产品类别","可以移除，标识当前用户订购过某个产品"]
["EVENT_SPNAME_C","产品名称","可以移除，标识当前用户订购过某个产品及其名称"]
["EVENT_CATEGORYNAME_C","产品大类","onehot"]
["EVENT_CHANNEL_C","订购渠道","移除"]
["EVENT_CHANNEL_BELONGTO_C","渠道归属（渠道大类）","onehot"]
["EVENT_ORDER_MONTH_C","该产品订购距今月份，已经做过分箱","onehot","这列应该不需要"]
["EVENT_ORDER_MONTH_V","该产品订购距今月份，原始值"]
["EVENT_CANCEL_DIFF_C","该产品退订距今月份，已经做过分箱","onehot，未退订等于直接的答案，要处理掉"]
["EVENT_CANCEL_DIFF_V","该产品退订距今月份，原始值"]
["EVENT_ORDER_PRICE_C","该产品的订购价格，已经做过分箱",null,"这列应该不需要"]
["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",null,"不使用，移除"]
["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","网络类型","2G,3G,4G,5G,未知，无法区分"]
["TAG_AGE_C","年龄","onehot，已经做了分箱"]
["EVENT_APP_USE.C","App使用情况","这个月，对应的视频APP使用的流量，对应的使用的流量已经做了分箱"]
["EVENT_APP_USE.V","App使用情况 对应的值"]
["EVENT_USER_OSTATE_C","标注-是否订购了某个APP"]

{"sheet":"第二次","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["字段名词","含义"]
["THEMONTH_V","数据月份"]
["uuid","用户id"]
["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","月使用流量","正例中有一半的人为0，那这个特征无法使用"]
["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","App使用情况"]
["EVENT_APP_USE.V","App使用情况 对应的值"]
["EVENT_USER_OSTATE_C","标注-是否订购了某个APP"]

{"sheet":"Sheet3","index":2,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["字段名词","含义"]
["THEMONTH_V","数据月份"]
["uuid","用户id"]
["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","App使用情况"]
["EVENT_APP_USE.V","App使用情况 对应的值"]
["EVENT_USER_OSTATE_C","标注-是否订购了某个APP"]