这个正则表达式需要找到"1x"
或"x1"
,但它还必须能够找到两位数,例如"10x"
和"x11"
。你知道吗
leverage_match = re.compile(r"\d+X|X\d+", flags=re.IGNORECASE)
根据regex101.com,上述正则表达式应足以捕获以下对象的整数:
import pandas as pd
import re
df = pd.DataFrame(["BULL ESTOX 11X S", "BULL ESTOX X12 S"], columns=["name"])
name
"BULL ESTOX 11X S"
"BULL ESTOX X12 S"
但是,对于下面的代码,它只返回一个数字,例如,对于"11X"
,它变为"1X"
。你知道吗
leverage_match = re.compile(r"\d+X|X\d+", flags=re.IGNORECASE) #<- Same as seen above
def f(value):
f2 = lambda x: leverage_match.findall(x)[0] if len(leverage_match.findall(x)) > 0 else ""
leverage = f2(value)
if leverage != "":
return "{}".format(leverage)
if leverage[0].replace("X","x") == "x":
leverage = leverage[1]+leverage[0].replace('X','x')
df["description"] = df["name"].map(lambda x:f(x))
更新:这是完整的代码,以确保我没有遗漏任何重要内容:
import pandas as pd
import re
df = pd.DataFrame(["BULL ESTOX 11X S", "BULL ESTOX X12 S"], columns=["name"])
description_map = {"ESTOX":"Euro STOXX 50"}
underlying_match = re.compile(r"\s(\S+)\s")
leverage_match = re.compile(r"\d+X|X\d+", flags=re.IGNORECASE)
def f(value):
f1 = lambda x: description_map[underlying_match.findall(x)[0]] if underlying_match.findall(x)[0] in description_map else ""
f2 = lambda x: leverage_match.findall(x)[0] if len(leverage_match.findall(x)) > 0 else ""
f3 = lambda x: "-" if "BEAR" in x else "-" if "SHORT" in x else ""
underlying = f1(value)
leverage = f2(value)
sign = f3(value)
statement = "Tracks " + underlying
if underlying == "":
if sign == "-" and leverage == "":
return statement + "{}".format("inversely.")
if sign == "-" and leverage != "":
return statement + "{} with {}{} leverage.".format("inversely", sign, leverage)
if sign == "" and leverage != "":
return statement + "with {}{} leverage.".format(sign, leverage)
else:
return "Tracks"
if leverage[0].replace("X","x") == "x":
leverage = leverage[1]+leverage[0].replace('X','x')
if leverage != "" and sign == "-":
statement += " {} with {}{} leverage.".format("inversely", sign, leverage)
elif leverage != "" and sign == "":
statement += " with {} leverage.".format(leverage)
else:
if sign == "-":
statement += " {} ".format("inversely")
return statement
df["description"] = df["name"].map(lambda x:f(x))
print df
我认为你举了一个错误的例子,比如下面的
df
输出如下
而
x11
变为1x
,因为您的代码的逻辑在以下部分中有错误:它应该如下所示:(更新)
如果您解决了这个问题,输出将如您所期望的那样,如下所示:
完整代码
相关问题 更多 >
编程相关推荐