I want to highlight some values into a dataframe. I need to compare 2 columns on different dataframes (df1 and df2) then highlight the values that are duplicated and show them inside the first dataframe, df1.

To give you and idea, in excel you can achive this by using a countif formula, here is a video:

https://www.youtube.com/watch?v=VhECzNIQTIY

There’s any way to do this with pandas? or python in general.

Thanks!

Source: Python Questions