Coloring Single Column Of Pandas Dataframe.to_html()

Before this is marked as duplicate, I have tried the code from the following topics and none has worked for me thus far: [Colouring one column of pandas dataframe ] [Format the co

Solution 1:

Let's try this:

import pandas as pd
import numpy as np

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)
df.iloc[0, 2] = np.nan

defhighlight_column(s, col):
    return ['background-color: #d42a2a'if s.name == col else''for v in s.index]

df.style.apply(highlight_column, col = 'B')

Output:

Solution 2:

If anyone is using BeautifulSoup to parse a website and then using pandas to create a DataFrame that you may want to add styles to, you can do something like:

(before using this you have already; imported beautifulsoup, scraped your site and created your dataframe)

variable_name = beautifulsoup(dataframe_name.to_html())

list = []

`fortableinvariable_name.findAll('table'):`

  `fortbodyinvariable_name.findAll('table'):`

    `fortdinvariable_name.findAll('tbody'):`

         `list.append(td)`

list[td_index]['attribute_name'] = 'attribute_value'

This will add your all your table data to a list and you can select any element from that list and add/update a tag attribute

(if more efficient way please comment to help improve)