假设有表格某一单元格存在数据如下:
Argument
In,AAA,xx;
Out,BBB,yy;
# Argument
#0 In,AAA,xx;
# Out,BBB,yy
想得到表格如下:
# name type value
#0 In AAA xx
#1 Out BBB yy
name type value
In AAA xx
Out BBB yy
#假设数据源Dataframe为obj_df
#取单元各0行'Argument'列数据,作成Series
objArgu_Ser = pd.Series(data=obj_df.loc[0]['Argument'],dtype = "string")
#删除末尾的分号;
objArgu_Ser = objArgu_Ser.str.replace(";","")
#Series按换行符号分割
objArgu_Ser = objArgu_Ser.str.split('\n',expand=True)
#得到df
# 0 1
#0 In, AAA,xx Out,BBB,yy
#翻转df
objArgu_df = objArgu_Ser.T
#得到
# 0
#0 In, AAA,xx
#1 Out,BBB,yy
#给得到的df列命名
objArgu_df.columns = ['argInfo']
#得到
# argInfo
#0 In, AAA,xx
#1 Out,BBB,yy
#将argInfo列按逗号分列
objArgu_df = objArgu_df.str.split(",",expand=True)
#得到
# 0 1 2
#0 In AAA xx
#1 Out BBB yy
#给df列命名
objArgu_df.columns=['name','type','value']
#resetIndex
objArguSer = objArguSer.reset_index(drop=True)"string")