I have two dataframes of different lengths, data and freqs. freqs contains word frequencies for nouns listed repeatedly in data, so data looks like:
Session Noun
1 ball
1 bath
1 bed
2 ball
2 bath
2 bed
...
and freqs looks like:
Noun Freq
ball 5177
bath 2176
bed 72681
...
I would like to add a new column to data with word frequencies for each noun (stored in freqs) to every corresponding row in data. The result should look like:
Session Noun Freq
1 ball 5177
1 bath 2176
1 bed 72681
2 ball 5177
2 bath 2176
2 bed 72681
...
Is there a way to do this without manually inputting each value?