pandas_df_highlighting.py

"""Example pulled from pandas docs for highlights 
the highest number in each columns to illustrate the 
experimental DataFrame.style api.
"""

import pandas as pd

df = pd.DataFrame.from_dict({'Medications': {'By Alphabetical': 7.7914173413117429e-05,
  'By Diagnosis': 0.12608248612763967,
  'By Occurrences': 0.024339338681789544},
 'Procedures': {'By Alphabetical': 0.047130071746056358,
  'By Diagnosis': 0.61378383651360346,
  'By Occurrences': 0.47103678987544501}})
  
def highlight_max(s):
    '''
    highlight the maximum in a Series yellow.
    '''
    is_max = s == s.max()
    return ['background-color: yellow' if v else '' for v in is_max]

df.applymap(lambda n: "{:.2f}".format(n)).style.apply(highlight_max)