Python按特定字符分列
分割前
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/72b280462e21c068de90c089d14ca152.png)
分割后
import re
# Python根据字符分割字符串
newDF = data[ '购买物品的品类'].str.split('-')
newDF
导入到数据框
# 获得最大的列数
S = []
for i in range(len(newDF)):
i = len(newDF[i])
S.append(i)
s = np.max(S)
s
# 构建新列
data[ '品类1'] = 'null'
data[ '品类2'] = 'null'
data[ '品类3'] = 'null'
data[ '品类4'] = 'null'
data[ '品类5'] = 'null'
# 为新列填充数据
for i in range(len(newDF)):
for j in range(1, len(newDF[i])+1):
data['品类' + np.str(j)][i] = newDF[i][j-1]
data[:5]