writer = pd.ExcelWriter('group_freq.xlsx')
#etc逾期账单占比
od_bill_cnt_ratio_grp = pd.crosstab(df.od_bill_cnt_ratio_grp,bigtable_11.bad_flag, margins=True)
od_bill_cnt_ratio_grp.to_excel(writer,sheet_name="od_bill_cnt_ratio_grp")
#etc_mob_up
etc_mob_up_grp = pd.crosstab(df.etc_mob_up_grp,bigtable_11.bad_flag, margins=True)
etc_mob_up_grp.to_excel(writer,sheet_name="etc_mob_up_grp")
writer.save()
如果不含列名
numerical_var_new = pd.read_excel("var_class.xlsx",sheetname="numerical_var",header=None)