#remove NaNs
s = df1['parts'].dropna()
#create new DataFrame, assuming only one list always
df2 = pd.DataFrame(s.str[0].values.tolist(), index=s.index)
print (df2)
charge value
0 10.82 engine
1 538.26 seats
2 10.91 seats
#join to original
df = df1[['id']].join(df2)
print (df)
id charge value
0 camry 10.82 engine
1 avelon 538.26 seats
2 prius 10.91 seats
3 corolla NaN NaN
我认为你需要:
相关问题 更多 >
编程相关推荐