Labels inside Counties for a map

JustinT · September 25, 2018, 8:04pm

Hello,

Kind of a newbie question but I have not been able to find the proper answer. Instead of having the hover label, I was trying to find a way to show labels in each county Polygon. I have the following code:

init_notebook_mode()

data=pd.read_excel(‘AZ Sales by FIPS.xlsx’, dtype={‘FIPS’:object})

df_sample_r = data[data[‘State’] == ‘AZ’]

values = df_sample_r[‘Sales’].tolist()
fips = df_sample_r[‘FIPS’].tolist()

colorscale = [
‘rgb(193, 193, 193)’,
‘rgb(239,239,239)’,
‘rgb(195, 196, 222)’,
‘rgb(144,148,194)’,
‘rgb(101,104,168)’,
‘rgb(65, 53, 132)’
]

fig = ff.create_choropleth(
fips=fips, values=values, scope=[‘AZ’],
binning_endpoints=[1, 4, 7, 10, 13], colorscale=colorscale,
county_outline={‘color’: ‘rgb(0,0,0)’, ‘width’: 1.0}, round_legend_values=True,
legend_title=‘Sales by County’, title=‘AZ’
)
iplot(fig, filename=‘choropleth_arizona’)

Thank you,

Justin

jmmease · September 26, 2018, 9:45am

Hi @JustinT,

There’s not a built-in way to do this at the moment, but a nice thing about figure figure factories is that they return a figure object that you can inspect and modify before displaying. Here’s one way to get there.

# Get hover trace
hover_scatter = [scatt for scatt in fig.data if scatt.mode == 'markers'][0]

# Update text to include only county (Not state, FIPS, ec.)
import re
def extract_county(text_val):
    return re.sub(r'County: (.*?)<br>.*', r'\1', text_val)

hover_scatter.text = [extract_county(text_val) for text_val in hover_scatter.text]

# Show text
hover_scatter.mode = 'markers+text'

# Set font properties
hover_scatter.textfont.size = 8

Basically what this is doing is

Searching for the scatter trace that the hover tooltips are associated with
Updating the marker text to include only the country (instead of the default text with State, FIPS, etc)
Configuring the scatter trace to show the text at the marker location
Setting the font size (you could also set the font family and color here if you want)

Hope that helps get you started!
-Jon

JustinT · September 26, 2018, 12:10pm

Hi Jon,

Thanks for the help much appreciated.

I am getting a slight error message when I attempt the first line of code.

JustinT · September 26, 2018, 1:15pm



Hi Jon,

Thanks for the help much appreciated.

I am getting a slight error message when I attempt the first line of code.

Get hover trace

hover_scatter = [scatt for scatt in fig.data() if scatt.mode == ‘markers’][0]

---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
in ()
1 # Get hover trace
2
----> 3 hover_scatter = [scatt for scatt in fig.data() if scatt.mode == ‘markers’][0]
4

AttributeError: ‘dict’ object has no attribute ‘data’

I tried a few ways to get at the dictionary object but as a novice, I am still having difficulty. Any further help would be much appreciated and Thank you!

Justin

jmmease · September 28, 2018, 9:21am

Hi @JustinT, my guess is that you’re using an older version of plotly.py. I’d recommend upgrading to version 3.2.1 if that’s an option for you.

Before version 3 is wasn’t possible to use property access syntax of graph objects. So you couldn’t write fig.data, instead you had to use fig.['data']. So in version 2 this first line would need to be

hover_scatter = [scatt for scatt in fig['data'] if scatt['mode'] == 'markers'][0]

And similarly, the other property access expressions would need to be converted to dict get item syntax.

Hope that helps!
-Jon

JustinT · September 28, 2018, 1:20pm

Hi @jmmease, looking at my version, it says I have version 3.2.1. I have had some issues using my sign in, which causes me to do everything in offline mode. Could that be the issue?

I am using Juptyer Notebook from Anaconda. If there is a better way, I am all ears.

I also tried some plotting from an article on medium that you were a part of. Really nice article! If I did not use the iplot command, I would get the following as a result:

Thank you for all the help in this matter and sorry for all the follow up questions. Just excited to use plotly and curious how to fix the issues.

Thanks again!
Justin

jmmease · October 1, 2018, 9:41am

Hi @JustinT,

Let’s see. If you’re using version 3+ and you’re getting AttributeError: 'dict' object has no attribute 'data', then is sounds like the fig object you’re working with is a dictionary. You can build a figure object from a dict using the go.Figure constructor. So, as a full example…

# Build figure object (in case fig is a dictionary)
fig = go.Figure(fig)

# Get hover trace
hover_scatter = [scatt for scatt in fig.data if scatt.mode == 'markers'][0]

# Update text to include only county (Not state, FIPS, ec.)
import re
def extract_county(text_val):
    return re.sub(r'County: (.*?)<br>.*', r'\1', text_val)

hover_scatter.text = [extract_county(text_val) for text_val in hover_scatter.text]

# Show text
hover_scatter.mode = 'markers+text'

# Set font properties
hover_scatter.textfont.size = 8

For the FigureWidget case. Are you using the classic jupyter notebook or JupyterLab? In the classic notebook FigureWidget should just work if you have plotly.py 3+ installed along with recent versions of the notebook and ipywidgets packages.

If you’re working in JupyterLab, there are a few more moving parts. Follow the JupyterLab installation instruction at https://github.com/plotly/plotly.py#installation (either pip or conda is fine). Pay close attention to the versions number of everything to make sure everything is compatible.

If all of that doens’t help. Could you add the output of the following commands here.

pip list
conda list
jupyter nbextensions list (if classic notebook)
jupyter labextension list (if JupyterLab)

Hope that helps!
-Jon

JustinT · October 1, 2018, 1:53pm

Hi @jmmease,

The code seemed to do the trick! Very appreciative of all the extra effort of looking into this for me. Your help was huge! 2 minor (I hope) follow up questions.

How do I reposition the labels, if possible. I have a couple that are outside of the polygons just due to their small size (see picture below). I was looking at the X anchor but wasn’t 100% sure how to change it.
After the labels are added, is it possible to change the hover back to show only the County and the Values? I wasn’t really sure how to add that column’s info back in.

For the FigureWidget:
I am working in the classic Jupyter Notebook. I updated Notebook and ipywidgets and received the same result.

Here is the output you suggested:
Package Version

alabaster 0.7.10
anaconda-client 1.6.14
anaconda-navigator 1.8.7
anaconda-project 0.8.2
appdirs 1.4.3
asn1crypto 0.24.0
astroid 1.6.3
astropy 3.0.2
attrs 18.1.0
Automat 0.7.0
Babel 2.5.3
backcall 0.1.0
backports.shutil-get-terminal-size 1.0.0
beautifulsoup4 4.6.0
bitarray 0.8.1
bkcharts 0.2
blaze 0.11.3
bleach 2.1.3
bokeh 0.13.0
boto 2.48.0
Bottleneck 1.2.1
certifi 2018.8.24
cffi 1.11.5
chardet 3.0.4
click 6.7
click-plugins 1.0.3
cligj 0.4.0
cloudpickle 0.5.3
clyent 1.2.2
colorama 0.3.9
comtypes 1.1.4
conda 4.5.11
conda-build 3.10.5
conda-verify 2.0.0
constantly 15.1.0
contextlib2 0.5.5
cryptography 2.2.2
cycler 0.10.0
Cython 0.28.2
cytoolz 0.9.0.1
dask 0.17.5
datashape 0.5.4
decorator 4.3.0
descartes 1.1.0
distributed 1.21.8
docutils 0.14
entrypoints 0.2.3
et-xmlfile 1.0.1
fastcache 1.0.2
filelock 3.0.4
Fiona 1.7.10
Flask 1.0.2
Flask-Cors 3.0.4
GDAL 2.2.2
geopandas 0.3.0
gevent 1.3.0
glob2 0.6
greenlet 0.4.13
h5py 2.8.0
heapdict 1.0.0
html5lib 1.0.1
hyperlink 18.0.0
idna 2.6
imageio 2.3.0
imagesize 1.0.0
incremental 17.5.0
ipykernel 4.8.2
ipython 6.4.0
ipython-genutils 0.2.0
ipywidgets 7.4.2
isort 4.3.4
itsdangerous 0.24
jdcal 1.4
jedi 0.12.0
Jinja2 2.10
jsonschema 2.6.0
jupyter 1.0.0
jupyter-client 5.2.3
jupyter-console 5.2.0
jupyter-core 4.4.0
jupyterlab 0.32.1
jupyterlab-launcher 0.10.5
keyring 13.2.1
kiwisolver 1.0.1
lazy-object-proxy 1.3.1
llvmlite 0.23.1
locket 0.2.0
lxml 4.2.1
MarkupSafe 1.0
matplotlib 2.2.2
mccabe 0.6.1
menuinst 1.4.14
mistune 0.8.3
mkl-fft 1.0.0
mkl-random 1.0.1
more-itertools 4.1.0
mpmath 1.0.0
msgpack-python 0.5.6
multipledispatch 0.5.0
munch 2.3.2
navigator-updater 0.2.1
nbconvert 5.3.1
nbformat 4.4.0
networkx 2.1
nltk 3.3
nose 1.3.7
notebook 5.6.0
numba 0.38.0
numexpr 2.6.5
numpy 1.14.3
numpydoc 0.8.0
odo 0.5.1
olefile 0.45.1
openpyxl 2.5.3
packaging 17.1
pandas 0.23.0
pandocfilters 1.4.2
parso 0.2.0
partd 0.3.8
path.py 11.0.1
pathlib2 2.3.2
patsy 0.5.0
pep8 1.7.1
pickleshare 0.7.4
Pillow 5.1.0
pip 10.0.1
pkginfo 1.4.2
plotly 3.2.1
pluggy 0.6.0
ply 3.11
prometheus-client 0.3.1
prompt-toolkit 1.0.15
psutil 5.4.5
psycopg2 2.7.5
py 1.5.3
pyasn1 0.4.4
pyasn1-modules 0.2.2
pycodestyle 2.4.0
pycosat 0.6.3
pycparser 2.18
pycrypto 2.6.1
pycurl 7.43.0.1
pyflakes 1.6.0
Pygments 2.2.0
pylint 1.8.4
pyodbc 4.0.24
pyOpenSSL 18.0.0
pyparsing 2.2.0
pyproj 1.9.5.1
PySAL 1.14.4.post1
pyshp 1.2.12
PySocks 1.6.8
pytest 3.5.1
pytest-arraydiff 0.2
pytest-astropy 0.3.0
pytest-doctestplus 0.1.3
pytest-openfiles 0.3.0
pytest-remotedata 0.2.1
python-dateutil 2.7.3
pytz 2018.4
PyWavelets 0.5.2
pywin32 223
pywinpty 0.5.1
PyYAML 3.12
pyzmq 17.0.0
QtAwesome 0.4.4
qtconsole 4.3.1
QtPy 1.4.1
requests 2.18.4
retrying 1.3.3
rope 0.10.7
Rtree 0.8.3
ruamel-yaml 0.15.35
scikit-image 0.13.1
scikit-learn 0.19.1
scipy 1.1.0
seaborn 0.8.1
Send2Trash 1.5.0
service-identity 17.0.0
setuptools 39.1.0
Shapely 1.6.4.post1
simplegeneric 0.8.1
singledispatch 3.4.0.3
six 1.11.0
snowballstemmer 1.2.1
sortedcollections 0.6.1
sortedcontainers 1.5.10
Sphinx 1.7.4
sphinxcontrib-websupport 1.0.1
spyder 3.3.1
spyder-kernels 0.2.6
SQLAlchemy 1.2.7
statsmodels 0.9.0
sympy 1.1.1
tables 3.4.4
tblib 1.3.2
terminado 0.8.1
testpath 0.3.1
toolz 0.9.0
tornado 5.0.2
traitlets 4.3.2
Twisted 18.7.0
typing 3.6.4
unicodecsv 0.14.1
urllib3 1.22
wcwidth 0.1.7
webencodings 0.5.1
Werkzeug 0.14.1
wheel 0.31.1
widgetsnbextension 3.4.2
win-inet-pton 1.0.1
win-unicode-console 0.5
wincertstore 0.2
wrapt 1.10.11
xlrd 1.1.0
XlsxWriter 1.0.4
xlwings 0.11.8
xlwt 1.3.0
zict 0.1.3
zope.interface 4.5.0
You are using pip version 10.0.1, however version 18.0 is available.
You should consider upgrading via the ‘python -m pip install --upgrade pip’ command.

Conda List:

packages in environment at C:\Users\jtanguay\AppData\Local\Continuum\anaconda3:

jupyter nbextensions list:
(base) C:>jupyter nbextensions list
Error executing Jupyter command ‘nbextensions’: [Errno ‘jupyter-nbextensions’ not found] 2

Was curious if this was the problem. I went to download via conda install -c conda-forge jupyter_contrib_nbextensions but was curious if that was the best method, since it stated it was downgrading several packages.

Sorry for the long winded message, but thank you for the help Jon!
Justin

jmmease · October 3, 2018, 10:03am

Hi @JustinT,

If you’d like to show different text in the map than in the hover label then instead of directly modifying the trace produced by create_choropleth you should make a copy of it, change the properties of the copy, then add the copy to the figure.

Something like:

# Get hover trace
hover_scatter = [scatt for scatt in fig.data if scatt.mode == 'markers'][0]

# Copy hover trace to make text trace
text_scatter = go.Scatter(hover_scatter)

# Update text to include only county (Not state, FIPS, ec.)
import re
def extract_county(text_val):
    return re.sub(r'County: (.*?)<br>.*', r'\1', text_val)

text_scatter.text = [extract_county(text_val) for text_val in text_scatter.text]

# Show text
text_scatter.mode = 'markers+text'

# Set font properties
text_scatter.textfont.size = 8

Then to tweak the position of the text labels, convert the x/y coords to lists, modify the lists, then assign back to the trace.

xs = list(text_scatter.x)
ys = list(text_scatter.y)

# Move the 4th label down and to the right a little
xs[3] = xs[3] + 5
ys[3] = ys[3] - 3

# Update text trace
text_scatter.x = xs
text_scatter.y = ys

Then add the copied trace to the figure

fig.add_trace(text_scatter)

Oh, I made a mistake in the one command. It should be jupyter nbextension list (No s in nbextension). Could you post this output? Here’s what the plotlywidget and jupyter-js-widgets parts should look like.

Known nbextensions:
  config dir: /anaconda3/envs/jupyter_editor_dev/etc/jupyter/nbconfig
    notebook section
      plotlywidget/extension  enabled 
      - Validating: OK
      jupyter-js-widgets/extension  enabled 
      - Validating: OK

Also, it looks like you have the the notebook, ipywidgets, and plotly packages installed through both pip and conda. I’d recommend uninstalling all three packages using both pip and conda, and then reinstalling them using one or the other.

If that doesn’t take care of it. Try creating a fresh conda environment (https://conda.io/docs/user-guide/tasks/manage-environments.html) and following the plotly installation instructions again in the new environment and see if things work there.

Hope that helps!
-Jon

adamsj7 · June 11, 2019, 9:19pm

I am also attempting to follow your code above. The below produces a county map but I am unable to get your code to work to add the county labels (in Spyder). I receive the same message ‘Figure’ object has no attribute ‘df_sample_r’. I am working in Plotly offline mode. Do I run your code after I create the map? I’m not sure at which step to add your code or what object to apply it to. Thank you for your help.

Preformatted textcore_states = [‘NE’, ‘IA’]
df_sample_r = ctyname_cum[ctyname_cum[‘STD_STATE’].isin(core_states)]

values = df_sample_r[‘Customer_Opp’].tolist()
fips = df_sample_r[‘FIPS5’].tolist()

colorscale = [
‘RGB(0,255,255)’, ‘RGB(131,139,139)’, ‘RGB(255,97,3)’]

fig = ff.create_choropleth(
fips=fips, values=values, scope=core_states, show_state_data=True,
colorscale=colorscale, round_legend_values=True,
plot_bgcolor=‘rgb(229,229,229)’,
paper_bgcolor=‘rgb(229,229,229)’,
legend_title=‘HH by County’,
county_outline={‘color’: ‘rgb(255,255,255)’, ‘width’: 0.5},
exponent_format=True,
)
plot(fig, auto_open = True)

jmmease · June 13, 2019, 10:20am

Hi @adamsj7,

The error message “‘Figure’ object has no attribute ‘df_sample_r’” implies that somewhere in the code you’re running there is a statement like fig.df_sample_r. If you’d like more help working through it, please post a full reproducible example (including imports and sample data) and place the example inside a fenced code block (See https://help.github.com/en/articles/creating-and-highlighting-code-blocks).

-Jon

adamsj7 · June 13, 2019, 2:44pm

@jmmease
Thank you for your quick reply. I have fenced the code below with explanations of key column headers. I am unable to provide the data due to data sharing rules. I hope the code with explanation will suffice. The below code works to create the map but the goal is to label the counties as well.

#ctyname_cum is a data frame with columns
#county FIPS codes = FIPS5
#categorical variable to color counties by = 'Customer_Opp'
#county names = 'Name'

core_states = [‘NE’, ‘IA’]
df_sample_r = ctyname_cum[ctyname_cum[‘STD_STATE’].isin(core_states)]

values = df_sample_r[‘Customer_Opp’].tolist()
fips = df_sample_r[‘FIPS5’].tolist()

colorscale = [
‘RGB(0,255,255)’, ‘RGB(131,139,139)’, ‘RGB(255,97,3)’]

fig = ff.create_choropleth(
fips=fips, values=values, scope=core_states, show_state_data=True,
colorscale=colorscale, round_legend_values=True,
plot_bgcolor=‘rgb(229,229,229)’,
paper_bgcolor=‘rgb(229,229,229)’,
legend_title=‘HH by County’,
county_outline={‘color’: ‘rgb(255,255,255)’, ‘width’: 0.5},
exponent_format=True,
)
plot(fig, auto_open = True)

jmmease · June 15, 2019, 12:05pm

Hi @adamsj7,

I don’t see anything in your code that looks like it should result in that error. Could you also add a full stack trace of the error you’re seeing?

It would also be helpful if you could make up some simple sample data for the data frame that results in the error.

-Jon

saswat · October 29, 2019, 7:46pm

Hi, I am having a similar issue where I want to display county labels on my map as the hover doesn’t seem to work (I think this is a known issue as I saw other people struggle with this too).

I tried to use the solution provided here but it did not end up changing my plot…Can someone please help me understand what I am doing wrong? I see that it’s supposed to extract county names with some regex rules from fig.data, and I see that those are there in data.fig but I’m not sure really how to put those values on the map.

My code looks like this:

values = dfCounty['PercentChangeSIR'].tolist()
fips = dfCounty['FIPS'].tolist()

#diverging colorscheme
colorscale=["#006837","#1a9850","#66bd63","#a6d96a","#d9ef8b","#ffffbf",
"#fee08b","#fdae61","#f46d43","#d73027","#a50026","#8e0152"]

#colorscheme that is colorblind friendly
colorscale_colorblind=[ "#276419","#4d9221","#7fbc41","#b8e186","#e6f5d0","#f7f7f7",
             "#fde0ef","#f1b6da","#de77ae","#c51b7d","#8e0152","#8e0152"]


fig = ff.create_choropleth(
    fips=fips, values=values, scope=['CA'],
    binning_endpoints=[-100, -80, -60, -40, -20, 0, 20, 40, 60, 80, 100], colorscale=colorscale,
    county_outline={'color': 'rgb(255,255,255)', 'width': 0.5}, round_legend_values=True, show_state_data=True, show_hover=True,
    legend_title='% Change, 2015 to 2017', title='C. difficile Infection by County in California'
)


fig.write_image("images/fig1.png", scale=4)
fig.layout.template = None
fig.show()

Topic		Replies	Views
Plotly Choropleth County Maps - If Hover Information Not Showing, try this solution plotly.js	3	2363	November 20, 2019
How to show hover info on county Choropleths? 📊 Plotly Python	0	310	August 16, 2019
Shapes. Annotation 📊 Plotly Python	3	3943	May 24, 2017
How can I change the hover labels into static labels? 📊 Plotly Python	4	5793	July 6, 2017
Annotations on plotly Choropleth 📊 Plotly Python	8	8509	June 10, 2022

Labels inside Counties for a map

Get hover trace

packages in environment at C:\Users\jtanguay\AppData\Local\Continuum\anaconda3:

Name Version Build Channel

Related Topics