Seaborn Barplot - Displaying Values

Question

I m looking to see how to do two things in Seaborn with using a bar chart to display values that are in the dataframe  but not in the graph  1  I m looking to display the values of one field in a dataframe while graphing another   For example  below  I m graphing  tip   but I would like to place the value of  total bill  centered above each of the bars  i e 325 88 above Friday   1778 40 above Saturday  etc    2  Is there a way to scale the colors of the bars  with the lowest value of  total bill  having the lightest color  in this case Friday  and the highest value of  total bill  having the darkest   Obviously  I d stick with one color  i e  blue  when I do the scaling   Thanks  I m sure this is easy  but i m missing it    While I see that others think that this is a duplicate of another problem  or two   I am missing the part of how I use a value that is not in the graph as the basis for the label or the shading   How do I say  use total bill as the basis   I m sorry  but I just can t figure it out based on those answers   Starting with the following code   import pandas as pd import seaborn as sns  matplotlib inline df pd read csv  https   raw githubusercontent com wesm pydata-    book master ch08 tips csv   sep      groupedvalues df groupby  day   sum   reset index   g sns barplot x  day  y  tip  data groupedvalues    I get the following result     Interim Solution   for index  row in groupedvalues iterrows        g text row name row tip  round row total bill 2   color  black   ha  center       On the shading  using the example below  I tried the following   import pandas as pd import seaborn as sns  matplotlib inline df pd read csv  https   raw githubusercontent com wesm pydata-book master ch08 tips csv   sep      groupedvalues df groupby  day   sum   reset index    pal   sns color palette  Greens d   len data   rank   groupedvalues argsort   argsort    g sns barplot x  day  y  tip  data groupedvalues   for index  row in groupedvalues iterrows        g text row name row tip  round row total bill 2   color  black   ha  center     But that gave me the following error   AttributeError   DataFrame  object has no attribute  argsort   So I tried a modification   import pandas as pd import seaborn as sns  matplotlib inline df pd read csv  https   raw githubusercontent com wesm pydata-book master ch08 tips csv   sep      groupedvalues df groupby  day   sum   reset index    pal   sns color palette  Greens d   len data   rank groupedvalues  total bill   rank ascending True  g sns barplot x  day  y  tip  data groupedvalues palette np array pal   -1   rank     and that leaves me with   IndexError  index 4 is out of bounds for axis 0 with size 4

User · Accepted Answer

Let s stick to the solution from the linked question  Changing color scale in seaborn bar plot   You want to use argsort to determine the order of the colors to use for colorizing the bars  In the linked question argsort is applied to a Series object  which works fine  while here you have a DataFrame  So you need to select one column of that DataFrame to apply argsort on   import seaborn as sns import matplotlib pyplot as plt import numpy as np  df   sns load dataset  tips   groupedvalues df groupby  day   sum   reset index    pal   sns color palette  Greens d   len groupedvalues   rank   groupedvalues  total bill   argsort   argsort    g sns barplot x  day  y  tip  data groupedvalues  palette np array pal   -1   rank    for index  row in groupedvalues iterrows        g text row name row tip  round row total bill 2   color  black   ha  center    plt show        The second attempt works fine as well  the only issue is that the rank as returned by rank   starts at 1 instead of zero  So one has to subtract 1 from the array  Also for indexing we need integer values  so we need to cast it to int   rank   groupedvalues  total bill   rank ascending True  values rank    rank-1  astype np int

User · Answer

Works with single ax or with matrix of ax  subplots   from matplotlib import pyplot as plt import numpy as np  def show values on bars axs       def  show on single plot ax                   for p in ax patches               x   p get x     p get width     2              y   p get y     p get height               value       2f   format p get height                ax text  x   y  value  ha  center         if isinstance axs  np ndarray           for idx  ax in np ndenumerate axs                show on single plot ax      else           show on single plot axs   fig  ax   plt subplots 1  2  show values on bars ax

User · Answer

Just in case if anyone is interested in labeling horizontal barplot graph  I modified Sharon s answer as below    def show values on bars axs  h v  v   space 0 4       def  show on single plot ax           if h v     v               for p in ax patches                   x   p get x     p get width     2                  y   p get y     p get height                   value   int p get height                    ax text  x   y  value  ha  center            elif h v     h               for p in ax patches                   x   p get x     p get width     float space                   y   p get y     p get height                   value   int p get width                    ax text  x   y  value  ha  left        if isinstance axs  np ndarray           for idx  ax in np ndenumerate axs                show on single plot ax      else           show on single plot axs    Two parameters explained    h v - Whether the barplot is horizontal or vertical   h  represents the horizontal barplot   v  represents the vertical barplot    space - The space between value text and the top edge of the bar  Only works for horizontal mode    Example   show values on bars sns t   h   0 3

User · Answer

A simple way to do so is to add the below code  for Seaborn   for p in splot patches      splot annotate format p get height      1f                         p get x     p get width     2   p get height                         ha    center   va    center                       xytext    0  9                       textcoords    offset points     Example   splot   sns barplot df  X    df  Y      Annotate the bars in plot for p in splot patches      splot annotate format p get height      1f                         p get x     p get width     2   p get height                         ha    center   va    center                       xytext    0  9                       textcoords    offset points       plt show

User · Answer

plt figure figsize  15 10   graph   sns barplot x  name column x axis   y  name column x axis   data   dataframe name    color  salmon   for p in graph patches          graph annotate     0f   format p get height      p get x   0 3  p get height                         ha  center   va  bottom                       color   black

User · Answer

Hope this helps for item  2  a  You can sort by total bill then reset the index to this column b  Use palette  Blue  to use this color to scale your chart from light blue to dark blue  if dark blue to light blue then use palette  Blues d    import pandas as pd import seaborn as sns  matplotlib inline  df pd read csv  https   raw githubusercontent com wesm pydata-book master ch08 tips csv   sep      groupedvalues df groupby  day   sum   reset index   groupedvalues groupedvalues sort values  total bill   reset index   g sns barplot x  day  y  tip  data groupedvalues  palette  Blues

[python] Seaborn Barplot - Displaying Values

Examples related to python

Examples related to pandas

Examples related to matplotlib

Examples related to seaborn