如何分割列，但保留每个条目的键？

Question

我有一个像这样的数据文件：

df = pd.DataFrame({"ID": ["P-1", "P-2", "P-3"], "Acc No": ['11234/57468/28576', '13245/13246', '46578/37264/35264'], "Company": ["red", "yellow", "blue"]})

print(df)

我想把'Acc No‘列分隔开，这样每个条目都可以保存其余列的数据。

df2 = pd.DataFrame({"ID": ["P-1","P-1","P-1", "P-2","P-2", "P-3","P-3","P-3"], "Acc No": ['11234','57468','28576', '13245','13246', '46578','37264','35264'], "Company": ["red", "red","red","yellow", "yellow", "blue", "blue", "blue"]})

print(df2)

我已经试过把Acc号分开了。列，但我无法找到将新列与现有数据匹配的正确方法。

我该怎么做？

Answer 1

试试这个：

#df

ID  Acc No                  Company
0   P-1 11234/57468/28576   red
1   P-2 13245/13246         yellow
2   P-3 46578/37264/35264   blue

df['Acc No'] = df['Acc No'].str.split('/')

#df
    ID  Acc No                  Company
0   P-1 [11234, 57468, 28576]   red
1   P-2 [13245, 13246]          yellow
2   P-3 [46578, 37264, 35264]   blue

df.explode('Acc No')

    ID  Acc No  Company
0   P-1 11234   red
0   P-1 57468   red
0   P-1 28576   red
1   P-2 13245   yellow
1   P-2 13246   yellow
2   P-3 46578   blue
2   P-3 37264   blue
2   P-3 35264   blue