Changeset 35105 for main

Timestamp:

2021-04-23T11:06:01+12:00 (3 years ago)

Author:

davidb

Message:

Introduction of addition metadata field that represents 'reverse place'

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/errata-categories/esc-wikipedia-download-and-process-votes.py (modified) (2 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/errata-categories/esc-wikipedia-download-and-process-votes.py

@@ -17 +17 @@
 import escwikipedia
 
+    
+def generate_reverse_finishing_pos_metadata(country_year_recs):
 
+    country_year_recs_len = len(country_year_recs)
+
+    for country_year_key in country_year_recs.keys():
+        country_year_rec = country_year_recs.get(country_year_key)
+
+        place = int(country_year_rec.get("Place"))
+        rev_place = country_year_recs_len - place + 1
+
+        country_year_rec["ReversePlace"] = str(rev_place)
+                
+        country_year_rec["FinishingPos"] = str(place)
+        country_year_rec["ReverseFinishingPos"] = str(rev_place)
+
+        
 def gs_fileset_country_in_year(country_year_name, country_year_rec, nul_output_dir_name):
 
@@ -152 +168 @@
                                                               stop_at_first=True,
                                                               extra_metadata={"Final": True})
-
+        if (year > 1956):
+            # skip inaugural year, as only known who was 1st
+            # everyone else listed as 2nd, and given that there are
+            # two entrants per countries the reversing step generates
+            # (while technically correct) rather weird looking vals
+            generate_reverse_finishing_pos_metadata(country_year_recs)
 
         all_country_year_recs.append(country_year_recs)