我正在努力理解Lambdas的功能,因为它与Pandas 有关. 我正在try 创建一个新的专栏,基于(A)栏中是否出现某个词("上诉"、"审计"、"判断")
但是,我收到以下错误:
AttributeError:‘Str’对象没有属性‘str’
d = {"A":["Assessment Division","Division of Appeals","Calgary Audit","Halifax Market","Georgian Markers"],
"B":[100,300,400,500,400]
sample = pd.DataFrame(d)
sample["results"] = sample["A"].apply(lambda x: "Invoice" if x.str.contains("Audit") or x.str.contains("Appeals") or x.str.contains("Assessment") else "NoAction")
我还try 这样做,试图缩短代码,但收到了相同的错误:
d = {"A":["Assessment Division","Division of Appeals","Calgary Audit","Halifax Market","Georgian Markers"],
"B":[100,300,400,500,400]
sample = pd.DataFrame(d)
reqs = ["Audit","Appeals","Assessment"]
sample["results"] = sample["A"].apply(lambda x: "Invoice" if x.str.contains().isin(reqs) else "NoAction")