Changeset 34987

Timestamp:

2021-04-03T09:41:18+13:00 (3 years ago)

Author:

davidb

Message:

Adding in reverse ordering to allow group select in SPARQL to pick out things like the bottom entry/entries

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsx-tocountry-jsonmetadata.py (modified) (1 diff)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsx-tocountry-jsonmetadata.py

@@ -478 +478 @@
             to_year_votes[i][0]["FinishingPos"] = finishing_pos
 
-            
+        # Put into reverse order and then number:
+        #   useful for selecting 'bottom <n>' entrants without needing to know
+        #   totoal number of entrants that year
+        to_year_votes.sort(key=lambda v: v[0].get("VoteGrandTotal"), reverse=False)
+        for i in range(to_year_num_votes):
+            rev_finishing_pos = i+1
+            to_year_votes[i][0]["ReverseFinishingPos"] = rev_finishing_pos
+
+        # Put things back to how they were, just to be tidy
+        to_year_votes.sort(key=lambda v: v[0].get("VoteGrandTotal"), reverse=True)
+        
 def gs_yc_directory_metadata(to_year_then_country_voting_groups):
     # Next step is to express the grouped to-country voting data