python - 从另一列的子字符串创建列

Question

我有一个 Pandas 数据框对象。我想从现有列的子字符串创建新列。我的数据如下所示:

    Date        variable                 want1          want2   want3
0   02-01-08    Australia - Sydney - A   Australia      Sydney  A
1   03-01-08    Australia - Sydney - A   Australia      Sydney  A
2   04-01-08    Australia - Sydney - A   Australia      Sydney  A
3   05-01-08    Canada - Toronto - B     Canada         Toronto B
4   06-01-08    Canada - Toronto - B     Canada         Toronto B

want1 到 want3 是我需要的。

Answer 1

为此，您可以使用 pd.Series.str.split:

df[['want1', 'want2', 'want3']] = df['variable'].str.split(' - ', expand=True)