Import Selenium drivers first.
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import Select
from selenium.webdriver.support.ui import WebDriverWait
import pandas as pd
import lxml
driver = webdriver.Chrome()/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/pandas/compat/__init__.py:120: UserWarning: Could not import the lzma module. Your installed Python is incomplete. Attempting to use lzma compression will result in a RuntimeError.
warnings.warn(msg)
Get the website link
driver.get("https://www.tomtom.com/en_gb/traffic-index/ranking/")row_list = driver.find_elements_by_class_name('RankingTable__tr')416Scraping the city name, the country name, the number of low traffic days, congestion in 2020, congestion change between 2019 and 2020 and the URL to the individual country page.
traffic_data = []
for row in row_list:
city = row.find_element_by_class_name('RankingTable__city-name').text.strip()
country = row.find_element_by_class_name('RankingTable__city-country').text.strip()
low_traffic = row.find_element_by_class_name('RankingTable__low-days').text.strip()
congestion = row.find_element_by_class_name('RankingTable__congestion-value').text.strip()
congestion_change = row.find_element_by_class_name('Delta__value').text.strip()
url = row.find_element_by_tag_name('a').get_attribute('href').strip()
results = {
'City': city,
'Country': country,
'Low_Traffic_Days_2020': low_traffic,
'Congestion_2020': congestion,
'Congestion_Change19/20': congestion_change_value,
'URL': url
}
traffic_data.append(results)
traffic_data[{'City': 'Moscow region (oblast)',
'Country': 'Russia',
'Low_Traffic_Days_2020': '66 days',
'Congestion_2020': '54%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/moscow-traffic'},
{'City': 'Mumbai',
'Country': 'India',
'Low_Traffic_Days_2020': '133 days',
'Congestion_2020': '53%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/mumbai-traffic'},
{'City': 'Bogota',
'Country': 'Colombia',
'Low_Traffic_Days_2020': '116 days',
'Congestion_2020': '53%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bogota-traffic'},
{'City': 'Manila',
'Country': 'Philippines',
'Low_Traffic_Days_2020': '128 days',
'Congestion_2020': '53%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/manila-traffic'},
{'City': 'Istanbul',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '80 days',
'Congestion_2020': '51%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/istanbul-traffic'},
{'City': 'Bengaluru',
'Country': 'India',
'Low_Traffic_Days_2020': '147 days',
'Congestion_2020': '51%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bengaluru-traffic'},
{'City': 'Kyiv',
'Country': 'Ukraine',
'Low_Traffic_Days_2020': '48 days',
'Congestion_2020': '51%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kiev-traffic'},
{'City': 'New Delhi',
'Country': 'India',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '47%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/new-delhi-traffic'},
{'City': 'Novosibirsk',
'Country': 'Russia',
'Low_Traffic_Days_2020': '15 days',
'Congestion_2020': '45%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/novosibirsk-traffic'},
{'City': 'Bangkok',
'Country': 'Thailand',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '44%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bangkok-traffic'},
{'City': 'Odessa',
'Country': 'Ukraine',
'Low_Traffic_Days_2020': '47 days',
'Congestion_2020': '44%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/odessa-traffic'},
{'City': 'Saint Petersburg',
'Country': 'Russia',
'Low_Traffic_Days_2020': '60 days',
'Congestion_2020': '44%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/saint-petersburg-traffic'},
{'City': 'Kharkiv',
'Country': 'Ukraine',
'Low_Traffic_Days_2020': '19 days',
'Congestion_2020': '43%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kharkiv-traffic'},
{'City': 'Lodz',
'Country': 'Poland',
'Low_Traffic_Days_2020': '13 days',
'Congestion_2020': '42%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lodz-traffic'},
{'City': 'Lima',
'Country': 'Peru',
'Low_Traffic_Days_2020': '144 days',
'Congestion_2020': '42%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lima-traffic'},
{'City': 'Pune',
'Country': 'India',
'Low_Traffic_Days_2020': '154 days',
'Congestion_2020': '42%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/pune-traffic'},
{'City': 'Chongqing',
'Country': 'China',
'Low_Traffic_Days_2020': '42 days',
'Congestion_2020': '42%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/chongqing-traffic'},
{'City': 'Bucharest',
'Country': 'Romania',
'Low_Traffic_Days_2020': '66 days',
'Congestion_2020': '42%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bucharest-traffic'},
{'City': 'Tokyo',
'Country': 'Japan',
'Low_Traffic_Days_2020': '2 days',
'Congestion_2020': '41%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tokyo-traffic'},
{'City': 'Samara',
'Country': 'Russia',
'Low_Traffic_Days_2020': '40 days',
'Congestion_2020': '41%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/samara-traffic'},
{'City': 'Dublin',
'Country': 'Ireland',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '38%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dublin-traffic'},
{'City': 'Dnipro',
'Country': 'Ukraine',
'Low_Traffic_Days_2020': '9 days',
'Congestion_2020': '38%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dnipro-traffic'},
{'City': 'Taipei',
'Country': 'Taiwan',
'Low_Traffic_Days_2020': '2 days',
'Congestion_2020': '37%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/taipei-traffic'},
{'City': 'Recife',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '95 days',
'Congestion_2020': '37%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/recife-traffic'},
{'City': 'Tel Aviv',
'Country': 'Israel',
'Low_Traffic_Days_2020': '68 days',
'Congestion_2020': '37%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tel-aviv-traffic'},
{'City': 'Changchun',
'Country': 'China',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '37%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/changchun-traffic'},
{'City': 'Krakow',
'Country': 'Poland',
'Low_Traffic_Days_2020': '69 days',
'Congestion_2020': '36%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/krakow-traffic'},
{'City': 'Yekaterinburg',
'Country': 'Russia',
'Low_Traffic_Days_2020': '47 days',
'Congestion_2020': '36%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/yekaterinburg-traffic'},
{'City': 'Mexico City',
'Country': 'Mexico',
'Low_Traffic_Days_2020': '139 days',
'Congestion_2020': '36%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/mexico-city-traffic'},
{'City': 'Cairo',
'Country': 'Egypt',
'Low_Traffic_Days_2020': '39 days',
'Congestion_2020': '36%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cairo-traffic'},
{'City': 'Jakarta',
'Country': 'Indonesia',
'Low_Traffic_Days_2020': '141 days',
'Congestion_2020': '36%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/jakarta-traffic'},
{'City': 'Wroclaw',
'Country': 'Poland',
'Low_Traffic_Days_2020': '46 days',
'Congestion_2020': '35%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wroclaw-traffic'},
{'City': 'Osaka',
'Country': 'Japan',
'Low_Traffic_Days_2020': '3 days',
'Congestion_2020': '35%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/osaka-traffic'},
{'City': 'Taichung',
'Country': 'Taiwan',
'Low_Traffic_Days_2020': '1 day',
'Congestion_2020': '35%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/taichung-traffic'},
{'City': 'Taoyuan',
'Country': 'Taiwan',
'Low_Traffic_Days_2020': '1 day',
'Congestion_2020': '34%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/taoyuan-traffic'},
{'City': 'Athens',
'Country': 'Greece',
'Low_Traffic_Days_2020': '102 days',
'Congestion_2020': '34%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/athens-traffic'},
{'City': 'Rostov-on-Don',
'Country': 'Russia',
'Low_Traffic_Days_2020': '51 days',
'Congestion_2020': '34%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rostov-on-don-traffic'},
{'City': 'Nagoya',
'Country': 'Japan',
'Low_Traffic_Days_2020': '2 days',
'Congestion_2020': '33%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nagoya-traffic'},
{'City': 'Kaohsiung',
'Country': 'Taiwan',
'Low_Traffic_Days_2020': '0 days',
'Congestion_2020': '32%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kaohsiung-traffic'},
{'City': 'Rio de Janeiro',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '130 days',
'Congestion_2020': '32%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rio-de-janeiro-traffic'},
{'City': 'Tainan',
'Country': 'Taiwan',
'Low_Traffic_Days_2020': '1 day',
'Congestion_2020': '32%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tainan-traffic'},
{'City': 'Paris',
'Country': 'France',
'Low_Traffic_Days_2020': '94 days',
'Congestion_2020': '32%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/paris-traffic'},
{'City': 'Edinburgh',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '90 days',
'Congestion_2020': '32%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/edinburgh-traffic'},
{'City': 'Santiago',
'Country': 'Chile',
'Low_Traffic_Days_2020': '165 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/santiago-traffic'},
{'City': 'Poznan',
'Country': 'Poland',
'Low_Traffic_Days_2020': '57 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/poznan-traffic'},
{'City': 'Chelyabinsk',
'Country': 'Russia',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/chelyabinsk-traffic'},
{'City': 'Warsaw',
'Country': 'Poland',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/warsaw-traffic'},
{'City': 'Fortaleza',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '76 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/fortaleza-traffic'},
{'City': 'London',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '67 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/london-traffic'},
{'City': 'Omsk',
'Country': 'Russia',
'Low_Traffic_Days_2020': '37 days',
'Congestion_2020': '31%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/omsk-traffic'},
{'City': 'Salvador',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '129 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/salvador-traffic'},
{'City': 'Vancouver',
'Country': 'Canada',
'Low_Traffic_Days_2020': '58 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/vancouver-traffic'},
{'City': 'Sofia',
'Country': 'Bulgaria',
'Low_Traffic_Days_2020': '55 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/sofia-traffic'},
{'City': 'Marseille',
'Country': 'France',
'Low_Traffic_Days_2020': '69 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/marseille-traffic'},
{'City': 'Izmir',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '65 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/izmir-traffic'},
{'City': 'Nizhny Novgorod',
'Country': 'Russia',
'Low_Traffic_Days_2020': '47 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nizhny-novgorod-traffic'},
{'City': 'Hong Kong',
'Country': 'Hong Kong',
'Low_Traffic_Days_2020': '20 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hong-kong-traffic'},
{'City': 'Berlin',
'Country': 'Germany',
'Low_Traffic_Days_2020': '20 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/berlin-traffic'},
{'City': 'Sao Paulo',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '137 days',
'Congestion_2020': '30%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/sao-paulo-traffic'},
{'City': 'Palermo',
'Country': 'Italy',
'Low_Traffic_Days_2020': '81 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/palermo-traffic'},
{'City': 'Hamburg',
'Country': 'Germany',
'Low_Traffic_Days_2020': '32 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hamburg-traffic'},
{'City': 'Geneva',
'Country': 'Switzerland',
'Low_Traffic_Days_2020': '41 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/geneva-traffic'},
{'City': 'Auckland',
'Country': 'New Zealand',
'Low_Traffic_Days_2020': '54 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/auckland-traffic'},
{'City': 'Kazan',
'Country': 'Russia',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kazan-traffic'},
{'City': 'Brussels',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '84 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brussels-traffic'},
{'City': 'Gdansk, Gdynia and Sopot',
'Country': 'Poland',
'Low_Traffic_Days_2020': '42 days',
'Congestion_2020': '29%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/gdansk-gdynia-sopot-traffic'},
{'City': 'Ankara',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '57 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ankara-traffic'},
{'City': 'Sydney',
'Country': 'Australia',
'Low_Traffic_Days_2020': '33 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/sydney-traffic'},
{'City': 'Chengdu',
'Country': 'China',
'Low_Traffic_Days_2020': '40 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/chengdu-traffic'},
{'City': 'Tomsk',
'Country': 'Russia',
'Low_Traffic_Days_2020': '28 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tomsk-traffic'},
{'City': 'Sapporo',
'Country': 'Japan',
'Low_Traffic_Days_2020': '6 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/sapporo-traffic'},
{'City': 'Hull',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '78 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hull-traffic'},
{'City': 'Brighton and Hove',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brighton-and-hove-traffic'},
{'City': 'Belo Horizonte',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '95 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/belo-horizonte-traffic'},
{'City': 'Shenyang',
'Country': 'China',
'Low_Traffic_Days_2020': '18 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/shenyang-traffic'},
{'City': 'Limerick',
'Country': 'Ireland',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/limerick-traffic'},
{'City': 'Kuala Lumpur',
'Country': 'Malaysia',
'Low_Traffic_Days_2020': '126 days',
'Congestion_2020': '28%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kuala-lumpur-traffic'},
{'City': 'Genoa',
'Country': 'Italy',
'Low_Traffic_Days_2020': '71 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/genoa-traffic'},
{'City': 'Rome',
'Country': 'Italy',
'Low_Traffic_Days_2020': '109 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rome-traffic'},
{'City': 'Bydgoszcz',
'Country': 'Poland',
'Low_Traffic_Days_2020': '47 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bydgoszcz-traffic'},
{'City': 'Budapest',
'Country': 'Hungary',
'Low_Traffic_Days_2020': '76 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/budapest-traffic'},
{'City': 'Wellington',
'Country': 'New Zealand',
'Low_Traffic_Days_2020': '53 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wellington-traffic'},
{'City': 'Singapore',
'Country': 'Singapore',
'Low_Traffic_Days_2020': '57 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/singapore-traffic'},
{'City': 'Szczecin',
'Country': 'Poland',
'Low_Traffic_Days_2020': '50 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/szczecin-traffic'},
{'City': 'Los Angeles',
'Country': 'USA',
'Low_Traffic_Days_2020': '156 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/los-angeles-traffic'},
{'City': 'Zhuhai',
'Country': 'China',
'Low_Traffic_Days_2020': '19 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/zhuhai-traffic'},
{'City': 'Zurich',
'Country': 'Switzerland',
'Low_Traffic_Days_2020': '37 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/zurich-traffic'},
{'City': 'Bratislava',
'Country': 'Slovakia',
'Low_Traffic_Days_2020': '85 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bratislava-traffic'},
{'City': 'Adana',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '32 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/adana-traffic'},
{'City': 'Bordeaux',
'Country': 'France',
'Low_Traffic_Days_2020': '101 days',
'Congestion_2020': '27%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bordeaux-traffic'},
{'City': 'Lublin',
'Country': 'Poland',
'Low_Traffic_Days_2020': '19 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lublin-traffic'},
{'City': 'Grenoble',
'Country': 'France',
'Low_Traffic_Days_2020': '105 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/grenoble-traffic'},
{'City': 'Vilnius',
'Country': 'Lithuania',
'Low_Traffic_Days_2020': '60 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/vilnius-traffic'},
{'City': 'Antalya',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '46 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/antalya-traffic'},
{'City': 'Lugano',
'Country': 'Switzerland',
'Low_Traffic_Days_2020': '54 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lugano-traffic'},
{'City': 'Changsha',
'Country': 'China',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/changsha-traffic'},
{'City': 'Toulon',
'Country': 'France',
'Low_Traffic_Days_2020': '89 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/toulon-traffic'},
{'City': 'Tallinn',
'Country': 'Estonia',
'Low_Traffic_Days_2020': '29 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tallinn-traffic'},
{'City': 'Vienna',
'Country': 'Austria',
'Low_Traffic_Days_2020': '35 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/vienna-traffic'},
{'City': 'Cork',
'Country': 'Ireland',
'Low_Traffic_Days_2020': '79 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cork-traffic'},
{'City': 'Wiesbaden',
'Country': 'Germany',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wiesbaden-traffic'},
{'City': 'New York',
'Country': 'USA',
'Low_Traffic_Days_2020': '108 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/new-york-traffic'},
{'City': 'Kobe',
'Country': 'Japan',
'Low_Traffic_Days_2020': '5 days',
'Congestion_2020': '26%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kobe-traffic'},
{'City': 'Belfast',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '83 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/belfast-traffic'},
{'City': 'Bursa',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '56 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bursa-traffic'},
{'City': 'Luxembourg',
'Country': 'Luxembourg',
'Low_Traffic_Days_2020': '95 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/luxembourg-traffic'},
{'City': 'Nuremberg',
'Country': 'Germany',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nuremberg-traffic'},
{'City': 'Messina',
'Country': 'Italy',
'Low_Traffic_Days_2020': '75 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/messina-traffic'},
{'City': 'Nice',
'Country': 'France',
'Low_Traffic_Days_2020': '83 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nice-traffic'},
{'City': 'Haarlem',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '9 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/haarlem-traffic'},
{'City': 'Stuttgart',
'Country': 'Germany',
'Low_Traffic_Days_2020': '38 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/stuttgart-traffic'},
{'City': 'Bournemouth',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '93 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bournemouth-traffic'},
{'City': 'Lyon',
'Country': 'France',
'Low_Traffic_Days_2020': '97 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lyon-traffic'},
{'City': 'Reading',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '80 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/reading-traffic'},
{'City': 'Naples',
'Country': 'Italy',
'Low_Traffic_Days_2020': '103 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/naples-traffic'},
{'City': 'Shijiazhuang',
'Country': 'China',
'Low_Traffic_Days_2020': '23 days',
'Congestion_2020': '25%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/shijiazhuang-traffic'},
{'City': 'Beijing',
'Country': 'China',
'Low_Traffic_Days_2020': '115 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/beijing-traffic'},
{'City': 'Hamilton',
'Country': 'New Zealand',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hamilton-nz-traffic'},
{'City': 'Porto Alegre',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '94 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/porto-alegre-traffic'},
{'City': 'Kassel',
'Country': 'Germany',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kassel-traffic'},
{'City': 'Southampton',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '109 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/southampton-traffic'},
{'City': 'Montpellier',
'Country': 'France',
'Low_Traffic_Days_2020': '84 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/montpellier-traffic'},
{'City': 'Buenos Aires',
'Country': 'Argentina',
'Low_Traffic_Days_2020': '153 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/buenos-aires-traffic'},
{'City': 'Antwerp',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '81 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/antwerp-traffic'},
{'City': 'Guangzhou',
'Country': 'China',
'Low_Traffic_Days_2020': '57 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/guangzhou-traffic'},
{'City': 'Porto',
'Country': 'Portugal',
'Low_Traffic_Days_2020': '111 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/porto-traffic'},
{'City': 'The Hague',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '25 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/the-hague-traffic'},
{'City': 'Gaziantep',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/gaziantep-traffic'},
{'City': 'Munich',
'Country': 'Germany',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '24%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/munich-traffic'},
{'City': 'Liverpool',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '55 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/liverpool-traffic'},
{'City': 'Shenzhen',
'Country': 'China',
'Low_Traffic_Days_2020': '53 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/shenzhen-traffic'},
{'City': 'Cape Town',
'Country': 'South Africa',
'Low_Traffic_Days_2020': '101 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cape-town-traffic'},
{'City': 'Dresden',
'Country': 'Germany',
'Low_Traffic_Days_2020': '33 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dresden-traffic'},
{'City': 'Mersin',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '25 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/mersin-traffic'},
{'City': 'Nanjing',
'Country': 'China',
'Low_Traffic_Days_2020': '40 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nanjing-traffic'},
{'City': 'Catania',
'Country': 'Italy',
'Low_Traffic_Days_2020': '92 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/catania-traffic'},
{'City': 'Prague',
'Country': 'Czechia',
'Low_Traffic_Days_2020': '51 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/prague-traffic'},
{'City': 'Melbourne',
'Country': 'Australia',
'Low_Traffic_Days_2020': '102 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/melbourne-traffic'},
{'City': 'Lisbon',
'Country': 'Portugal',
'Low_Traffic_Days_2020': '144 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lisbon-traffic'},
{'City': 'Bari',
'Country': 'Italy',
'Low_Traffic_Days_2020': '68 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bari-traffic'},
{'City': 'Miami',
'Country': 'USA',
'Low_Traffic_Days_2020': '61 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/miami-traffic'},
{'City': 'Stockholm',
'Country': 'Sweden',
'Low_Traffic_Days_2020': '16 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/stockholm-traffic'},
{'City': 'Milan',
'Country': 'Italy',
'Low_Traffic_Days_2020': '121 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/milan-traffic'},
{'City': 'Graz',
'Country': 'Austria',
'Low_Traffic_Days_2020': '40 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/graz-traffic'},
{'City': 'Bristol',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '132 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bristol-traffic'},
{'City': 'Kiel',
'Country': 'Germany',
'Low_Traffic_Days_2020': '16 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kiel-traffic'},
{'City': 'Kosice',
'Country': 'Slovakia',
'Low_Traffic_Days_2020': '27 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kosice-traffic'},
{'City': 'Salzburg',
'Country': 'Austria',
'Low_Traffic_Days_2020': '41 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/salzburg-traffic'},
{'City': 'Leipzig',
'Country': 'Germany',
'Low_Traffic_Days_2020': '12 days',
'Congestion_2020': '23%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/leipzig-traffic'},
{'City': 'Portsmouth',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '52 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/portsmouth-traffic'},
{'City': 'Xiamen',
'Country': 'China',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/xiamen-traffic'},
{'City': 'Shanghai',
'Country': 'China',
'Low_Traffic_Days_2020': '79 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/shanghai-traffic'},
{'City': 'Leicester',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '128 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/leicester-traffic'},
{'City': 'Bialystok',
'Country': 'Poland',
'Low_Traffic_Days_2020': '34 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bialystok-traffic'},
{'City': 'Thessaloniki',
'Country': 'Greece',
'Low_Traffic_Days_2020': '113 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/thessaloniki-traffic'},
{'City': 'Manchester',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '135 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/manchester-traffic'},
{'City': 'Nottingham',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '82 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nottingham-traffic'},
{'City': 'Brisbane',
'Country': 'Australia',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brisbane-traffic'},
{'City': 'Basel',
'Country': 'Switzerland',
'Low_Traffic_Days_2020': '30 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/basel-traffic'},
{'City': 'Lausanne',
'Country': 'Switzerland',
'Low_Traffic_Days_2020': '53 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lausanne-traffic'},
{'City': 'Riga',
'Country': 'Latvia',
'Low_Traffic_Days_2020': '49 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/riga-traffic'},
{'City': 'Strasbourg',
'Country': 'France',
'Low_Traffic_Days_2020': '92 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/strasbourg-traffic'},
{'City': 'Riyadh',
'Country': 'Saudi Arabia',
'Low_Traffic_Days_2020': '46 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/riyadh-traffic'},
{'City': 'Barcelona',
'Country': 'Spain',
'Low_Traffic_Days_2020': '105 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/barcelona-traffic'},
{'City': 'Nantes',
'Country': 'France',
'Low_Traffic_Days_2020': '114 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nantes-traffic'},
{'City': 'East London',
'Country': 'South Africa',
'Low_Traffic_Days_2020': '42 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/east-london-traffic'},
{'City': 'Brno',
'Country': 'Czechia',
'Low_Traffic_Days_2020': '73 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brno-traffic'},
{'City': 'Toronto',
'Country': 'Canada',
'Low_Traffic_Days_2020': '108 days',
'Congestion_2020': '22%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/toronto-traffic'},
{'City': 'San Francisco',
'Country': 'USA',
'Low_Traffic_Days_2020': '211 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/san-francisco-traffic'},
{'City': 'Reggio Calabria',
'Country': 'Italy',
'Low_Traffic_Days_2020': '96 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/reggio-calabria-traffic'},
{'City': 'Christchurch',
'Country': 'New Zealand',
'Low_Traffic_Days_2020': '39 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/christchurch-traffic'},
{'City': 'Tianjin',
'Country': 'China',
'Low_Traffic_Days_2020': '26 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tianjin-traffic'},
{'City': 'Clermont-Ferrand',
'Country': 'France',
'Low_Traffic_Days_2020': '75 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/clermont-ferrand-traffic'},
{'City': 'Nijmegen',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '26 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nijmegen-traffic'},
{'City': 'Brest',
'Country': 'France',
'Low_Traffic_Days_2020': '72 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brest-traffic'},
{'City': 'Leiden',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '90 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/leiden-traffic'},
{'City': 'Toulouse',
'Country': 'France',
'Low_Traffic_Days_2020': '111 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/toulouse-traffic'},
{'City': 'Cardiff',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '123 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cardiff-traffic'},
{'City': 'Gold Coast',
'Country': 'Australia',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/gold-coast-traffic'},
{'City': 'Bonn',
'Country': 'Germany',
'Low_Traffic_Days_2020': '61 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bonn-traffic'},
{'City': 'Leuven',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '23 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/leuven-traffic'},
{'City': 'Johannesburg',
'Country': 'South Africa',
'Low_Traffic_Days_2020': '130 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/johannesburg-traffic'},
{'City': 'Tauranga',
'Country': 'New Zealand',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tauranga-traffic'},
{'City': 'Adelaide',
'Country': 'Australia',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/adelaide-traffic'},
{'City': 'Cologne',
'Country': 'Germany',
'Low_Traffic_Days_2020': '51 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cologne-traffic'},
{'City': 'Curitiba',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '85 days',
'Congestion_2020': '21%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/curitiba-traffic'},
{'City': 'Hobart',
'Country': 'Australia',
'Low_Traffic_Days_2020': '26 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hobart-traffic'},
{'City': 'Frankfurt am Main',
'Country': 'Germany',
'Low_Traffic_Days_2020': '56 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/frankfurt-am-main-traffic'},
{'City': 'Turin',
'Country': 'Italy',
'Low_Traffic_Days_2020': '98 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/turin-traffic'},
{'City': 'Hangzhou',
'Country': 'China',
'Low_Traffic_Days_2020': '39 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hangzhou-traffic'},
{'City': 'Groningen',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '25 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/groningen-traffic'},
{'City': 'Baton Rouge',
'Country': 'USA',
'Low_Traffic_Days_2020': '63 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/baton-rouge-traffic'},
{'City': 'Granada',
'Country': 'Spain',
'Low_Traffic_Days_2020': '127 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/granada-traffic'},
{'City': 'Freiburg',
'Country': 'Germany',
'Low_Traffic_Days_2020': '44 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/freiburg-traffic'},
{'City': 'Montreal',
'Country': 'Canada',
'Low_Traffic_Days_2020': '103 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/montreal-traffic'},
{'City': 'Rennes',
'Country': 'France',
'Low_Traffic_Days_2020': '103 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rennes-traffic'},
{'City': 'Apeldoorn',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '1 day',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/apeldoorn-traffic'},
{'City': 'Fuzhou',
'Country': 'China',
'Low_Traffic_Days_2020': '3 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/fuzhou-traffic'},
{'City': 'Lille',
'Country': 'France',
'Low_Traffic_Days_2020': '98 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/lille-traffic'},
{'City': 'Oslo',
'Country': 'Norway',
'Low_Traffic_Days_2020': '35 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/oslo-traffic'},
{'City': 'Le Havre',
'Country': 'France',
'Low_Traffic_Days_2020': '66 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/le-havre-traffic'},
{'City': 'Pretoria',
'Country': 'South Africa',
'Low_Traffic_Days_2020': '88 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/pretoria-traffic'},
{'City': 'Swansea',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '107 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/swansea-traffic'},
{'City': 'Glasgow',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '81 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/glasgow-traffic'},
{'City': 'Mons',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '168 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/mons-traffic'},
{'City': 'Ruhr region west',
'Country': 'Germany',
'Low_Traffic_Days_2020': '33 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ruhr-region-west-traffic'},
{'City': 'Aarhus',
'Country': 'Denmark',
'Low_Traffic_Days_2020': '27 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/aarhus-traffic'},
{'City': 'Sheffield',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '124 days',
'Congestion_2020': '20%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/sheffield-traffic'},
{'City': 'Bremen',
'Country': 'Germany',
'Low_Traffic_Days_2020': '93 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bremen-traffic'},
{'City': 'Birmingham-Wolverhampton',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '132 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/birmingham-traffic'},
{'City': 'Leeds-Bradford',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '91 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/leeds-bradford-traffic'},
{'City': 'Newcastle-Sunderland',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/newcastle-sunderland-traffic'},
{'City': 'San Jose',
'Country': 'USA',
'Low_Traffic_Days_2020': '203 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/san-jose-traffic'},
{'City': 'Rotterdam',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '43 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rotterdam-traffic'},
{'City': 'Dunedin',
'Country': 'New Zealand',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dunedin-traffic'},
{'City': 'Augsburg',
'Country': 'Germany',
'Low_Traffic_Days_2020': '30 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/augsburg-traffic'},
{'City': 'Cape Coral-Fort Myers',
'Country': 'USA',
'Low_Traffic_Days_2020': '32 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cape-coral-fort-myers-traffic'},
{'City': 'Arnhem',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '45 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/arnhem-traffic'},
{'City': 'Perth',
'Country': 'Australia',
'Low_Traffic_Days_2020': '12 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/perth-traffic'},
{'City': 'Seattle',
'Country': 'USA',
'Low_Traffic_Days_2020': '180 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/seattle-traffic'},
{'City': 'Newcastle',
'Country': 'Australia',
'Low_Traffic_Days_2020': '8 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/newcastle-au-traffic'},
{'City': 'Honolulu',
'Country': 'USA',
'Low_Traffic_Days_2020': '155 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/honolulu-traffic'},
{'City': 'Stoke-on-Trent',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '100 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/stoke-on-trent-traffic'},
{'City': 'Munster',
'Country': 'Germany',
'Low_Traffic_Days_2020': '22 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/munster-traffic'},
{'City': 'Ottawa',
'Country': 'Canada',
'Low_Traffic_Days_2020': '134 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ottawa-traffic'},
{'City': 'Cagliari',
'Country': 'Italy',
'Low_Traffic_Days_2020': '80 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cagliari-traffic'},
{'City': 'Hannover',
'Country': 'Germany',
'Low_Traffic_Days_2020': '24 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hannover-traffic'},
{'City': 'Breda',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '7 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/breda-traffic'},
{'City': 'Dusseldorf',
'Country': 'Germany',
'Low_Traffic_Days_2020': '47 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dusseldorf-traffic'},
{'City': 'Dubai',
'Country': 'UAE',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dubai-traffic'},
{'City': 'Karlsruhe',
'Country': 'Germany',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/karlsruhe-traffic'},
{'City': 'Uppsala',
'Country': 'Sweden',
'Low_Traffic_Days_2020': '7 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/uppsala-traffic'},
{'City': 'Tilburg',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '2 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tilburg-traffic'},
{'City': 'Riverside',
'Country': 'USA',
'Low_Traffic_Days_2020': '70 days',
'Congestion_2020': '19%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/riverside-traffic'},
{'City': 'Wuxi',
'Country': 'China',
'Low_Traffic_Days_2020': '81 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wuxi-traffic'},
{'City': 'Rouen',
'Country': 'France',
'Low_Traffic_Days_2020': '85 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rouen-traffic'},
{'City': 'Bakersfield',
'Country': 'USA',
'Low_Traffic_Days_2020': '5 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bakersfield-traffic'},
{'City': 'Amsterdam',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '68 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/amsterdam-traffic'},
{'City': 'Tampa',
'Country': 'USA',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tampa-traffic'},
{'City': 'Middlesbrough',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '48 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/middlesbrough-traffic'},
{'City': 'Eindhoven',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '18 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/eindhoven-traffic'},
{'City': 'Mannheim',
'Country': 'Germany',
'Low_Traffic_Days_2020': '38 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/mannheim-traffic'},
{'City': 'Santa Cruz de Tenerife',
'Country': 'Spain',
'Low_Traffic_Days_2020': '102 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/santa-cruz-de-tenerife-traffic'},
{'City': 'Trieste',
'Country': 'Italy',
'Low_Traffic_Days_2020': '49 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/trieste-traffic'},
{'City': 'Austin',
'Country': 'USA',
'Low_Traffic_Days_2020': '153 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/austin-traffic'},
{'City': 'Orleans',
'Country': 'France',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/orleans-traffic'},
{'City': 'Ruhr region east',
'Country': 'Germany',
'Low_Traffic_Days_2020': '30 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ruhr-region-east-traffic'},
{'City': 'London',
'Country': 'Canada',
'Low_Traffic_Days_2020': '64 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/london-ontario-traffic'},
{'City': 'Copenhagen',
'Country': 'Denmark',
'Low_Traffic_Days_2020': '38 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/copenhagen-traffic'},
{'City': 'Ghent',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ghent-traffic'},
{'City': 'Fresno',
'Country': 'USA',
'Low_Traffic_Days_2020': '13 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/fresno-traffic'},
{'City': 'Monchengladbach',
'Country': 'Germany',
'Low_Traffic_Days_2020': '28 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/monchengladbach-traffic'},
{'City': 'Prato',
'Country': 'Italy',
'Low_Traffic_Days_2020': '132 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/prato-traffic'},
{'City': 'Bologna',
'Country': 'Italy',
'Low_Traffic_Days_2020': '122 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bologna-traffic'},
{'City': 'Jeddah',
'Country': 'Saudi Arabia',
'Low_Traffic_Days_2020': '53 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/jeddah-traffic'},
{'City': 'Bern',
'Country': 'Switzerland',
'Low_Traffic_Days_2020': '30 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bern-traffic'},
{'City': 'Nancy',
'Country': 'France',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nancy-traffic'},
{'City': 'Sacramento',
'Country': 'USA',
'Low_Traffic_Days_2020': '70 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/sacramento-traffic'},
{'City': 'Boise',
'Country': 'USA',
'Low_Traffic_Days_2020': '41 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/boise-traffic'},
{'City': 'Bielsko-Biala',
'Country': 'Poland',
'Low_Traffic_Days_2020': '59 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bielsko-biala-traffic'},
{'City': 'Turku',
'Country': 'Finland',
'Low_Traffic_Days_2020': '7 days',
'Congestion_2020': '18%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/turku-traffic'},
{'City': 'Quanzhou',
'Country': 'China',
'Low_Traffic_Days_2020': '46 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/quanzhou-traffic'},
{'City': 'Ljubljana',
'Country': 'Slovenia',
'Low_Traffic_Days_2020': '104 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ljubljana-traffic'},
{'City': 'Coventry',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '165 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/coventry-traffic'},
{'City': 'Pescara',
'Country': 'Italy',
'Low_Traffic_Days_2020': '108 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/pescara-traffic'},
{'City': 'Atlanta',
'Country': 'USA',
'Low_Traffic_Days_2020': '149 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/atlanta-traffic'},
{'City': 'Kuwait City',
'Country': 'Kuwait',
'Low_Traffic_Days_2020': '117 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kuwait-city-traffic'},
{'City': 'New Orleans',
'Country': 'USA',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/new-orleans-traffic'},
{'City': 'Linz',
'Country': 'Austria',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/linz-traffic'},
{'City': 'Florence',
'Country': 'Italy',
'Low_Traffic_Days_2020': '148 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/florence-traffic'},
{'City': 'Valencia',
'Country': 'Spain',
'Low_Traffic_Days_2020': '82 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/valencia-traffic'},
{'City': 'Livorno',
'Country': 'Italy',
'Low_Traffic_Days_2020': '86 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/livorno-traffic'},
{'City': 'Washington',
'Country': 'USA',
'Low_Traffic_Days_2020': '187 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/washington-traffic'},
{'City': 'Saint-Etienne',
'Country': 'France',
'Low_Traffic_Days_2020': '88 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/saint-etienne-traffic'},
{'City': 'Chicago',
'Country': 'USA',
'Low_Traffic_Days_2020': '137 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/chicago-traffic'},
{'City': 'Orlando',
'Country': 'USA',
'Low_Traffic_Days_2020': '48 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/orlando-traffic'},
{'City': 'Charleston',
'Country': 'USA',
'Low_Traffic_Days_2020': '63 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/charleston-traffic'},
{'City': 'Innsbruck',
'Country': 'Austria',
'Low_Traffic_Days_2020': '67 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/innsbruck-traffic'},
{'City': 'Konya',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/konya-traffic'},
{'City': 'Avignon',
'Country': 'France',
'Low_Traffic_Days_2020': '75 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/avignon-traffic'},
{'City': 'Philadelphia',
'Country': 'USA',
'Low_Traffic_Days_2020': '97 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/philadelphia-traffic'},
{'City': 'Halifax',
'Country': 'Canada',
'Low_Traffic_Days_2020': '98 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/halifax-traffic'},
{'City': 'San Diego',
'Country': 'USA',
'Low_Traffic_Days_2020': '172 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/san-diego-traffic'},
{'City': 'Winnipeg',
'Country': 'Canada',
'Low_Traffic_Days_2020': '73 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/winnipeg-traffic'},
{'City': 'Bielefeld',
'Country': 'Germany',
'Low_Traffic_Days_2020': '20 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bielefeld-traffic'},
{'City': 'Ningbo',
'Country': 'China',
'Low_Traffic_Days_2020': '66 days',
'Congestion_2020': '17%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ningbo-traffic'},
{'City': 'Portland',
'Country': 'USA',
'Low_Traffic_Days_2020': '136 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/portland-traffic'},
{'City': 'Zwolle',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '10 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/zwolle-traffic'},
{'City': 'Verona',
'Country': 'Italy',
'Low_Traffic_Days_2020': '88 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/verona-traffic'},
{'City': 'Las Vegas',
'Country': 'USA',
'Low_Traffic_Days_2020': '38 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/las-vegas-traffic'},
{'City': 'Suzhou',
'Country': 'China',
'Low_Traffic_Days_2020': '65 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/suzhou-traffic'},
{'City': 'Reykjavik',
'Country': 'Iceland',
'Low_Traffic_Days_2020': '26 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/reykjavik-traffic'},
{'City': 'Amersfoort',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '22 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/amersfoort-traffic'},
{'City': 'Palma de Mallorca',
'Country': 'Spain',
'Low_Traffic_Days_2020': '129 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/palma-de-mallorca-traffic'},
{'City': 'Houston',
'Country': 'USA',
'Low_Traffic_Days_2020': '118 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/houston-traffic'},
{'City': 'Tucson',
'Country': 'USA',
'Low_Traffic_Days_2020': '34 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tucson-traffic'},
{'City': 'Wuppertal',
'Country': 'Germany',
'Low_Traffic_Days_2020': '27 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wuppertal-traffic'},
{'City': 'Preston',
'Country': 'United Kingdom',
'Low_Traffic_Days_2020': '106 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/preston-traffic'},
{'City': 'Santander',
'Country': 'Spain',
'Low_Traffic_Days_2020': '60 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/santander-traffic'},
{'City': 'Murcia',
'Country': 'Spain',
'Low_Traffic_Days_2020': '96 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/murcia-traffic'},
{'City': 'Taranto',
'Country': 'Italy',
'Low_Traffic_Days_2020': '74 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/taranto-traffic'},
{'City': 'Liege',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '113 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/liege-traffic'},
{'City': 'Kayseri',
'Country': 'Turkey',
'Low_Traffic_Days_2020': '34 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kayseri-traffic'},
{'City': 'Brasilia',
'Country': 'Brazil',
'Low_Traffic_Days_2020': '78 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brasilia-traffic'},
{'City': 'Namur',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '58 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/namur-traffic'},
{'City': 'Durban',
'Country': 'South Africa',
'Low_Traffic_Days_2020': '71 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/durban-traffic'},
{'City': 'McAllen',
'Country': 'USA',
'Low_Traffic_Days_2020': '43 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/mcallen-traffic'},
{'City': 'Wuhan',
'Country': 'China',
'Low_Traffic_Days_2020': '127 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wuhan-traffic'},
{'City': 'Dijon',
'Country': 'France',
'Low_Traffic_Days_2020': '69 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dijon-traffic'},
{'City': 'Katowice urban area',
'Country': 'Poland',
'Low_Traffic_Days_2020': '40 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/katowice-urban-area-traffic'},
{'City': 'Le Mans',
'Country': 'France',
'Low_Traffic_Days_2020': '77 days',
'Congestion_2020': '16%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/le-mans-traffic'},
{'City': 'A Coruna',
'Country': 'Spain',
'Low_Traffic_Days_2020': '87 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/a-coruna-traffic'},
{'City': 'Kortrijk',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '20 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kortrijk-traffic'},
{'City': 'Las Palmas',
'Country': 'Spain',
'Low_Traffic_Days_2020': '108 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/las-palmas-traffic'},
{'City': 'Utrecht',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '86 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/utrecht-traffic'},
{'City': 'Madrid',
'Country': 'Spain',
'Low_Traffic_Days_2020': '137 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/madrid-traffic'},
{'City': 'Odense',
'Country': 'Denmark',
'Low_Traffic_Days_2020': '19 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/odense-traffic'},
{'City': 'Seville',
'Country': 'Spain',
'Low_Traffic_Days_2020': '125 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/seville-traffic'},
{'City': 'Canberra',
'Country': 'Australia',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/canberra-traffic'},
{'City': 'Braga',
'Country': 'Portugal',
'Low_Traffic_Days_2020': '93 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/braga-traffic'},
{'City': 'Nashville',
'Country': 'USA',
'Low_Traffic_Days_2020': '213 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/nashville-traffic'},
{'City': 'Tours',
'Country': 'France',
'Low_Traffic_Days_2020': '69 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tours-traffic'},
{'City': 'Helsinki',
'Country': 'Finland',
'Low_Traffic_Days_2020': '17 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/helsinki-traffic'},
{'City': 'Malaga',
'Country': 'Spain',
'Low_Traffic_Days_2020': '107 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/malaga-traffic'},
{'City': 'Boston',
'Country': 'USA',
'Low_Traffic_Days_2020': '189 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/boston-traffic'},
{'City': 'Denver',
'Country': 'USA',
'Low_Traffic_Days_2020': '126 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/denver-traffic'},
{'City': 'Reims',
'Country': 'France',
'Low_Traffic_Days_2020': '74 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/reims-traffic'},
{'City': 'Pamplona',
'Country': 'Spain',
'Low_Traffic_Days_2020': '63 days',
'Congestion_2020': '15%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/pamplona-traffic'},
{'City': 'Gothenburg',
'Country': 'Sweden',
'Low_Traffic_Days_2020': '39 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/gothenburg-traffic'},
{'City': 'Quebec',
'Country': 'Canada',
'Low_Traffic_Days_2020': '116 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/quebec-traffic'},
{'City': 'Ravenna',
'Country': 'Italy',
'Low_Traffic_Days_2020': '85 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ravenna-traffic'},
{'City': 'Providence',
'Country': 'USA',
'Low_Traffic_Days_2020': '69 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/providence-traffic'},
{'City': 'Oxnard-Thousand Oaks-Ventura',
'Country': 'USA',
'Low_Traffic_Days_2020': '36 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/oxnard-thousand-oaks-ventura-traffic'},
{'City': 'Parma',
'Country': 'Italy',
'Low_Traffic_Days_2020': '108 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/parma-traffic'},
{'City': 'Vitoria-Gasteiz',
'Country': 'Spain',
'Low_Traffic_Days_2020': '45 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/vitoria-gasteiz-traffic'},
{'City': 'Reggio Emilia',
'Country': 'Italy',
'Low_Traffic_Days_2020': '98 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/reggio-emilia-traffic'},
{'City': 'Alicante',
'Country': 'Spain',
'Low_Traffic_Days_2020': '93 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/alicante-traffic'},
{'City': 'Greenville',
'Country': 'USA',
'Low_Traffic_Days_2020': '43 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/greenville-traffic'},
{'City': 'Malmo',
'Country': 'Sweden',
'Low_Traffic_Days_2020': '4 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/malmo-traffic'},
{'City': 'Pittsburgh',
'Country': 'USA',
'Low_Traffic_Days_2020': '97 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/pittsburgh-traffic'},
{'City': 'Wollongong',
'Country': 'Australia',
'Low_Traffic_Days_2020': '4 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/wollongong-traffic'},
{'City': 'Colorado Springs',
'Country': 'USA',
'Low_Traffic_Days_2020': '27 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/colorado-springs-traffic'},
{'City': 'Albuquerque',
'Country': 'USA',
'Low_Traffic_Days_2020': '55 days',
'Congestion_2020': '14%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/albuquerque-traffic'},
{'City': 'Edmonton',
'Country': 'Canada',
'Low_Traffic_Days_2020': '54 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/edmonton-traffic'},
{'City': 'Tampere',
'Country': 'Finland',
'Low_Traffic_Days_2020': '14 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tampere-traffic'},
{'City': 'Dallas-Fort Worth',
'Country': 'USA',
'Low_Traffic_Days_2020': '95 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dallas-fort-worth-traffic'},
{'City': 'Ostrava',
'Country': 'Czechia',
'Low_Traffic_Days_2020': '65 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/ostrava-traffic'},
{'City': 'Jacksonville',
'Country': 'USA',
'Low_Traffic_Days_2020': '53 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/jacksonville-traffic'},
{'City': 'Salt Lake City',
'Country': 'USA',
'Low_Traffic_Days_2020': '43 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/salt-lake-city-traffic'},
{'City': 'Den Bosch',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '45 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/den-bosch-traffic'},
{'City': 'Phoenix',
'Country': 'USA',
'Low_Traffic_Days_2020': '71 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/phoenix-traffic'},
{'City': 'Zaragoza',
'Country': 'Spain',
'Low_Traffic_Days_2020': '55 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/zaragoza-traffic'},
{'City': 'Bergen',
'Country': 'Norway',
'Low_Traffic_Days_2020': '43 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bergen-traffic'},
{'City': 'Charlotte',
'Country': 'USA',
'Low_Traffic_Days_2020': '135 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/charlotte-traffic'},
{'City': 'Vigo',
'Country': 'Spain',
'Low_Traffic_Days_2020': '83 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/vigo-traffic'},
{'City': 'Calgary',
'Country': 'Canada',
'Low_Traffic_Days_2020': '85 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/calgary-traffic'},
{'City': 'Virginia Beach',
'Country': 'USA',
'Low_Traffic_Days_2020': '58 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/virginia-beach-traffic'},
{'City': 'San Antonio',
'Country': 'USA',
'Low_Traffic_Days_2020': '96 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/san-antonio-traffic'},
{'City': 'Dongguan',
'Country': 'China',
'Low_Traffic_Days_2020': '89 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dongguan-traffic'},
{'City': 'Gijon',
'Country': 'Spain',
'Low_Traffic_Days_2020': '83 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/gijon-traffic'},
{'City': 'Valladolid',
'Country': 'Spain',
'Low_Traffic_Days_2020': '67 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/valladolid-traffic'},
{'City': 'Padua',
'Country': 'Italy',
'Low_Traffic_Days_2020': '109 days',
'Congestion_2020': '13%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/padua-traffic'},
{'City': 'Bruges',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '76 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bruges-traffic'},
{'City': 'Coimbra',
'Country': 'Portugal',
'Low_Traffic_Days_2020': '80 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/coimbra-traffic'},
{'City': 'Trondheim',
'Country': 'Norway',
'Low_Traffic_Days_2020': '47 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/trondheim-traffic'},
{'City': 'El Paso',
'Country': 'USA',
'Low_Traffic_Days_2020': '37 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/el-paso-traffic'},
{'City': 'Cartagena',
'Country': 'Spain',
'Low_Traffic_Days_2020': '67 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cartagena-traffic'},
{'City': 'New Haven',
'Country': 'USA',
'Low_Traffic_Days_2020': '60 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/new-haven-traffic'},
{'City': 'Kitchener-Waterloo',
'Country': 'Canada',
'Low_Traffic_Days_2020': '66 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kitchener-waterloo-traffic'},
{'City': 'Cordoba',
'Country': 'Spain',
'Low_Traffic_Days_2020': '99 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cordoba-traffic'},
{'City': 'Modena',
'Country': 'Italy',
'Low_Traffic_Days_2020': '114 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/modena-traffic'},
{'City': 'Baltimore',
'Country': 'USA',
'Low_Traffic_Days_2020': '182 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/baltimore-traffic'},
{'City': 'Raleigh',
'Country': 'USA',
'Low_Traffic_Days_2020': '121 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/raleigh-traffic'},
{'City': 'Charleroi',
'Country': 'Belgium',
'Low_Traffic_Days_2020': '67 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/charleroi-traffic'},
{'City': 'Funchal',
'Country': 'Portugal',
'Low_Traffic_Days_2020': '166 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/funchal-traffic'},
{'City': 'Bilbao',
'Country': 'Spain',
'Low_Traffic_Days_2020': '80 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bilbao-traffic'},
{'City': 'Oklahoma City',
'Country': 'USA',
'Low_Traffic_Days_2020': '41 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/oklahoma-city-traffic'},
{'City': 'Birmingham',
'Country': 'USA',
'Low_Traffic_Days_2020': '84 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/birmingham-alabama-traffic'},
{'City': 'Stavanger',
'Country': 'Norway',
'Low_Traffic_Days_2020': '70 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/stavanger-traffic'},
{'City': 'Hamilton',
'Country': 'Canada',
'Low_Traffic_Days_2020': '133 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hamilton-traffic'},
{'City': 'Cincinnati',
'Country': 'USA',
'Low_Traffic_Days_2020': '83 days',
'Congestion_2020': '12%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cincinnati-traffic'},
{'City': 'Brescia',
'Country': 'Italy',
'Low_Traffic_Days_2020': '113 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/brescia-traffic'},
{'City': 'Louisville',
'Country': 'USA',
'Low_Traffic_Days_2020': '68 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/louisville-traffic'},
{'City': 'Memphis',
'Country': 'USA',
'Low_Traffic_Days_2020': '32 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/memphis-traffic'},
{'City': 'San Sebastian',
'Country': 'Spain',
'Low_Traffic_Days_2020': '86 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/san-sebastian-traffic'},
{'City': 'Allentown',
'Country': 'USA',
'Low_Traffic_Days_2020': '91 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/allentown-traffic'},
{'City': 'Oviedo',
'Country': 'Spain',
'Low_Traffic_Days_2020': '104 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/oviedo-traffic'},
{'City': 'Bloemfontein',
'Country': 'South Africa',
'Low_Traffic_Days_2020': '42 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/bloemfontein-traffic'},
{'City': 'Columbus',
'Country': 'USA',
'Low_Traffic_Days_2020': '119 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/columbus-traffic'},
{'City': 'Tulsa',
'Country': 'USA',
'Low_Traffic_Days_2020': '39 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/tulsa-traffic'},
{'City': 'Detroit',
'Country': 'USA',
'Low_Traffic_Days_2020': '102 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/detroit-traffic'},
{'City': 'Hartford',
'Country': 'USA',
'Low_Traffic_Days_2020': '148 days',
'Congestion_2020': '11%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/hartford-traffic'},
{'City': 'Buffalo',
'Country': 'USA',
'Low_Traffic_Days_2020': '82 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/buffalo-traffic'},
{'City': 'Columbia',
'Country': 'USA',
'Low_Traffic_Days_2020': '65 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/columbia-traffic'},
{'City': 'Albany',
'Country': 'USA',
'Low_Traffic_Days_2020': '116 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/albany-traffic'},
{'City': 'Omaha-Council Bluffs',
'Country': 'USA',
'Low_Traffic_Days_2020': '80 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/omaha-council-bluffs-traffic'},
{'City': 'Knoxville',
'Country': 'USA',
'Low_Traffic_Days_2020': '72 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/knoxville-traffic'},
{'City': 'Grand Rapids',
'Country': 'USA',
'Low_Traffic_Days_2020': '117 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/grand-rapids-traffic'},
{'City': 'Abu Dhabi',
'Country': 'UAE',
'Low_Traffic_Days_2020': '56 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/abu-dhabi-traffic'},
{'City': 'Almere',
'Country': 'Netherlands',
'Low_Traffic_Days_2020': '6 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/almere-traffic'},
{'City': 'Rochester',
'Country': 'USA',
'Low_Traffic_Days_2020': '89 days',
'Congestion_2020': '10%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/rochester-traffic'},
{'City': 'Worcester',
'Country': 'USA',
'Low_Traffic_Days_2020': '139 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/worcester-traffic'},
{'City': 'St. Louis',
'Country': 'USA',
'Low_Traffic_Days_2020': '122 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/st-louis-traffic'},
{'City': 'Cleveland',
'Country': 'USA',
'Low_Traffic_Days_2020': '51 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cleveland-traffic'},
{'City': 'Richmond',
'Country': 'USA',
'Low_Traffic_Days_2020': '58 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/richmond-traffic'},
{'City': 'Milwaukee',
'Country': 'USA',
'Low_Traffic_Days_2020': '82 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/milwaukee-traffic'},
{'City': 'Indianapolis',
'Country': 'USA',
'Low_Traffic_Days_2020': '160 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/indianapolis-traffic'},
{'City': 'Minneapolis',
'Country': 'USA',
'Low_Traffic_Days_2020': '219 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/minneapolis-traffic'},
{'City': 'Kansas City',
'Country': 'USA',
'Low_Traffic_Days_2020': '65 days',
'Congestion_2020': '9%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/kansas-city-traffic'},
{'City': 'Syracuse',
'Country': 'USA',
'Low_Traffic_Days_2020': '61 days',
'Congestion_2020': '8%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/syracuse-traffic'},
{'City': 'Dayton',
'Country': 'USA',
'Low_Traffic_Days_2020': '43 days',
'Congestion_2020': '8%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/dayton-traffic'},
{'City': 'Little Rock',
'Country': 'USA',
'Low_Traffic_Days_2020': '58 days',
'Congestion_2020': '8%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/little-rock-traffic'},
{'City': 'Winston-Salem',
'Country': 'USA',
'Low_Traffic_Days_2020': '72 days',
'Congestion_2020': '8%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/winston-salem-traffic'},
{'City': 'Cadiz',
'Country': 'Spain',
'Low_Traffic_Days_2020': '99 days',
'Congestion_2020': '8%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/cadiz-traffic'},
{'City': 'Akron',
'Country': 'USA',
'Low_Traffic_Days_2020': '46 days',
'Congestion_2020': '8%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/akron-traffic'},
{'City': 'Greensboro-High Point',
'Country': 'USA',
'Low_Traffic_Days_2020': '31 days',
'Congestion_2020': '7%',
'Congestion_Change19/20': '12%p',
'URL': 'https://www.tomtom.com/en_gb/traffic-index/greensboro-high-point-traffic'}]Pulling the scaped data to a DataFrame.
df = pd.DataFrame(traffic_data)Exporting the data to a CSV and then importing that CSV to pandas to clean the data.
df.to_csv("cities_traffic", index=False)df1 = pd.read_csv("/Users/khanfazil/Desktop/cities_traffic")
df1.head()| City | Country | Low_Traffic_Days_2020 | Congestion_2020 | Congestion_Change19/20 | URL | |
|---|---|---|---|---|---|---|
| 0 | Moscow region (oblast) | Russia | 66 days | 54% | 12%p | https://www.tomtom.com/en_gb/traffic-index/mos... |
| 1 | Mumbai | India | 133 days | 53% | 12%p | https://www.tomtom.com/en_gb/traffic-index/mum... |
| 2 | Bogota | Colombia | 116 days | 53% | 12%p | https://www.tomtom.com/en_gb/traffic-index/bog... |
| 3 | Manila | Philippines | 128 days | 53% | 12%p | https://www.tomtom.com/en_gb/traffic-index/man... |
| 4 | Istanbul | Turkey | 80 days | 51% | 12%p | https://www.tomtom.com/en_gb/traffic-index/ist... |
Trying to scrape wasted hours in traffic for one city by visitng the URL for the city page on the website.
#single page trial
driver.get("https://www.tomtom.com/en_gb/traffic-index/moscow-traffic")time_wasted = {}
time_wasted['city'] = driver.find_element_by_class_name('CityPage__h1').text.strip()
time_wasted['wasted_2020'] = driver.find_element_by_class_name('TimeWastedInPeaks__hours').text.strip()
time_wasted['wasted_2019'] = driver.find_element_by_class_name('TimeWastedInPeaks__diff-label').text.strip()
time_wasted{'city': 'Moscow region (oblast) traffic',
'wasted_2020': '200 hours',
'wasted_2019': '1 day, 1 hour less than last year'}Failed attempts at visiting pages of all the cities by switching between cities.
# years = driver.find_elements_by_class_name('Tabs__tab-label')# driver.find_element_by_class_name('CookieBar__button--red').click()
# for year in years[4:]:
# driver.execute_script("year.scrollIntoView();")
# year.click()
# lost_time = year.find_element_by_class_name('TimeWastedInPeaks__hours').text.strip()
# print(lost_time)Writing a function to apply the method used in scraping wasted hours for moscow to every city in the dataframe. Imported "time" to put a time.sleep to avoid getting pinging the website too many times in a short span of time.
import timedef scrape_time_lost(row):
time.sleep(3)
url = row['URL']
driver.get(url)
time_wasted = {}
time_wasted['city'] = driver.find_element_by_class_name('CityPage__h1').text.strip()
time_wasted['wasted_2020'] = driver.find_element_by_class_name('TimeWastedInPeaks__hours').text.strip()
time_wasted['wasted_2019'] = driver.find_element_by_class_name('TimeWastedInPeaks__diff-label').text.strip()
return pd.Series(time_wasted)Bringing the scraped data to a dataframe.
df2 = df1.apply(scrape_time_lost, axis=1)
df2.head()| city | wasted_2020 | wasted_2019 | |
|---|---|---|---|
| 0 | Moscow region (oblast) traffic | 200 hours | 1 day, 1 hour less than last year |
| 1 | Mumbai traffic | 172 hours | 1 day, 13 hours less than last year |
| 2 | Bogota traffic | 165 hours | 2 days, 17 hours less than last year |
| 3 | Manila traffic | 188 hours | 2 days, 21 hours less than last year |
| 4 | Istanbul traffic | 200 hours | 1 day, 1 hour less than last year |
Exported the dataframe to a csv to save the raw version before cleaning in pandas.
df2.to_csv("cities_hours_wasted.csv", index=False)df2.city = df2.city.str.extract("(.*)\straffic")df2.wasted_2020 = df2.wasted_2020.str.extract("(.*)\shours")with_days = df2[df2.wasted_2019.str.contains("day")]with_days['no_of_days'] = with_days.wasted_2019.str.extract("(^\d+)\s.*")/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days['no_of_days'] = with_days['no_of_days'].astype(int)/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days['day_hours'] = with_days['no_of_days'] * 24/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days.head(100)| city | wasted_2020 | wasted_2019 | no_of_days | day_hours | |
|---|---|---|---|---|---|
| 0 | Moscow region (oblast) | 200 | 1 day, 1 hour less than last year | 1 | 24 |
| 1 | Mumbai | 172 | 1 day, 13 hours less than last year | 1 | 24 |
| 2 | Bogota | 165 | 2 days, 17 hours less than last year | 2 | 48 |
| 3 | Manila | 188 | 2 days, 21 hours less than last year | 2 | 48 |
| 4 | Istanbul | 200 | 1 day, 1 hour less than last year | 1 | 24 |
with_days['just_hours'] = with_days.wasted_2019.str.extract("(\d+\shour)")/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days['add_hours'] = with_days.just_hours.str.extract("(\d*)\shour")/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days['add_hours'] = with_days['add_hours'].fillna(0)/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days['add_hours'] = with_days['add_hours'].astype(int)/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days['total_hours'] = with_days['day_hours'] + with_days['add_hours']/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days| city | wasted_2020 | wasted_2019 | no_of_days | day_hours | just_hours | add_hours | total_hours | |
|---|---|---|---|---|---|---|---|---|
| 0 | Moscow region (oblast) | 200 | 1 day, 1 hour less than last year | 1 | 24 | 1 hour | 1 | 25 |
| 1 | Mumbai | 172 | 1 day, 13 hours less than last year | 1 | 24 | 13 hour | 13 | 37 |
| 2 | Bogota | 165 | 2 days, 17 hours less than last year | 2 | 48 | 17 hour | 17 | 65 |
| 3 | Manila | 188 | 2 days, 21 hours less than last year | 2 | 48 | 21 hour | 21 | 69 |
| 4 | Istanbul | 200 | 1 day, 1 hour less than last year | 1 | 24 | 1 hour | 1 | 25 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 403 | Cleveland | 29 | 1 day, 2 hours less than last year | 1 | 24 | 2 hour | 2 | 26 |
| 405 | Milwaukee | 32 | 1 day, 3 hours less than last year | 1 | 24 | 3 hour | 3 | 27 |
| 406 | Indianapolis | 36 | 1 day, 9 hours less than last year | 1 | 24 | 9 hour | 9 | 33 |
| 407 | Minneapolis | 34 | 2 days, 3 hours less than last year | 2 | 48 | 3 hour | 3 | 51 |
| 412 | Winston-Salem | 29 | 1 day, 2 hours less than last year | 1 | 24 | 2 hour | 2 | 26 |
232 rows × 8 columns
with_days.wasted_2020 = with_days.wasted_2020.astype(int)/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/pandas/core/generic.py:5168: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[name] = value
with_days['hours_wasted_2019'] = with_days.wasted_2020 + with_days.total_hours/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
with_days| city | wasted_2020 | wasted_2019 | no_of_days | day_hours | just_hours | add_hours | total_hours | hours_wasted_2019 | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Moscow region (oblast) | 200 | 1 day, 1 hour less than last year | 1 | 24 | 1 hour | 1 | 25 | 225 |
| 1 | Mumbai | 172 | 1 day, 13 hours less than last year | 1 | 24 | 13 hour | 13 | 37 | 209 |
| 2 | Bogota | 165 | 2 days, 17 hours less than last year | 2 | 48 | 17 hour | 17 | 65 | 230 |
| 3 | Manila | 188 | 2 days, 21 hours less than last year | 2 | 48 | 21 hour | 21 | 69 | 257 |
| 4 | Istanbul | 200 | 1 day, 1 hour less than last year | 1 | 24 | 1 hour | 1 | 25 | 225 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 403 | Cleveland | 29 | 1 day, 2 hours less than last year | 1 | 24 | 2 hour | 2 | 26 | 55 |
| 405 | Milwaukee | 32 | 1 day, 3 hours less than last year | 1 | 24 | 3 hour | 3 | 27 | 59 |
| 406 | Indianapolis | 36 | 1 day, 9 hours less than last year | 1 | 24 | 9 hour | 9 | 33 | 69 |
| 407 | Minneapolis | 34 | 2 days, 3 hours less than last year | 2 | 48 | 3 hour | 3 | 51 | 85 |
| 412 | Winston-Salem | 29 | 1 day, 2 hours less than last year | 1 | 24 | 2 hour | 2 | 26 | 55 |
232 rows × 9 columns
without_days = df2[~df2.wasted_2019.str.contains("day")]without_days['hours_change_2019'] = without_days.wasted_2019.str.extract("(^\d+)\s.*")/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
"""Entry point for launching an IPython kernel.
without_days.hours_change_2019 = without_days.hours_change_2019.fillna(0)/Users/khanfazil/.pyenv/versions/3.7.1/lib/python3.7/site-packages/pandas/core/generic.py:5168: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[name] = value
without_days.head(60)| city | wasted_2020 | wasted_2019 | hours_change_2019 | |
|---|---|---|---|---|
| 6 | Kyiv | 207 | 20 hours less than last year | 20 |
| 8 | Novosibirsk | 181 | 14 hours less than last year | 14 |
| 10 | Odessa | 167 | 17 hours less than last year | 17 |
| 11 | Saint Petersburg | 186 | 21 hours less than last year | 21 |
| 12 | Kharkiv | 163 | same as last year | 0 |
| 16 | Chongqing | 200 | 10 hours more than last year | 10 |
| 18 | Tokyo | 147 | 2 hours less than last year | 2 |
| 19 | Samara | 167 | 21 hours less than last year | 21 |
| 21 | Dnipro | 147 | 2 hours less than last year | 2 |
| 22 | Taipei | 154 | 16 hours more than last year | 16 |
| 25 | Changchun | 156 | 12 hours more than last year | 12 |
| 29 | Cairo | 126 | 12 hours less than last year | 12 |
| 32 | Osaka | 124 | 4 hours less than last year | 4 |
| 33 | Taichung | 126 | 7 hours more than last year | 7 |
| 34 | Taoyuan | 140 | 16 hours more than last year | 16 |
| 36 | Rostov-on-Don | 140 | 14 hours less than last year | 14 |
| 37 | Nagoya | 128 | 2 hours more than last year | 2 |
| 38 | Kaohsiung | 115 | 5 hours more than last year | 5 |
| 40 | Tainan | 112 | 7 hours more than last year | 7 |
| 45 | Chelyabinsk | 131 | 18 hours less than last year | 18 |
| 49 | Omsk | 135 | 12 hours less than last year | 12 |
| 54 | Izmir | 135 | 5 hours less than last year | 5 |
| 55 | Nizhny Novgorod | 135 | 21 hours less than last year | 21 |
| 56 | Hong Kong | 126 | 5 hours less than last year | 5 |
| 57 | Berlin | 108 | 16 hours less than last year | 16 |
| 63 | Kazan | 128 | 5 hours less than last year | 5 |
| 66 | Ankara | 117 | 23 hours less than last year | 23 |
| 68 | Chengdu | 121 | 21 hours less than last year | 21 |
| 69 | Tomsk | 126 | 18 hours less than last year | 18 |
| 70 | Sapporo | 98 | 3 hours less than last year | 3 |
| 74 | Shenyang | 115 | 3 hours more than last year | 3 |
| 75 | Limerick | 103 | 21 hours less than last year | 21 |
| 77 | Genoa | 103 | 18 hours less than last year | 18 |
| 81 | Wellington | 131 | 11 hours less than last year | 11 |
| 83 | Szczecin | 103 | 21 hours less than last year | 21 |
| 88 | Adana | 92 | same as last year | 0 |
| 90 | Lublin | 94 | 7 hours less than last year | 7 |
| 93 | Antalya | 96 | 16 hours less than last year | 16 |
| 95 | Changsha | 135 | 19 hours less than last year | 19 |
| 96 | Toulon | 112 | 23 hours less than last year | 23 |
| 98 | Vienna | 94 | 18 hours less than last year | 18 |
| 102 | Kobe | 89 | 2 hours more than last year | 2 |
| 104 | Bursa | 112 | 7 hours more than last year | 7 |
| 106 | Nuremberg | 96 | 23 hours less than last year | 23 |
| 109 | Haarlem | 80 | 23 hours less than last year | 23 |
| 115 | Shijiazhuang | 96 | same as last year | 0 |
| 116 | Beijing | 131 | 18 hours less than last year | 18 |
| 117 | Hamilton | 110 | 11 hours less than last year | 11 |
| 119 | Kassel | 92 | 23 hours less than last year | 23 |
| 121 | Montpellier | 103 | 21 hours less than last year | 21 |
| 127 | Gaziantep | 82 | 7 hours more than last year | 7 |
| 132 | Dresden | 87 | 14 hours less than last year | 14 |
| 133 | Mersin | 78 | 5 hours more than last year | 5 |
| 134 | Nanjing | 117 | 11 hours less than last year | 11 |
| 143 | Graz | 82 | 19 hours less than last year | 19 |
| 145 | Kiel | 80 | 18 hours less than last year | 18 |
| 148 | Leipzig | 82 | 12 hours less than last year | 12 |
| 150 | Xiamen | 124 | 18 hours less than last year | 18 |
| 151 | Shanghai | 119 | 14 hours less than last year | 14 |
| 153 | Bialystok | 85 | 20 hours less than last year | 20 |
merged = df2.merge(with_days, how='left', left_index=True, right_index=True)merged.head(20)| city_x | wasted_2020_x | wasted_2019_x | city_y | wasted_2020_y | wasted_2019_y | no_of_days | day_hours | just_hours | add_hours | total_hours | hours_wasted_2019 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Moscow region (oblast) | 200 | 1 day, 1 hour less than last year | Moscow region (oblast) | 200.0 | 1 day, 1 hour less than last year | 1.0 | 24.0 | 1 hour | 1.0 | 25.0 | 225.0 |
| 1 | Mumbai | 172 | 1 day, 13 hours less than last year | Mumbai | 172.0 | 1 day, 13 hours less than last year | 1.0 | 24.0 | 13 hour | 13.0 | 37.0 | 209.0 |
| 2 | Bogota | 165 | 2 days, 17 hours less than last year | Bogota | 165.0 | 2 days, 17 hours less than last year | 2.0 | 48.0 | 17 hour | 17.0 | 65.0 | 230.0 |
| 3 | Manila | 188 | 2 days, 21 hours less than last year | Manila | 188.0 | 2 days, 21 hours less than last year | 2.0 | 48.0 | 21 hour | 21.0 | 69.0 | 257.0 |
| 4 | Istanbul | 200 | 1 day, 1 hour less than last year | Istanbul | 200.0 | 1 day, 1 hour less than last year | 1.0 | 24.0 | 1 hour | 1.0 | 25.0 | 225.0 |
| 5 | Bengaluru | 167 | 3 days, 4 hours less than last year | Bengaluru | 167.0 | 3 days, 4 hours less than last year | 3.0 | 72.0 | 4 hour | 4.0 | 76.0 | 243.0 |
| 6 | Kyiv | 207 | 20 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | New Delhi | 156 | 1 day, 10 hours less than last year | New Delhi | 156.0 | 1 day, 10 hours less than last year | 1.0 | 24.0 | 10 hour | 10.0 | 34.0 | 190.0 |
| 8 | Novosibirsk | 181 | 14 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | Bangkok | 179 | 1 day, 4 hours less than last year | Bangkok | 179.0 | 1 day, 4 hours less than last year | 1.0 | 24.0 | 4 hour | 4.0 | 28.0 | 207.0 |
| 10 | Odessa | 167 | 17 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 11 | Saint Petersburg | 186 | 21 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 12 | Kharkiv | 163 | same as last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 13 | Lodz | 151 | 1 day, 11 hours less than last year | Lodz | 151.0 | 1 day, 11 hours less than last year | 1.0 | 24.0 | 11 hour | 11.0 | 35.0 | 186.0 |
| 14 | Lima | 135 | 3 days, 2 hours less than last year | Lima | 135.0 | 3 days, 2 hours less than last year | 3.0 | 72.0 | 2 hour | 2.0 | 74.0 | 209.0 |
| 15 | Pune | 133 | 2 days, 12 hours less than last year | Pune | 133.0 | 2 days, 12 hours less than last year | 2.0 | 48.0 | 12 hour | 12.0 | 60.0 | 193.0 |
| 16 | Chongqing | 200 | 10 hours more than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 17 | Bucharest | 165 | 2 days, 14 hours less than last year | Bucharest | 165.0 | 2 days, 14 hours less than last year | 2.0 | 48.0 | 14 hour | 14.0 | 62.0 | 227.0 |
| 18 | Tokyo | 147 | 2 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 19 | Samara | 167 | 21 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
merged = merged.merge(without_days, how='left', left_index=True, right_index=True)merged.head(20)| city_x | wasted_2020_x | wasted_2019_x | city_y | wasted_2020_y | wasted_2019_y | no_of_days | day_hours | just_hours | add_hours | total_hours | hours_wasted_2019 | city | wasted_2020 | wasted_2019 | hours_change_2019 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Moscow region (oblast) | 200 | 1 day, 1 hour less than last year | Moscow region (oblast) | 200.0 | 1 day, 1 hour less than last year | 1.0 | 24.0 | 1 hour | 1.0 | 25.0 | 225.0 | NaN | NaN | NaN | NaN |
| 1 | Mumbai | 172 | 1 day, 13 hours less than last year | Mumbai | 172.0 | 1 day, 13 hours less than last year | 1.0 | 24.0 | 13 hour | 13.0 | 37.0 | 209.0 | NaN | NaN | NaN | NaN |
| 2 | Bogota | 165 | 2 days, 17 hours less than last year | Bogota | 165.0 | 2 days, 17 hours less than last year | 2.0 | 48.0 | 17 hour | 17.0 | 65.0 | 230.0 | NaN | NaN | NaN | NaN |
| 3 | Manila | 188 | 2 days, 21 hours less than last year | Manila | 188.0 | 2 days, 21 hours less than last year | 2.0 | 48.0 | 21 hour | 21.0 | 69.0 | 257.0 | NaN | NaN | NaN | NaN |
| 4 | Istanbul | 200 | 1 day, 1 hour less than last year | Istanbul | 200.0 | 1 day, 1 hour less than last year | 1.0 | 24.0 | 1 hour | 1.0 | 25.0 | 225.0 | NaN | NaN | NaN | NaN |
| 5 | Bengaluru | 167 | 3 days, 4 hours less than last year | Bengaluru | 167.0 | 3 days, 4 hours less than last year | 3.0 | 72.0 | 4 hour | 4.0 | 76.0 | 243.0 | NaN | NaN | NaN | NaN |
| 6 | Kyiv | 207 | 20 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Kyiv | 207 | 20 hours less than last year | 20 |
| 7 | New Delhi | 156 | 1 day, 10 hours less than last year | New Delhi | 156.0 | 1 day, 10 hours less than last year | 1.0 | 24.0 | 10 hour | 10.0 | 34.0 | 190.0 | NaN | NaN | NaN | NaN |
| 8 | Novosibirsk | 181 | 14 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Novosibirsk | 181 | 14 hours less than last year | 14 |
| 9 | Bangkok | 179 | 1 day, 4 hours less than last year | Bangkok | 179.0 | 1 day, 4 hours less than last year | 1.0 | 24.0 | 4 hour | 4.0 | 28.0 | 207.0 | NaN | NaN | NaN | NaN |
| 10 | Odessa | 167 | 17 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Odessa | 167 | 17 hours less than last year | 17 |
| 11 | Saint Petersburg | 186 | 21 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Saint Petersburg | 186 | 21 hours less than last year | 21 |
| 12 | Kharkiv | 163 | same as last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Kharkiv | 163 | same as last year | 0 |
| 13 | Lodz | 151 | 1 day, 11 hours less than last year | Lodz | 151.0 | 1 day, 11 hours less than last year | 1.0 | 24.0 | 11 hour | 11.0 | 35.0 | 186.0 | NaN | NaN | NaN | NaN |
| 14 | Lima | 135 | 3 days, 2 hours less than last year | Lima | 135.0 | 3 days, 2 hours less than last year | 3.0 | 72.0 | 2 hour | 2.0 | 74.0 | 209.0 | NaN | NaN | NaN | NaN |
| 15 | Pune | 133 | 2 days, 12 hours less than last year | Pune | 133.0 | 2 days, 12 hours less than last year | 2.0 | 48.0 | 12 hour | 12.0 | 60.0 | 193.0 | NaN | NaN | NaN | NaN |
| 16 | Chongqing | 200 | 10 hours more than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Chongqing | 200 | 10 hours more than last year | 10 |
| 17 | Bucharest | 165 | 2 days, 14 hours less than last year | Bucharest | 165.0 | 2 days, 14 hours less than last year | 2.0 | 48.0 | 14 hour | 14.0 | 62.0 | 227.0 | NaN | NaN | NaN | NaN |
| 18 | Tokyo | 147 | 2 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Tokyo | 147 | 2 hours less than last year | 2 |
| 19 | Samara | 167 | 21 hours less than last year | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Samara | 167 | 21 hours less than last year | 21 |
Exporting the dataframe for final cleaning (removing some columns and simplifying numbers) in Excel.
merged.to_csv("all_traffic.csv", index=False)