w3resource

Pandas styling Exercises: Write a Pandas program to display the dataframe in Heatmap style


11. Display DataFrame in Heatmap Style

Create a dataframe of ten rows, four columns with random values. Write a Pandas program to display the dataframe in Heatmap style.

Sample Solution :

Python Code :

import pandas as pd
import numpy as np
import seaborn as sns

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)
print("Original array:")
print(df)
print("\nDataframe - Heatmap style:")

cm = sns.light_palette("red", as_cmap=True)
 
df.style.background_gradient(cmap='viridis') 

Original array:

Original array:
      A         B         C         D         E
0   1.0  1.329212 -0.770033 -0.316280 -0.990810
1   2.0 -1.070816 -1.438713  0.564417  0.295722
2   3.0 -1.626404  0.219565  0.678805  1.889273
3   4.0  0.961538  0.104011 -0.481165  0.850229
4   5.0  1.453425  1.057737  0.165562  0.515018
5   6.0 -1.336936  0.562861  1.392855 -0.063328
6   7.0  0.121668  1.207603 -0.002040  1.627796
7   8.0  0.354493  1.037528 -0.385684  0.519818
8   9.0  1.686583 -1.325963  1.428984 -2.089354
9  10.0 -0.129820  0.631523 -0.586538  0.290720

Dataframe - Heatmap style:

Sample Output:

Python Pandas: pandas styling exercise-11 output

Download the Jupyter Notebook from here.


For more Practice: Solve these Related Problems:

  • Write a Pandas program to render a dataframe as a heatmap using a gradient of colors to indicate value density.
  • Write a Pandas program to apply a background gradient to a dataframe to simulate a heatmap based on cell values.
  • Write a Pandas program to convert a dataframe into a heatmap style table using the background_gradient() method.
  • Write a Pandas program to style a dataframe with a heatmap effect that visually represents data magnitude using colors.

Go to:


Previous: Create a dataframe of ten rows, four columns with random values. Write a Pandas program to highlight the entire row in Yellow where a specific column value is greater than 0.5.

Next: Create a dataframe of ten rows, four columns with random values. Write a Pandas program to make a gradient color mapping on a specified column.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.