Change the color of text within a pandas dataframe html table python using styles and css

by

Using pandas new styling functionality (since 0.17.1):

import numpy as np
import pandas as pd

arrays = [['Midland', 'Midland', 'Hereford', 'Hereford', 'Hobbs','Hobbs', 'Childress',
           'Childress', 'Reese', 'Reese', 'San Angelo', 'San Angelo'],
          ['WRF','MOS','WRF','MOS','WRF','MOS','WRF','MOS','WRF','MOS','WRF','MOS']]
tuples = list(zip(*arrays))
index = pd.MultiIndex.from_tuples(tuples)
df = pd.DataFrame(np.random.randn(12, 4), index=arrays,
                  columns=['00 UTC', '06 UTC', '12 UTC', '18 UTC'])


def highlight_MOS(s):
    is_mos = s.index.get_level_values(1) == 'MOS'
    return ['color: darkorange' if v else 'color: darkblue' for v in is_mos]

s = df.style.apply(highlight_MOS)
s

enter image description here

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. How to change the order of DataFrame columns?
  3. Add missing dates to pandas dataframe
  4. Python Pandas – Find difference between two data frames
  5. Pandas: sum DataFrame rows for given columns
  6. Rename Pandas DataFrame Index
  7. Pandas DataFrame: replace all values in a column, based on condition
  8. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  9. Calculate average of every x rows in a table and create new table
  10. How to check if any value is NaN in a Pandas DataFrame
  11. Convert row to column header for Pandas DataFrame,
  12. Application not picking up .css file (flask/python) [duplicate]
  13. Removing prefix from column names in Pandas
  14. Select multiple ranges of columns in Pandas DataFrame
  15. pandas – filter dataframe by another dataframe by row elements
  16. Python Pandas replicate rows in dataframe
  17. Left justify string values in a pandas DataFrame
  18. Can’t drop NAN with dropna in pandas
  19. Override global variable inside function not working with Spyder 4
  20. How to merge multiple dataframes
  21. How can I get a value from a cell of a dataframe?
  22. Extract int from string in Pandas
  23. Find difference between two data frames
  24. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  25. append dictionary to data frame
  26. Convert pandas DataFrame into list of lists [duplicate]
  27. Got continuous is not supported error in RandomForestRegressor
  28. Replace NaN with empty list in a pandas dataframe
  29. Get max value from row of a dataframe in python [duplicate]
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment