How to use Pandas stylers for coloring an entire row based on a given column?

by

This solution allows for you to pass a column label or a list of column labels to highlight the entire row if that value in the column(s) exceeds the threshold.

import pandas as pd
import numpy as np

np.random.seed(24)
df = pd.DataFrame({'A': np.linspace(1, 10, 10)})

df = pd.concat([df, pd.DataFrame(np.random.randn(10, 4), columns=list('BCDE'))],
               axis=1)
df.iloc[0, 2] = np.nan

def highlight_greaterthan(s, threshold, column):
    is_max = pd.Series(data=False, index=s.index)
    is_max[column] = s.loc[column] >= threshold
    return ['background-color: yellow' if is_max.any() else '' for v in is_max]


df.style.apply(highlight_greaterthan, threshold=1.0, column=['C', 'B'], axis=1)

Output:

enter image description here

Or for one column

df.style.apply(highlight_greaterthan, threshold=1.0, column='E', axis=1)

enter image description here

More Related Contents:

  1. Conditionally format Python pandas cell
  2. pandas to_html using the .style options or custom CSS?
  3. Export pandas Styled table to image file
  4. Pandas style function to highlight specific columns
  5. Select nan column in pandas
  6. How to identify and label similar rows in a pandas data frame
  7. How do I read a large csv file with pandas?
  8. How can I use the apply() function for a single column?
  9. Pandas filtering for multiple substrings in series
  10. Remove duplicates by columns A, keeping the row with the highest value in column B
  11. How can I display full (non-truncated) dataframe information in HTML when converting from Pandas dataframe to HTML?
  12. Pandas: conditional rolling count
  13. pandas: to_numeric for multiple columns
  14. group by pandas dataframe and select latest in each group
  15. Access to table objects on Webpage Using Python Selenium
  16. How to flatten a hierarchical index in columns
  17. Most efficient way to sort an array into bins specified by an index array?
  18. UnicodeDecodeError: (‘utf-8’ codec) while reading a csv file [duplicate]
  19. Transform vs. aggregate in Pandas
  20. Writing large Pandas Dataframes to CSV file in chunks
  21. NumPy version of “Exponential weighted moving average”, equivalent to pandas.ewm().mean()
  22. Split pandas dataframe based on values in a column using groupby
  23. How to remove decimal points in pandas
  24. FutureWarning: The default value of regex will change from True to False in a future version
  25. Pretty print a pandas dataframe in VS Code
  26. Transpose the data in a column every nth rows in PANDAS
  27. Merging two tables with millions of rows in Python
  28. Selecting a range of columns in a dataframe
  29. Pandas data frame to dictionary of lists
  30. Pandas min() of selected row and columns

Leave a Comment