Skip to main content
 首页 » 编程设计

python之Pandas 将包含带分号的字符串的列分隔为多列

2025年02月15日23langtianya

我无法拆分包含分号的 Pandas 系列。是因为我使用列名('Social_Media')作为索引还是因为 python 不会将分号识别为拆分字符?还是我的脚本有问题?

#Filters the NaN columns 
df2 = df[df['Social_Media'].notnull()] 
# Splitter for semicolon 
df2['Social_Media'].apply(lambda x: x.split(';')[0]) 
 
#This is my output after the split 
Timestamp                              
2017-06-01 18:10:46          Twitter;Facebook;Instagram;WhatsApp;Google+ 
2017-06-01 19:24:04          Twitter;Facebook;Instagram;WhatsApp;Google+ 
2017-06-01 19:25:21          Twitter;Facebook;Instagram;WhatsApp;Google+ 

我需要看到的输出。

Timestamp                    name_a  name_b   name_c    name_d   name_e 
2017-06-01 18:10:46          Twitter Facebook Instagram WhatsApp Google+ 
2017-06-01 19:24:04          Twitter Facebook Instagram WhatsApp Google+ 
2017-06-01 19:25:21          Twitter Facebook Instagram WhatsApp Google+ 

请您参考如下方法:

您可以使用 str.split

df = df['Social_Media'].str.split(';', expand=True).add_prefix('name_') 
print (df) 
                      name_0    name_1     name_2    name_3   name_4 
Timestamp                                                            
2017-06-01 18:10:46  Twitter  Facebook  Instagram  WhatsApp  Google+ 
2017-06-01 19:24:04  Twitter  Facebook  Instagram  WhatsApp  Google+ 
2017-06-01 19:25:21  Twitter  Facebook  Instagram  WhatsApp  Google+ 

对于按字母排列的列名:

import string 
L = list(string.ascii_lowercase) 
names = dict(zip(range(len(L)), ['name_' + x for x in  L])) 
 
df = df['Social_Media'].str.split(';', expand=True).rename(columns=names) 
print (df) 
                      name_a    name_b     name_c    name_d   name_e 
Timestamp                                                            
2017-06-01 18:10:46  Twitter  Facebook  Instagram  WhatsApp  Google+ 
2017-06-01 19:24:04  Twitter  Facebook  Instagram  WhatsApp  Google+ 
2017-06-01 19:25:21  Twitter  Facebook  Instagram  WhatsApp  Google+