我有一個數據框： Item SW_test HW_test QA_test0 PC Pass Pass Pass1 Laptop Fail Fail Pass2 Mouse Pass Pass Fail我想創建一個最后一列，Pass如果所有測試都通過（不區分大小寫）以及Fail一個或多個測試失敗，它將給出。 Item SW_test HW_test QA_test Final0 PC Pass Pass Pass Pass1 Laptop Fail Fail Pass Fail2 Mouse Pass Pass Fail Fail我怎樣才能df['Final']在熊貓中創造？
4 回答
寶慕林4294392
TA貢獻2021條經驗 獲得超8個贊
eq搭配使用all：
df['Final'] = df.iloc[:,1:].eq('Pass').all(1)
#If case sensitive you can use
df['Final'] = df.iloc[:,1:].isin(['Pass','pass']).all(1)
#or
df['Final'] = df.iloc[:,1:].apply(lambda x: x.str.lower().eq('pass')).all(1)
#or
df['Final'] = df.iloc[:,1:].applymap(str.lower).eq('pass').all(1)
此外，您可以使用 map 而不是再次映射 True/False np.where：
df['Final'] = np.where(df['Final'], 'Pass', 'Fail')
慕少森
TA貢獻2019條經驗 獲得超9個贊
cols = ['SW_test', 'HW_test', 'QA_test']
df['Final'] = df[cols].eq('Pass').all(1)
Item SW_test HW_test QA_test Final
0 PC Pass Pass Pass Pass
1 Laptop Fail Fail Pass Fail
2 Mouse Pass Pass Fail Fail
楊__羊羊
TA貢獻1943條經驗 獲得超7個贊
您可以應用 lambda 函數來檢查條件成立的位置，然后可以用您想要的任何值替換 true/false 值。例如：
#create a dataframe
df = pd.DataFrame({'a':['Pass','Pass'], 'b':['Pass','Fail']})
a b
0 Pass Pass
1 Pass Fail
在條件成立的地方創建一個新列
df['c'] = df.apply(lambda row: row.a=='Pass' and row.b=='Pass', axis=1)
a b c
0 Pass Pass True
1 Pass Fail False
將 true/false 值替換為您要顯示的內容
df['c'] = df['c'].map({ True: 'Pass', False: 'Fail'})
a b c
0 Pass Pass Pass
1 Pass Fail Fail
蠱毒傳說
TA貢獻1895條經驗 獲得超3個贊
# set column to "Pass" initially
df["Final"] = "Pass"
# set "Fail" rows
df.loc[(
(df.loc[:, ["SW_test", "HW_test", "QA_test"]] == "Fail") |
(df.loc[:, ["SW_test", "HW_test", "QA_test"]] == "fail")
).any(axis = 1), "Final"] = "Fail"
添加回答
舉報
0/150
提交
取消