我正在嘗試根據(jù)用戶的選擇獲取電話號碼#the dict that contains the data I needx={"contact": { "facility_message": "testing testing testing", "facilitydigits":101, "name": "", "urn": "tel:+1234567891011", "uuid": "60409852-a2089-43d5-bd4c-4b89a6191793", "selection_anc_pnc":"C" }}#extracting data from the dictfacility_number=str(x['contact']['facilitydigits'])group=(x['contact']['selection_anc_pnc']).upper()facility_message=(x['contact']['facility_message'])#checking user selection if group =='A': group="MIMBA"elif group =='B': group='MAMA' elif group=='C': group='MAMA' and "MIMBA"我的df看起來像這樣phone group County PNC/ANC Facility Name Optedout Facility Code25470000040 MIMBA Orange PNC Centre FALSE 10125470000030 MAMA Orange PNC Centre FALSE 10125470000010 MIMBA Orange PNC Centre FALSE 10125470000020 MAMA Orange PNC Centre FALSE 10125470000050 MAMA Orange PNC Main Centre FALSE 112從我的df中提取電話號碼phone_numbers =merged_df.loc[(merged_df['Facility Code'] ==facility_number) & (merged_df['group'] == group) & (merged_df['Opted out'] == optout)]['phone']print(phone_numbers)由于 if 語句，當(dāng)前正在發(fā)生什么[25470000010,25470000040]期望的輸出[25470000040,25470000030,25470000010,25470000020]
1 回答
拉丁的傳說
TA貢獻(xiàn)1789條經(jīng)驗 獲得超8個贊
您錯誤地分配了 group 值group = 'MAMA' and "MIMBA"，執(zhí)行后使用該值將 value 分配"MIMBA"給 group ，這是最后一個 truty 值，而不是您想要做的是分配 group 可以使用的值列表 using group = ['MAMA', "MIMBA"]。然后，您可以使用Series.isin方法過濾數(shù)據(jù)框中屬于group變量中存在的組的組。
利用：
if group =='A':
group=["MIMBA"]
elif group =='B':
group=['MAMA']
elif group=='C':
group=['MAMA', "MIMBA"]
m = (
merged_df['Facility Code'].astype(str).eq(facility_number)
& merged_df['group'].isin(group)
& merged_df['Optedout'].eq(optout)
)
phone_numbers = merged_df.loc[m, "phone"]
print(phone_numbers.values)
這打印：
[25470000040 25470000030 25470000010 25470000020] # assuming variable optout is False
添加回答
舉報
0/150
提交
取消