Adding geom_text to each bin in geom_bin2d

[syd-doyen]

Hi,
I'm drawing a heatmap with geom_bin2d and I would like to annotate each bin with number of counts for that bin.

   import pandas as pd
   import os
   import lets_plot as lp

    df = pd.DataFrame(data=[['Subaru', 'Sold', 4], ['Subaru', 'InStock', 16],
                            ['Nissan', 'Sold', 2], ['Nissan', 'InStock', 8],
                            ['Ford', 'Sold', 3], ['Ford', 'InStock', 10],
                            ['Honda', 'Sold', 6], ['Honda', 'InStock', 2],
                            ], columns=['Brand', 'Status', 'Available'])

    lp.LetsPlot.setup_html()
    p2 = (lp.ggplot(df, lp.aes(x='Brand', y='Status', weight='Available'))
         + lp.geom_bin2d(alpha=0.7)
         + lp.scale_fill_gradient(low='lightgreen', high='darkgreen')
         + lp.theme_bw()
         )

If I add the following line

lp.geom_text(lp.aes(label='..count..'), stat = 'count', label_format="{d}", size=8)

I get the following. It almost like geom_text does not know how to convert the position in the discrete axes.

Thanks for any tips.

[syd-doyen]

Hi,
I do not know enough about the inner workings of how statistics are calculate by the geom_bin2d and how geom_text has access to them.
But I fixed my issue by directly passing the value to geom_text

   import pandas as pd
   import os
   import lets_plot as lp

    df = pd.DataFrame(data=[['Subaru', 'Sold', 4], ['Subaru', 'InStock', 16],
                            ['Nissan', 'Sold', 2], ['Nissan', 'InStock', 8],
                            ['Ford', 'Sold', 3], ['Ford', 'InStock', 10],
                            ['Honda', 'Sold', 6], ['Honda', 'InStock', 2],
                            ], columns=['Brand', 'Status', 'Available'])

    lp.LetsPlot.setup_html()
    p2 = (lp.ggplot(df, lp.aes(x='Brand', y='Status', weight='Available'))
         + lp.geom_bin2d(alpha=0.7)
# access the values directly from df
         + lp.geom_text(lp.aes(label='Available'), label_format="{d}", size=8)
         + lp.scale_fill_gradient(low='lightgreen', high='darkgreen')
         + lp.theme_bw()
         )

Thanks.

[alshan]

Hi @syd-doyen !

Sorry I wasn't able to look at your case earlier. The problem with your original solution was that in geom_text() you were using stat 'count' instead of stat 'bin2d'.