Python: How to Bold and Color only the First Line in cell in Excel

user_19759644 0
Viewed 39

There is a table shows as following, each cell of "Description" column contains multiple lines of description about the product. I want to change the first line in each cell font to bold and color in red, and then export the worksheet to a new file.

Product Description
P1 Line 1
Line 2
Line 3
P2 Line 1
Line 2
Line 3
P3 Line 1
Line 2
Line 3		 
import pandas as pd
df = pd.read_excel(fileLocation)
df.style.set_properties(subset=['Description'], **{'font-weight': 'bold', 'color': 'red'}).to_excel('newFile.xlsx', engine='openpyxl')

I am using Python and Pandas moudle. Above code segment bold and color all the lines in cell. Is there a way to only bold and color the first line in cell? Or is there any other moudle can help with?

pandas excel python
1 Answers

Use:

df['Description'] = df['Description'].str.split('\n')
df1 = df.explode('Description')
df1['r'] = range(len(df1))
df1 = df1.set_index(['Product', 'r'])
def coloring(x):
    c1 = 'color: red'
    c = '' 
    mask1 = x['Description'] == 'Line 1'
    df1 =  pd.DataFrame(c, index=x.index, columns=x.columns)
    df1.loc[mask1, 'Description'] = c1
    return df1

df1 = df1.style.apply(coloring, axis=None)

Output:

enter image description here

user_72816750
Related