Django查询集查找两个查询集之间的百分比

Question

我有两个查询集-

>>> region_carrier_groupby_total =
<QuerySet [{'region_carrier': 'tc2 - rc2', 'DID_Count': 2}, {'region_carrier': 'tc1 - rc1', 'DID_Count': 16}]>


>>> region_carrier_groupby_available =
<QuerySet [{'region_carrier': 'tc2 - rc2', 'DID_Count': 1}, {'region_carrier': 'tc1 - rc1', 'DID_Count': 14}]>

这里的目标是找到按地区分组的DID计数可用百分比。 例如—

区域_载体：tc1-rc1，未计数百分比=（14/16）*100 区域_载体：tc2-rc2，未计数百分比=（1/2）*100

Answer 1

因此，我假设您希望在代码中而不是在sql中执行此操作：

total_counter = {}
for item in region_carrier_groupby_total:
    total_counter[item['region_carrier']] = item['DID_Count']

total_available = {}
for item in region_carrier_groupby_available:
    total_available[item['region_carrier']] = item['DID_Count']

result = {}
for key, total in total_counter.items():
    result[key] = total_available.get(key, 0) / total