20230220B.py

data = []

def get_coords_from_wiki_page(str) -> list:
    s = BeautifulSoup(requests.get(str).content, 'html.parser')
    return s.find(class_='geo').contents[0].split(';')

for r in rows:
    cells = r.find_all('td')
    shopping_centre = cells[1].a.contents[0]
    city_town = cells[2].get_text().replace('\n','')
    region = cells[3].get_text().replace('\n','')
    size_sq_m = int(cells[4].contents[0].replace(',',''))
    coords = get_coords_from_wiki_page('https://en.wikipedia.org/'+cells[1].a.get('href'))
    
    data.append((str(shopping_centre), city_town, region, size_sq_m, float(coords[0]), float(coords[1])))