我有一個(gè)數(shù)據(jù)框，其中有一列包含一個(gè)以逗號(hào)分隔的項(xiàng)目的字符串。col1apple, banana, kiwiapple, bananabanana我想制作第二列“col2”來(lái)顯示每一行之間的差異。所以我試圖將每一行變成一個(gè)集合，并從前一行中減去它，如下所示：Python comparing two strings to differencesdf['col2'] = set(df["col1"].shift(1)) - set(df["col1"])但是我收到此錯(cuò)誤消息：“ValueError：值的長(zhǎng)度與索引的長(zhǎng)度不匹配”。我做錯(cuò)了什么，有沒(méi)有更好的方法來(lái)做我正在做的事情？編輯：預(yù)期輸出col1 col2apple, banana, kiwi apple, banana kiwibanana apple
1 回答
喵喔喔
TA貢獻(xiàn)1735條經(jīng)驗(yàn) 獲得超5個(gè)贊
df["temp"] = df.col1.str.replace("\s+", "").str.split(",")
為列賦值difference：
df['difference'] = [ ""
if isinstance(last, float) or (not set(last).difference(first))
else tuple(set(last).difference(first))
if len(set(last).difference(first)) > 1
else min(set(last).difference(first))
for first, last in zip(df.temp, df["temp"].shift())
]
df.drop('temp', axis=1)
col1 difference
0 apple, banana, kiwi
1 apple, banana kiwi
2 banana apple
添加回答
舉報(bào)
0/150
提交
取消