latitudes = []
longitudes = []
regions = []
prices_m2 = []



for index, row in region_price_df.iterrows():
    print (row["Region"], row["Price per m2"])
    
    # Do mapping of lat and long for specific region
    geodata_region = geodataMapper(row["Region"])
    
    #Only fill the arrays if there is mapping data available
    if 'lat' in geodata_region:
        
        regions.append(row["Region"])
        prices_m2.append(row["Price per m2"])
        latitudes.append(geodata_region['lat'])
        longitudes.append(geodata_region['lng'])
    
heatmap_df = pd.DataFrame({'latitude': latitudes,
                       'longitude': longitudes,
                        'region' : regions,
                         'price_m2' : prices_m2})

heatmap_df.to_csv('heat_map.csv', encoding='utf-8-sig')