我在 Python 中有一個資料框形式的“當前結果”（以 Excel 為例）。
我想添加一個列來分類一行是“PRIME”還是“ALT”名稱。
某物是否為“ALT”的規則如下：
- “組”列不是“NaN”
- 和
- “利用率”始終為 0
嵌套的 IF / AND 陳述句是唯一可行的概念，還是有更有效的方法來做到這一點？PS我對Python比較陌生。
添加資料幀的示例代碼：
import pandas as pd
### Generate data from lists.
data = {'Part':['AAA', 'BBB', 'CCC', 'DDD','EEE','FFF','GGG', 'HHH', 'III', 'JJJ', 'LLL','MMM','NNN'], 'Group':['', '', '', '','','45','45', '45', '', 'FF', 'FF','7J','7J'], 'Utl':['0', '0', '0', '0','0','100','0', '0', '0', '100', '0','100','0']}
### Create DataFrame
df = pd.DataFrame(data)
### Print the output.
print(df)
uj5u.com熱心網友回復：
如果沒有可消化的資料，它很難重新創建，但我相信這會讓你得到你所需要的 IIUC
data = {
'Group' : [np.nan, None, np.nan, '7f', '7f', '7f', None, None, None, '4j', '4j', None, None, '4j'],
'Utilization':[0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 100, 0, 0, 99]
}
df = pd.DataFrame(data)
#This is here just in case you have some np.nan's instead of None it'll make everything the same
df['Group'] = df['Group'].replace({np.nan : None})
condition_list = [
(df['Group'].values == None) | ((df['Utilization']%2 == 0) & (df['Utilization'] > 0)),
(df['Group'].values != None) & (df['Utilization']%2 != 0) & (df['Utilization'] > 0),
(df['Group'].values != None) & (df['Utilization'] == 0)
]
choice_list = ['Prime', 'Alt', 'Alt']
df['Check'] = np.select(condition_list, choice_list, 0)
df
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/482617.html