工作时需要把一堆混在一起的衍生变量归类,并对应其归属的数据源:
方法1:excel的分列功能,选择分隔符号(TAB&逗号),然后一步一步往下走即可。接着把分隔好的单元格全部复制,粘贴复制成列——筛选排序即可。
方法2:python实现
# 列表排序
list=['topup_0_30_avg_rate_180_360', 'phoneinquiries_3d_rate_360', 'topup_0_30_times_std_60_90', 'topup_30_60_avg_std_180_360', 'topup_30_60_times_std_60_90', 'idinquiriesuname_30d_std_90', 'phoneinquiriesuname_21d_std_60', 'C_PI_3d_std_180', 'ece', 'topup_0_360_min', 'identity_province', 'whatsapp_company_account', 'A_PI_14d_std_30', 'topup_60_90_times_rate_90_180', 'topup_0_30_avg_rate_0_180', 'preference_bank_270d', 'b_class', 'A_II_3d_std_14', 'phonealive_id_num', 'whatsapp_updatestatus_time', 'phonealive_phone_num', 'topup_30_60_max_std_180_360', 'cashLoanFeature_30', 'phoneinquiries_14d_std_21', 'A_II_21d_std_30', 'B_II_180d_rate_360', 'topup_0_360_times_rate_90_180', 'phonecount', 'screenRes', 'ect', 'b_membership', 'multiidinquiries_total', 'whatsapp_avatar', 'networkType', 'A_II_14d_std_21', 'cpuFrequency']
list.sort()
for i in list:
print(i)
print("") #排出来的顺序是大写字母A-Z,小写字母a-z的,
list.sort() :对 list排序,直接改变my_list
sorted(list) :对list排序,以返回值返回排序结果,并不改变list