df = pd.DataFrame({'型号':['212027'],'颜色':['蓝,粉,黄'],
'尺码': ['12-18M,2-3Y,3-4Y']})
要拆分数据到扩展到多行,如下图:
实现代码:
# -*- coding: utf-8 -*-
"""
Created on Mon Dec 24 19:27:35 2018
@author: Fanxiaolei
"""
import pandas as pd
df = pd.DataFrame({'型号':['212027'],'颜色':['蓝,粉,黄'],
'尺码': ['12-18M,2-3Y,3-4Y']})
s=['颜色','尺码']
df1=df.drop(columns=s,axis=1)
for x in s:
df1=df1.join(df[x].str.split(',',expand=True).stack().reset_index(level=1,drop=True).rename(x))
df1=df1.reset_index(drop=True)
print(df1)