The data frame is a transaction database. It include: category, time, merchant, vendor, amount columns. I want to group any transactions that have the keywords "travel", "airbnb", "airlines", "uber", "Lyft" (in any columns, these keywords can exist in either merchant or vendor or both) with the accordant amount.
How can I do it ?