/Python/How to change colour of rows in csv using pandas

How to change colour of rows in csv using pandas

import numpy as np
import pandas as pd


df = pd.DataFrame([[8484,-1.15],[1390,3.5],[327,10.5],[1135,3.3],[6499,2.0],[1055,4.0]], columns=['data1','dat2'])


def color_rule(val):
    return ['background-color: red' if x >= 3 else 'background-color: yellow' for x in val]

html_column = df.style.apply(color_rule, axis=1, subset=['dat2'])

html_column.to_excel('styled.xlsx', engine='openpyxl')

html_column

Source: stackoverflow.com

How to change colour of rows in csv using pandas

import numpy as np
import pandas as pd


df = pd.DataFrame([['ex1',8484,-1.15],['ex2',1390,3.5],['ex3',327,10.5],['ex4',1135,3.3],['ex5',6499,2.0],['ex6',1055,4.0]], columns=['tag','data1','dat2'])


def color_rule(tag):
    var1 = df['dat2'][df['tag'] == tag.values[0]]
    return ['background-color: red' if x >= 3 else 'background-color: yellow' for x in var1]

html_column = df.style.apply(color_rule, axis=1, subset=['tag'])

html_column.to_excel('styled.xlsx', engine='openpyxl')

Source: stackoverflow.com

Similar codes

0 vote173 views2 answers
Install cairo python
Python
0 vote197 views1 answer
Van first name van second name van last name
Python
1 vote185 views1 answer
ValueError: Failed to convert a NumPy array to a Tensor (Unsupported object type float).
Python
0 vote176 views1 answer
How to fix invalid salt in python flask
Python
0 vote161 views1 answer
Read api from django
Python
-3 votes201 views1 answer
ImportError: cannot import name 'SGD' from 'keras.optimizers' (/usr/local/lib/python3.7/dist-packages/keras/optimizers.py) site:stackoverflow.com
Python
0 vote156 views1 answer
Pyqt5 how to check if a push button is triggered
Python
0 vote183 views1 answer
Module not found after sucessful install
Python
0 vote172 views1 answer
PyQT5 reset color
Python
0 vote156 views1 answer
Python list fill nan
Python