Highlight Pandas DataFrame's specific columns using apply()

Highlight Pandas DataFrame's specific columns using applymap()

Last Updated : 17 Aug, 2020

Let us see how to highlight elements and specific columns of a Pandas DataFrame. We can do this using the applymap() function of the Styler class.

Styler.applymap()

Syntax : Styler.applymap(self, func, subset = None, **kwargs) Parameters :

func : takes a scalar and returns a scalar.

subset : valid indexer to limit data to before applying the function.

**kwargs : dict pass along to func.

Returns : Styler

Let's understand with examples:

First of all create a simple data frame:

python3

# importing pandas as pd 
import pandas as pd 

# creating the dataframe  
df = pd.DataFrame({"A" : [14, 4, 5, 4, 1], 
                   "B" : [5, 2, 54, 3, 2],
                   "C" : [20, 20, 7, 3, 8],
                   "D" : [14, 3, 6, 2, 6]}) 

print("Original DataFrame :")
display(df)

Output :

Example 1 : For every cell in the DataFrame, if the value is less than 6 then we will highlight the cell with red color, otherwise with blue color.

Python3

# function definition
def highlight_cols(s):
    color = 'red' if s < 6 else 'blue'
    return 'background-color: % s' % color

# highlighting the cells
display(df.style.applymap(highlight_cols))

Output :

Example 2 : This time we will highlight only the cells in some specified columns.

Python3

# function definition
def highlight_cols(s):
    return 'background-color: % s' % 'yellow'

# highlighting the cells
display(df.style.applymap(highlight_cols, 
                          subset = pd.IndexSlice[:, ['B', 'C']]))

Output :

Highlight specific columns with the help of Indexing:

Python3

df.style.applymap(highlight_cols, subset = pd.IndexSlice[:, ['B', 'C']])

Highlight Pandas DataFrame's specific columns using apply()

kumar_satyam

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Highlight Pandas DataFrame's specific columns using apply()

Let us see how to highlight specific columns of a Pandas DataFrame. We can do this using the apply() function of the Styler class. Styler.apply() Syntax : Styler.apply(func, axis = 0, subset = None, **kwargs) Parameters : func : function should take a Series or DataFrame (depending on-axis), and ret

Apply uppercase to a column in Pandas dataframe

Analyzing a real world data is some what difficult because we need to take various things into consideration. Apart from getting the useful data from large datasets, keeping data in required format is also very important. One might encounter a situation where we need to uppercase each letter in any

Select Columns with Specific Data Types in Pandas Dataframe

In this article, we will see how to select columns with specific data types from a dataframe. This operation can be performed using the DataFrame.select_dtypes() method in pandas module. Syntax: DataFrame.select_dtypes(include=None, exclude=None)Parameters :Â include, exclude : A selection of dtypes

Apply a function to single or selected columns or rows in Pandas Dataframe

In this article, we will learn different ways to apply a function to single or selected columns or rows in Dataframe. We will use Dataframe/series.apply() method to apply a function. Apply a function to single row in Pandas DataframeHere, we will use different methods to apply a function to single r

Apply a function to each row or column in Dataframe using pandas.apply()

Let's explore how to use the apply() function to perform operations on Pandas DataFrame rows and columns.pandas.DataFrame.apply() method is used to apply a function along the axis of a DataFrame (either rows or columns). Syntax: DataFrame.apply(func, axis=0, raw=False, result_type=None, args=None, *

How to Select Single Column of a Pandas Dataframe

In Pandas, a DataFrame is like a table with rows and columns. Sometimes, we need to extract a single column to analyze or modify specific data. This helps in tasks like filtering, calculations or visualizations. When we select a column, it becomes a Pandas Series, a one-dimensional data structure th

Reading specific columns of a CSV file using Pandas

When working with large datasets stored in CSV (Comma-Separated Values) files, itâ€™s often unnecessary to load the entire dataset into memory. Instead, you can selectively read specific columns using Pandas in Python.Read Specific Columns From CSV FileLet us see how to read specific columns of a CSV

Insert a given column at a specific position in a Pandas DataFrame

In this comprehensive guide, we will leverage the powerful DataFrame.insert() the method provided by the Pandas library to effectively Insert a given column at a specific position in a Pandas Dataframe. Create a Sample DataFrame In this example below code uses Pandas to create a DataFrame named 'df'

How to display bar charts in Pandas dataframe on specified columns?

In this article we will see how to display bar charts in dataframe on specified columns. For doing this task we are using DataFrame.style.bar() method of Pandas Dataframe. Syntax: pandas.DataFrame.style.bar(columns_list, color) Return: Dataframe with the given color bar strips on the positive defini

Apply String Methods Across Multiple Columns in a Pandas DataFrame

We are given a dataframe in Pandas with multiple columns, and we want to apply string methods to transform the data within these columns. In this article, we will explore three different approaches to applying string methods to multiple columns of a dataframe. Apply String Methods to Multiple Column