def split_by_component(df):
df['prim_comp'] = df.Comp.map(lambda s: s[0])
df['sec_comp'] = df.Comp.map(lambda s: s[-1])
comps = pd.concat((df[['prim_comp', 'Sp1']], df[['sec_comp', 'Sp2']]))
prim = comps.loc[comps.prim_comp.notnull()].rename(columns={'Sp1': 'SpT', 'prim_comp': 'comp'})
sec = comps.loc[comps.sec_comp.notnull()].rename(columns={'Sp2': 'SpT', 'sec_comp': 'comp'})
return pd.concat((prim, sec))[['comp', 'SpT']].drop_duplicates(subset='comp')
评论列表
文章目录