我有 12 列成分和 12 列相應的成分測量值。對于某些行，指定了成分，但未指定測量值，即它們是 NA。我想設定一個條件，如果某個成分條目不是 NA 并且相應的條目是 NA，則將相應的測量條目設定為 1。
cols1 = ["strIngredient1","strIngredient2","strIngredient3","strIngredient4","strIngredient5","strIngredient6",
"strIngredient7","strIngredient8","strIngredient9","strIngredient10","strIngredient11","strIngredient12"]
cols2 = ["strMeasure1","strMeasure2","strMeasure3","strMeasure4","strMeasure5","strMeasure6","strMeasure7",
"strMeasure8","strMeasure9","strMeasure10","strMeasure11","strMeasure12"]
uj5u.com熱心網友回復：
如果某個成分條目不是NA，而對應的條目是NA，則將對應的條目設定為1
如果我理解正確，您可以使用mask替換條件為 True 的值。
for col1, col2 in zip(cols1, cols2):
df[col2] = df[col2].mask(df[col1].notna()&df[col2].isna(), 1)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/469030.html