Textmining with R - inner_join a dictionary list

Hello everybody,

unfortunately I have a problem. My goal is to compare the word frequency from a self-made dictionary with the existing text file. First of all I created the dictionary:

dict <- dictionary (list (first = c ("house *", "mouse *", "like *", "... *")

How can I now determine the word frequency of the existing words from the dictionary from my already tokenized text file (named db_df)? I've already tried an inner join, but unfortunately it didn't work. Have you ever had a case like this?

Hi!

To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one: