diff options
Diffstat (limited to 'scraper/s2-geocode-spreadsheet.py')
| -rw-r--r-- | scraper/s2-geocode-spreadsheet.py | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/scraper/s2-geocode-spreadsheet.py b/scraper/s2-geocode-spreadsheet.py index c48685f4..aa8c2578 100644 --- a/scraper/s2-geocode-spreadsheet.py +++ b/scraper/s2-geocode-spreadsheet.py @@ -35,6 +35,8 @@ def s2_geocode_spreadsheet(): print("processing sheet...") seen = {} for i, row in enumerate(rows): + if (i % 1000) == 0: + print("{}...".format(i)) if row[1] in seen: continue seen[row[1]] = True @@ -112,10 +114,14 @@ def update_country_from_address(address, i, countries, worksheet): country = "Taiwan" elif "Russia" in address: country = "Russia" + elif "Ukraine" in address: + country = "Ukraine" elif "Japan" in address: country = "Japan" elif "Iran" in address: country = "Iran" + elif "South Korea" in address: + country = "South Korea" elif "Egypt" in address: country = "Egypt" elif "پاکستان" in address: @@ -123,7 +129,7 @@ def update_country_from_address(address, i, countries, worksheet): elif "السعودية" in address: country = "Saudi Arabia" else: - print("unknown country: {}".format(possible_country)) + print("unknown country: {}".format(address)) return "" worksheet.update_cell(i+2, 7+1, country) |