如何对列值进行操作，列值是一个列表

Question

我有一个dataframe，其中一列是list。我要遍历每一行，在列表中找到一个以字母“a”开头的字符串，删除斜杠“/”后面的所有内容

    Index      Entities
     0        ["Apple/1", "Applet/87", "Book/12", "Stable/0"]
     1        ["App/12", "orange/6", "Apples/7", "Stables/0"]

将此数据帧作为输入，我希望新的数据帧如下所示：

      Index      Entities
     0        ["Apple", "Applet", "Book/12", "Stable/0"]
     1        ["App", "orange/6", "Apples", "Stables/0"]

Answer 1

IIUC

[[y.split('/', 1)[0] if y.startswith('A') else y for y in row] for row in df.Entities]

[['Apple', 'Applet', 'Book/12', 'Stable/0'],
 ['App', 'orange/6', 'Apples', 'Stables/0']]

---

df.assign(
    Entities=[
        [y.split('/', 1)[0] if y.startswith('A') else y
         for y in row] for row in df.Entities
    ]
)

   Index                            Entities
0      0  [Apple, Applet, Book/12, Stable/0]
1      1  [App, orange/6, Apples, Stables/0]