python - 如何拆分值列并将其附加到数据框熊猫中？

Question

示例问题

df =
       variant    variant_param    variant_new
  0        car    petro / young            Nan
  1       bike     fred / trail            NaN
  2     bottle              Nan            NaN

那么是否可以使用转换它df.loc[:,'variant':'variant_param'].fillna(method='ffill',axis=1)['variant_param'] 但是从我的代码中我只能得到这样

df =
       variant    variant_param    variant_new
  0        car    petro / young  petro / young
  1       bike     fred / trail    red / trail
  2     bottle              Nan         bottle

但是，我需要我的数据框像这样

df =
       variant    variant_param    variant_new
  0        car    petro / young          petro
  1        car    petro / young          young
  2       bike     fred / trail           fred
  3       bike     fred / trail          trail
  4     bottle              Nan         bottle

标签： pythonpandasdataframesplitfillna

Answer 1

尝试

df['new'] = df['variant_param'].str.split(' / ')
df = df.explode('new')