python多行字符串分割_如何在python pandas中将字符串拆分为不同的列

我已经看过多个与此类似的堆栈溢出问题,例如,

this one

this one

. 不过,我的情况有点乏味。

我有一个由以下字符串组成的列

lineup

0 'FLEX Nick Mullens FLEX Raheem Mostert FLEX Deebo Samuel FLEX Cole Beasley FLEX Jordan Reed CPT Robbie Gould'

1 'FLEX Nick Mullens FLEX Brandon Aiyuk FLEX Cole Beasley FLEX Tyler Bass FLEX Robbie Gould CPT Raheem Mostert'

2 'FLEX Josh Allen FLEX Stefon Diggs FLEX Cole Beasley FLEX Devin Singletary FLEX Richie James CPT Bills'

...

我想将该字符串转换为多行,如下所示:

FLEX1 FLEX2 FLEX3 FLEX4 FLEX5 CPT

0 Nick Mullens Raheem Mostert Deebo Samuel Cole Beasley Jordan Reed Robbie Gould

1 Nick Mullens Brandon Aiyuk Cole Beasley Tyler Bass Robbie Gould Raheem Mostert

2 Josh Allen Stefon Diggs Cole Beasley Devin Singletary Richie James Bills

我知道如何使用

str.split()

,但我不知道如何将字符串的一部分转换为新的列。感谢任何帮助,谢谢!