Help with Graph - France

📊 Plotly Python
1

Hello

I am trying to create a Scatter Plot type graph focused on country FRANCE. I have latitude and longitude along with Province name with price and number of records. I am looking for a graph similar to the below.

price-1200x927
price-1200x9271200×927 131 KB

Data is as follow

country,lat,lon,province,price,total
France,43.185395,3.155021,Languedoc-Roussillon,1,1082
France,43.47198,6.005143,Provence,2,1021
France,44.469596,4.801154,Rhône Valley,3,1318
France,44.493923,1.173853,Southwest France,4,1601
France,44.946792,-0.503963,Bordeaux,5,6111
France,46.224982,4.685808,Beaujolais,6,532
France,47.032347,4.817344,Burgundy,7,4308
France,47.563005,-0.4289267,Loire Valley,8,1786
France,48.142572,7.306696,Alsace,9,1680
France,48.815661,4.169706,Champagne,4,1370

I have the below python code, but it doesn’t focus on just FRANCE, didn’t find any options to limit to FRANCE.



import numpy as np

df_frn1 = pd.DataFrame({'country' : np.array(['France', 'France', 'France', 'France', 'France', 'France', 'France', 'France', 'France', 'France' ]),
                                 'lat' : np.array([43.185395, 43.471986, 44.469596, 44.493923, 44.946792,46.224982,47.032347, 47.563005, 48.142572 ,48.815661]),
                                 'lon' : np.array([ 3.155021,  6.005143,  4.801154,  1.173853, -0.503963, 4.685808 ,4.817344 ,-0.4289267 ,7.306696,  4.169706]),
                                 'province' : np.array(['Languedoc-Roussillon','Provence','Rene Valley','Southwest France','Bordeaux','Beaujolais','Burgundy','Loire Valley','Alsace', 'Champagne']),
                                 'price' : np.array([1,2,3,4,5,6,7,8,9,7]),
                                 'total' : np.array([1082,1021,1318,1601,6111,532,4308,1786,1680,1370 ])
                                })

df_frn1


import plotly.graph_objects as go
import pandas as pd

fig = go.Figure(data=go.Scattergeo(
    lon = dfrn1['lon'],
    lat = dfrn1['lat'],
    text = dfrn1['province'],
    mode = 'markers',
    marker_color = dfrn1['price'],
))

fig.update_layout(
    title = 'Average price by Provience',
    geo_scope = 'europe'
)

fig.show()

Output of the above code is the following graph
Capture

Can you help me to create the graph similar to first one for above data set.

2

You will need to provide your own geojson file with the polygons needed. Here is the GitHub repo I use for France maps.
I also use Mapshaper in order to simplify the geometry (less points in polygons -> lighter geojson files -> faster loading of my maps in a Dash app).

Take a look at the documentation https://plot.ly/python/reference/#scattergeo-geojson

3

Thanks Batalex, I’ll go through the link

I was able to do a little progress on it though yesterday night, now the only thing missing in the final graph is Data Labels (Province) and Legends (Price)

# Extract the data we're interested in
lat = df['lat'].values
lon = df['lon'].values
price  = df['price'].values
total = df['total'].values
province = df['province'].values


fig = plt.figure(figsize=(12, 12))

m = Basemap(projection='cass', resolution='h', 
            lat_0= 46.2276 , lon_0= 2.2137 ,
            width=1E6, height=1.2E6)

m.drawcoastlines(color='gray')
m.drawcountries(color='gray')
m.drawstates(color='gray')

# 2. scatter city data, with color reflecting population
# and size reflecting area
m.scatter(lon, lat, latlon = True,
          c = total, s = price * 80 ,
          cmap = 'RdBu_r', alpha =0.8)


# 3. create colorbar and legend
#plt.colorbar(label=r'Avg Wine Price')
#plt.clim(50,100)
1 Like