我正在尝试根据用户的选择获取电话号码
#the dict that contains the data I need
x={"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 dict
facility_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 Code
25470000040 MIMBA Orange PNC Centre FALSE 101
25470000030 MAMA Orange PNC Centre FALSE 101
25470000010 MIMBA Orange PNC Centre FALSE 101
25470000020 MAMA Orange PNC Centre FALSE 101
25470000050 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语句,当前正在发生什么
[25470000010,25470000040]
期望输出
[25470000040,25470000030,25470000010,25470000020]
您使用} 方法过滤数据帧中属于
group = 'MAMA' and "MIMBA"
错误地分配了组值,执行后将值"MIMBA"
分配给最后一个truty值的组,而您要做的是使用group = ['MAMA', "MIMBA"]
分配该组可以接受的值列表。然后,您可以使用^{group
变量中存在的组的组使用:
这张照片是:
相关问题 更多 >
编程相关推荐