Python Pandas: Highlight matching text and row

by

You can format conditionally rows or cells containing this text, e.g. as per below example. I don’t think you will be able to highlight in red just the part of the text (well, unless you want to go into significant hacks of reparsing entire html, which I’m not even sure would be possible). Refer to the Styler documentation.

import pandas as pd

df1 = [ 'i like to shop at store a.' , 'he likes to shop at the store b.', 'she is happy to shop at store c.', 'we want to shop at the store d.']
df2 = [ 'store a', 'store b', 'store c', 'store d' ]
df3 = [ 'like to', 'likes to shop', 'at store' ]

myDataSet = list(zip(df1,df2))
df = pd.DataFrame(data = myDataSet, columns=['df1', 'df2'])

def in_statements(val):
    for statement in df3:
        if statement in val:
            color="yellow"
            break
        else:
            color="black"
    return 'background-color: %s' % color

df = df.style.applymap(in_statements)

df

Why deal with the styling fuzz anyways? 🙂 not better just to add an extra column which extracts the text which is interesting for you? (or blank if it’s not there)

Edit:
Per request, a way to achieve the objective without styling limitations, by adding an extra column:

def check(df):
    df["Statements"] = ", ".join(
        [x for x in df3 if x in df["df1"].to_string()])
    return df

df = df.groupby("df1").apply(lambda dfx: check(dfx))
df

More Related Contents:

  1. Apply multiple functions to multiple groupby columns
  2. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. How to add pandas data to an existing csv file?
  5. How do I operate on a DataFrame with a Series for every column?
  6. Pandas split column into multiple columns by comma
  7. Repeat rows in a pandas DataFrame based on column value
  8. Accessing every 1st element of Pandas DataFrame column containing lists
  9. How to use groupby to concatenate strings in python pandas?
  10. Horizontal stacked bar plot and add labels to each section
  11. How to flatten a nested JSON recursively, with flatten_json
  12. Python – How to convert JSON File to Dataframe
  13. How to remove timezone from a Timestamp column in a pandas dataframe
  14. Pandas lookup from one of multiple columns, based on value
  15. How to add a suffix (or prefix) to each column name?
  16. dropping rows from dataframe based on a “not in” condition [duplicate]
  17. How to delete multiple pandas (python) dataframes from memory to save RAM?
  18. Adding two Series with NaNs
  19. Resampling Within a Pandas MultiIndex
  20. Absolute value for column in Python
  21. Find element’s index in pandas Series
  22. selecting across multiple columns with pandas
  23. How to read a Parquet file into Pandas DataFrame?
  24. What is as_index in groupby in pandas?
  25. pd.to_datetime is getting half my dates with flipped day / months
  26. How to install pandas from pip on windows cmd?
  27. Seaborn factor plot custom error bars instead of bootstrapping
  28. Convert hh:mm:ss to minutes using python pandas
  29. Using regex matched groups in pandas dataframe replace function
  30. How to get number of groups in a groupby object in pandas?

Leave a Comment