试着用.str.split
创建一个列表,用explode
:
df.assign(Position=df['Roster Position'].str.split('/')).explode('Position', ignore_index=True)
输出:
Position Name Roster Position Salary AvgPointsPerGame
0 SF LeBron James SF/PF/F/UTIL 9300 52.14
1 PF LeBron James SF/PF/F/UTIL 9300 52.14
2 F LeBron James SF/PF/F/UTIL 9300 52.14
3 UTIL LeBron James SF/PF/F/UTIL 9300 52.14
如果愿意,您可以添加.drop('Roster Position', axis=1)
以删除该列.