Conditionally format Python pandas cell

by

From the style docs:

You can apply conditional formatting, the visual styling of a
DataFrame depending on the data within, by using the DataFrame.style
property.

import pandas as pd
df = pd.DataFrame([[2,3,1], [3,2,2], [2,4,4]], columns=list("ABC"))

df.style.apply(lambda x: ["background: red" if v > x.iloc[0] else "" for v in x], axis = 1)

enter image description here

Edit: to format specific cells, you can add condition checkers to check the name of element with Series.iteritems() or check the index with enumerate(), e.g. if you want to format starting from column 3, you can use enumerate and check the index:

df = pd.DataFrame([[2,3,-3], [3,2,7], [2,4,4]], columns=list("ABC"))

df.style.apply(lambda x: ["background-color: #ff33aa" 
                          if (i >= 2 and (v > x.iloc[0] + x.iloc[1] 
                                          or v < x.iloc[0] - x.iloc[1])) 
                          else "" for i, v in enumerate(x)], axis = 1)

enter image description here

More Related Contents:

  1. How to iterate over rows in a DataFrame in Pandas
  2. Difference between map, applymap and apply methods in Pandas
  3. Pandas filtering for multiple substrings in series
  4. Python pandas insert list into a cell
  5. How to replace text in a string column of a Pandas dataframe?
  6. Combine two pandas Data Frames (join on a common column)
  7. Pandas DataFrame Groupby two columns and get counts
  8. Pandas dataframe get first row of each group
  9. pandas .at versus .loc
  10. How to deal with multi-level column names downloaded with yfinance
  11. Replace all occurrences of a string in a pandas dataframe (Python)
  12. Running get_dummies on several DataFrame columns?
  13. Selection with .loc in python
  14. How to flatten a hierarchical index in columns
  15. Add column to dataframe with constant value
  16. ‘DataFrame’ object has no attribute ‘sort’
  17. python pandas – creating a column which keeps a running count of consecutive values
  18. Turn Pandas Multi-Index into column
  19. Selecting/excluding sets of columns in pandas [duplicate]
  20. What is the fastest and most efficient way to append rows to a DataFrame?
  21. Creating an empty Pandas DataFrame, and then filling it
  22. Reverse a get_dummies encoding in pandas
  23. pandas divide row value by aggregated sum with a condition set by other cell
  24. Check if rows in one dataframe exist in another dataframe
  25. Pretty print a pandas dataframe in VS Code
  26. Pandas – Interleave / Zip two DataFrames by row
  27. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  28. Remove ends of string entries in pandas DataFrame column
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment