Python按特定字符分列

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]