Python里面如何引用几列的数据呢,求问这串代码应该如何修改
检查一下R F M列的类型,是不是数值型,可以通过tb.dtype查看
import pandas as pd
# 假设已经有一个DataFrame对象tb
# 定义一个函数,根据其他列的值计算新增列的值
def functions(x):
if x.iloc["R"]==1 and x.iloc["F"]==1 and x.iloc["M"]==1:
return "重要价值客户"
elif x.iloc["R"]==1 and x.iloc["F"]==1 and x.iloc["M"]==1:
return "重要发展客户"
elif x.iloc["R"]==1 and x.iloc["F"]==1 and x.iloc["M"]==1:
return "重要保持客户"
elif x.iloc["R"]==1 and x.iloc["F"]==1 and x.iloc["M"]==0:
return "重要挽留客户"
elif x.iloc["R"]==1 and x.iloc["F"]==0 and x.iloc["M"]==1:
return "一般价值客户"
elif x.iloc["R"]==1 and x.iloc["F"]==0 and x.iloc["M"]==1:
return "一般发展客户"
elif x.iloc["R"]==1 and x.iloc["F"]==0 and x.iloc["M"]==1:
return "一般保持客户"
elif x.iloc["R"]==1 and x.iloc["F"]==0 and x.iloc["M"]==0:
return "一般挽留客户"
# 新增一列,并根据函数计算该列的值
tb["RFM"] = tb[["R", "F", "M"]].apply(functions, axis=1)