On 2016-12-01 12:44, Nikhil Verma wrote:
> A = [{'person_id': '1', 'adop_count': '2'}, {'person_id': '3',
> 'adop_count': '4'}]
> *len(A) might be above 10L*
>
> B = [{'person_id': '1', 'village_id': '3'}, {'person_id': '3',
> 'village_id': '4'}]
> *len(B) might be above 20L*
>
>
> OutPut List s
Peter Otten wrote:
> If the data stems from a database you can run (untested)
>
> select B.village_id, sum(A.adop_count) from A inner join B on A.person_id
> = B.person_id;
>
Oops, I forgot the group-by clause:
select B.village_id, sum(A.adop_count)
from A inner join B on A.person_id = B.pers
Nikhil Verma wrote:
> Hey guys
>
> What is the most optimal and pythonic solution forthis situation
>
> A = [{'person_id': '1', 'adop_count': '2'}, {'person_id': '3',
> 'adop_count': '4'}]
> *len(A) might be above 10L*
>
> B = [{'person_id': '1', 'village_id': '3'}, {'person_id': '3',
> 'villag
