Breaking News: Grepper is joining You.com. Read the official announcement!

how to change colour of rows in csv using pandas

Open Octopus answered on October 30, 2021 Popularity 3/10 Helpfulness 8/10

answer how to change colour of rows in csv using pandas

related how to change colour of rows in csv using pandas

how to change colour of rows in csv using pandas

Comment

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

Popularity 3/10 Helpfulness 8/10 Language python

Source: stackoverflow.com

Tags: csv pandas python using

Link to this answer
Share Copy Link

Contributed on Oct 30 2021

Open Octopus

0 Answers Avg Quality 2/10

Closely Related Answers

how to change colour of rows in csv using pandas

Comment

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')

Popularity 3/10 Helpfulness 8/10 Language python

Source: stackoverflow.com

Tags: using python pandas csv

Link to this answer
Share Copy Link

Contributed on Oct 30 2021

Open Octopus

0 Answers Avg Quality 2/10

how to change colour of rows in csv using pandas

Contents

More Related Answers

how to change colour of rows in csv using pandas

Closely Related Answers

how to change colour of rows in csv using pandas

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.