回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有分类问题。分类规则是:</p>
<p>如果<code>Storage Condition == 'refrigerate'</code>和<code>100 < profit Per Unit < 150</code>和<code>Inventory Qty <20</code>
然后<code>restock Action = 'Hold Current stock level'</code></p>
<p>否则<code>restock Action = 'On Sale'</code></p>
<p>以下是我需要运行规则的数据集:</p>
<pre><code>ID,Fruit,Stroage Condition,Profit Per Unit,In Season or Not,Inventory Qty,Restock Action
1,Apple ,room temperature ,20,Yes,200,
2,Banana,room temperature ,65,Yes,30,
3,Pear,refrigerate,60,Yes,180,
4,Strawberry,refrigerate,185,No,70,
5,Watermelon ,room temperature ,8,No,90,
6,Mango,Other,20,No,100,
7,DragonFruit,Other,65,No,105,
</code></pre>
<p>我尝试过的代码:</p>
<pre><code>for i in range(len(df['ID'])):
if df['Storage Condition'][i] == 'refrigerate' and df['Profit Per Unit'][i] >100 and df['Profit Per Unit'][i] <150 and df['Inventory Qty'][i] <20:
df['restock action'] = 'Hold Current stock level'
but i got this error message:
The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().
</code></pre>
<p>有人能帮忙吗?谢谢!你知道吗</p>