How to highlight rows or string in one dataframe based off the values of a column in a different datafame?

Question

I want to be able take vales from one column of dataframe and find the exact same values in another dataframe to either highlight the whole row or just the string (whatever is easier/possible).

dataset1 = {'Gene Name':['ampC','fliC','ompC','fruB','yobH','gltP','ruvA','yacC','folD'],
       'FoldChange':['4.54','5.65','7.89','6.45','10.67','4.63','2.65','9.45','5.79'],
        'pvalue':['0','0','0','0','0','0','0','0','0']}

df1= pd.DataFrame(dataset1)

dataset2 = {'Gene Name':['gltP','ruvA','yacC','folD']}

df2 = pd.DataFrame(dataset2)

If it is possible I would like to make something that would look like either of the bottom examples.

I've tried a bunch of different stuff but I'm still learning python so not sure how to do this.

Timeless · Accepted Answer · 2023-12-28 21:08:20Z

2

You can check if the genes of df1 isin those of df2, then apply your CSS style :

m = df1["Gene Name"].isin(df2["Gene Name"])

def fn(ser, how):
    import numpy as np
    return np.where(m, f"{how}: red", "")
    
# choose one of the two
left = df1.style.apply(fn, how="color", subset=["Gene Name"])
right = df1.style.apply(fn, how="background-color")

# .to_excel("output.xlsx", index=False) # to save an Excel

Preview of both :

answered Dec 28, 2023 at 21:08

Timeless

38.3k6 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Melissa Arroyo-Mendoza Over a year ago

This worked! Thank you so much, they way you wrote the solution was very clear and easy for me to understand.

Collectives™ on Stack Overflow

How to highlight rows or string in one dataframe based off the values of a column in a different datafame?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related