Skip to main content
 首页 » 编程设计

python之Pandas:有条件地从列内容生成描述

2024年10月24日21bjzhanghao

我正在尝试解决使用 pandas regex 的函数的一些问题通过str.extract获取列中的每一行 "name"生成列 "description" .我正在使用 regex而不是 split因为代码必须能够管理各种格式。

必须修改函数以确认各种条件。

数据框:

import pandas as pd 
import re 
 
df = pd.DataFrame(["LONG AXP UN X3 VON", "SHORT BIDU UN 5x VON", "SHORT GOOG VON", "LONG GOOG VON"], columns=["name"]) 

输入:

name 
"LONG AXP UN X3 VON" 
"SHORT BIDU UN 5x VON" 
"SHORT GOOG VON" 
"LONG GOOG VON" 

当前代码:

description_map = {"AXP":"American Express", "BIDU":"Baidu"} 
sign_map = {"LONG": "", "SHORT": "-"} 
def f(strseries): 
    stock = strseries.str.extract(r"\s(\S+)\s").map(description_map) 
    leverage = strseries.str.extract(r"(X\d+|\d+X)\s", flags=re.IGNORECASE) 
    sign = strseries.str.extract(r"(\S+)\s").map(sign_map) 
    return "Tracks " + stock + " with " + sign + leverage + " leverage" 
 
df["description"] = f(df["name"]) 

当前输出:

name                        description 
"LONG AXP UN X3 VON"        "Tracks American Express with X3 leverage" 
"SHORT BIDU UN 5x VON"      "Tracks Baidu with -5x leverage" 
"SHORT GOOG VON"            "" 
"LONG GOOG VON"             "" 

期望的输出:

name                        description 
"LONG AXP UN X3 VON"        "Tracks American Express with 3x leverage" 
"SHORT BIDU UN 5x VON"      "Tracks Baidu inversely with -5x leverage" 
"SHORT GOOG VON"            "Tracks inversely" 
"LONG GOOG VON"             "Tracks" 

影响:

  • 如果sign是"-" , 我怎样才能让它添加 direction = "inversely"进入字符串?
  • 如果没有stock在 name 中匹配带字典description_map : 设置 stock = ""并返回字符串。
  • 如果没有leverage在 name 中找到: 忽略部分 "with" + sign + leverage + " leverage" .
  • 拆分并重新排序 sign + leverage这样它总是以-5x"的顺序显示不管它是否输入为 "SHORT X5" .

请您参考如下方法:

我花了一些时间写这个函数:

description_map = {"AXP":"American Express", "BIDU":"Baidu"} 
sign_map = {"LONG": "", "SHORT": "-"} 
 
stock_match = re.compile(r"\s(\S+)\s") 
leverage_match = re.compile("[0-9]x|x[0-9]|X[0-9]|[0-9]X") 
 
def f(value): 
 
    f1 = lambda x: description_map[stock_match.findall(x)[0]] if stock_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 'SHORT' in x else '' 
 
    stock = f1(value) 
    leverage = f2(value) 
    sign = f3(value) 
 
    statement = "Tracks " + stock 
 
    if stock == "": 
        if sign == '-': 
            return statement + "{}".format('inversely') 
        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)) 

输出:

In [97]: %paste 
import pandas as pd 
import re 
 
df = pd.DataFrame(["LONG AXP UN X3 VON", "SHORT BIDU UN 5x VON", "SHORT GOOG VON", "LONG GOOG VON"], columns=["name"]) 
 
## -- End pasted text -- 
 
In [98]: df 
Out[98]:  
                   name 
0    LONG AXP UN X3 VON 
1  SHORT BIDU UN 5x VON 
2        SHORT GOOG VON 
3         LONG GOOG VON 
 
In [99]: df["description"] = df["name"].map(lambda x:f(x)) 
 
In [100]: df 
Out[100]:  
                   name                               description 
0    LONG AXP UN X3 VON  Tracks American Express with 3x leverage 
1  SHORT BIDU UN 5x VON  Tracks Baidu inversely with -5x leverage 
2        SHORT GOOG VON                          Tracks inversely 
3         LONG GOOG VON                                    Tracks