经过人指点,解决了一个问题
使用数据集air_data.csv
为了程序运行需要,仅给出一部分数据集
MEMBER_NO
FFP_DATE
FIRST_FLIGHT_DATE
GENDER
FFP_TIER
WORK_CITY
WORK_PROVINCE
WORK_COUNTRY
AGE
LOAD_TIME
FLIGHT_COUNT
BP_SUM
EP_SUM_YR_1
EP_SUM_YR_2
SUM_YR_1
SUM_YR_2
SEG_KM_SUM
WEIGHTED_SEG_KM
LAST_FLIGHT_DATE
AVG_FLIGHT_COUNT
AVG_BP_SUM
BEGIN_TO_FIRST
LAST_TO_END
AVG_INTERVAL
MAX_INTERVAL
ADD_POINTS_SUM_YR_1
ADD_POINTS_SUM_YR_2
EXCHANGE_COUNT
avg_discount
P1Y_Flight_Count
L1Y_Flight_Count
P1Y_BP_SUM
L1Y_BP_SUM
EP_SUM
ADD_Point_SUM
Eli_Add_Point_Sum
L1Y_ELi_Add_Points
Points_Sum
L1Y_Points_Sum
Ration_L1Y_Flight_Count