当值相同时，如何拆分列？

Question

我正在拆分数据框中的一列，该列有相似的单词，但只有最后几个单词不同。我试着把常见的单词分成一列，而不同的单词则是另一列

这就是数据帧的样子

**Column1**   
InitialCharms::Charm::AAAAAA
InitialCharms::Charm::BBBBBB
InitialCharms::Charm::CCCCCC
InitialCharms::Charm::DDDDDD
InitialCharms::Charm::EEEEEE
InitialCharms::Charm::FFFFFF
InitialCharms::Charm::GGGGGG
InitialCharms::Charm::HHHHHH
InitialCharms::Charm::IIIIII
InitialCharms::Charm::JJJJJJ
InitialCharms::Charm::KKKKKK
InitialCharms::Charm::LLLLLL  

The Expected output:  

**Column1**              **Column2**  
InitialCharms             AAAAA  
InitialCharms             BBBBB  
InitialCharms             CCCCC  

我在用熊猫

Answer 1

试试这个

df['NewColumn1'] = df['Column1'].str.split('::').str[0]
df['NewColumn2'] = df['Column1'].str.split('::').str[-1]

Answer 2

使用^{}，如有必要，通过drop删除第二列：

df1 = df['Column1'].str.split('::', expand=True).drop(1, axis=1)

或：

df1 = df['Column1'].str.split('::Charm::', expand=True)

---

df1.columns = ['Col1','Col2']
print (df1)
             Col1    Col2
0   InitialCharms  AAAAAA
1   InitialCharms  BBBBBB
2   InitialCharms  CCCCCC
3   InitialCharms  DDDDDD
4   InitialCharms  EEEEEE
5   InitialCharms  FFFFFF
6   InitialCharms  GGGGGG
7   InitialCharms  HHHHHH
8   InitialCharms  IIIIII
9   InitialCharms  JJJJJJ
10  InitialCharms  KKKKKK
11  InitialCharms  LLLLLL