注意列值不为string请自行转换
# 以a段值为index建立,此时level=1
test = [{"a":1,"c":1,"b":"1,2,3"},{"a":2,"c":1,"b":"4,5,6"}]
test = pd.DataFrame(test)
test = (test .set_index(['a'])['b']
.str.split(',', expand=True)
.stack()
.reset_index(level=1, drop=True)
.reset_index(name='rdata'))
# 保留两列值,level=2
test = [{"a":1,"c":1,"b":"1,2,3"},{"a":2,"c":1,"b":"4,5,6"}]
test = pd.DataFrame(test)
test = (test .set_index(['a','c'])['b']
.str.split(',', expand=True)
.stack()