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

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

df = pd.DataFrame({'id': ["1", "2", "3","4","5"],

'mill': ["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得到如下内容：

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