Need Python script to analyze dataset

I WANT TO GROUP THE RECORD IN A DATASET THAT ARE (1) SEQUENTIAL IN NUMBER OR ADJACENT NEIGHBORS AND (2) COMBINED TOTAL POPULATION > 45,000 EACH GROUP WILL HAVE ITS OWN NUMBER (1,2,3,4...) AND A TOTAL POPULATION #. THE BELOW METHOD IS MY THOUGHT PROCESS TO USE AS A GUIDE. BELOW IS AN EXAMPLE OF THE RAW DATASET YOU WILL WORK WITH. AT THE END OF THIS DOCUMENT IS AN EXAMPLE OF THE RESULTS YOU WILL ACHIEVE ON THIS DATASET WITH YOUR PYTHON SCRIPT (VERSION 3). ----------------------------- DATA SAMPLE (I'VE ALSO ATTACHED THE ACTUAL DATASET TO THIS PROJECT) zipcode POPULATION neighbors GROUPNO USEDFLAG GROUP_POP 10001 21097 10010,10011,10016,10018,10119,10199 10002 81335 10003,10009,10012,10013,10038 10003 55190 10002,10009,10010,10011,10012 ----------------------------- STEPS 1. SORT DATA ALPHA NUMERICALLY BY ZIPCODE (A-Z) 2. IS THIS RECORD 1ST RECORD OF TABLE? THEN GROUPNO = 1, ADD POPULATION TO ARRAY 3. WE NEED TO FLAG THIS RECORD AS ALREADY USED, SO USEDFLAG =1 4. FIND NEXT RECORD TO ADD TO POPULATION AND GROUP 5. LOOP THRU NEIGHBORHOODS VALUE (COMMA DELIMINATED) subroutine 6. GOTO 1ST RECORD ID 7. IS USEDFLAG = NULL, THEN WE CAN USE. 8. ADD POPULATION VALUE TO ARRAY 9. ASSIGN USEDFLAG =1 10. ASSIGN SAME GROUP NUMBER AS MASTER RECORD OF THIS SUBROUTINE 11. IF TOTAL POPULATION >45000 THEN END. 12. LOOP THROUGH UNTIL ALL POPULATION VALUES OF NEIGHBORHOOD ARE ADDED; OR ALL NEIGHBORHOODS HAVE 1 AS USEDFLAG 13. WHEN SUBROUTINE IS DONE, TOTAL POPULATIONS AND ADD TO GROUP_POP OF EACH RECORD IN GROUP 14. ASSIGN SAME GROUPNO TO EACH RECORD IN GROUP 15. GOTO NEXT RECORD AND START OVER 16. EXCEPT IF NOT FIRST RECORD, THEN GROUPNO IS PREVIOUS GROUPNO + 1. 17. UNTIL END ------------- GROUPNO = UNIQUE NUMBER TO IDENTIFY GROUPS OF RECORDS USEDFLAG = 1 OR NULL. TO IDENTIFY IF RECORD HAS BEEN USED IN ARRAY. YOU COULD ALSO USE "IF GROUP_NO <> NULL" I GUESS GROUP_POP IS THE TOTAL POPULATION FOR THE RECORDS IN A GIVEN GROUP --------------- RESULTS WILL BE A TABLE WITH THE SAME # OF RECORDS AS STARTED WITH EXAMPLE BELOW zipcode POPULATION GROUP USEDFLAG GROUP_POP 06390 298 1 1 111198 10001 20732 1 1 111198 10002 90168 1 1 111198 10003 55835 2 1 55835 10004 1498 3 1 75254 10005 2126 3 1 75254 10006 2983 3 1 75254 10007 6947 3 1 75254 10009 61700 3 1 75254 10010 28656 4 1 79068 10011 50412 4 1 79068 10012 27359 5 1 56632 10013 29273 5 1 56632 10014 33453 6 1 87164 10016 53711 6 1 87164 10017 16524 7 1 65927 10018 5961 7 1 65927 10019 43442 7 1 65927 10020 0 8 1 105465 10021 105465 8 1 105465 10022 33056 9 1 100187 10023 67131 9 1 100187 10024 61590 10 1 61590 10025 98051 11 1 98051 10026 33811 12 1 96113 10027 62302 12 1 96113 10028 49019 13 1 49019 10029 81251 14 1 81251 10030 27428 15 1 89345 10031 61917 15 1 89345 10032 66749 16 1 66749 10033 60078 17 1 60078 10034 43055 18 1 80692