python提取特定字符串_pandas：在连字符之前或之后提取特定的文本，以给定的子字符串结尾...

我对pandas非常陌生&＃xff0c;有一个data frame与下面类似import pandas as pd

df &＃61; pd.DataFrame({&＃39;id&＃39;: ["1", "2", "3","4","5"],

&＃39;mill&＃39;: ["Company A Palm Oil Mill – Special Company A of CC Ltd",

"Company X POM – Company X Ltd","DDDD Mill – Company New and Old Ltd",

"Company Not Special – R Mill","Greatest Company – Great World POM"]})

id mill

0 1 Company A Palm Oil Mill – Special Company A of...

1 2 Company X POM – Company X Ltd

2 3 DDDD Mill – Company New and Old Ltd

3 4 Company Not Special – R Mill

4 5 Greatest Company – Great World POM

我想从上面的data frame得到如下内容&＃xff1a;

有没有一种简单的方法可以将这些子字符串提取到同一列中。磨坊名称有时在“-”之前&＃xff0c;有时在“-”之后&＃xff0c;但几乎总是以棕榈油磨坊、POM或mill结尾。在