How to map two dataframes on basis of synonyms? I tried using synset, but it wasn't exhaustive

Asked Jul 25 '18 at 19:38

Active Jul 25 '18 at 20:14

Viewed 132 times

Example

Dataframe: A

 Word_A Frequency
0 Large       10
1 Happy       15

Dataframe: B

  Word_B Document                   
0 Big        1                   
1 Huge       1
2 Great      2
3 Cheerful   1
4 Merry      3
5 Joyful     2

Resulting Dataframe: C

(The words in Dataframe A have been mapped to their synonyms in Dataframe B)

  Word_A  Word_B   Frequency Document
0 Large   Big       10         1
1 Large   Huge      10         1
2 Large   Great     10         2
3 Happy   Cheerful  15         1
4 Happy   Merry     15         3
5 Happy   Joyful    15         2

edited Jul 25 '18 at 20:14

asked Jul 25 '18 at 19:38

Harjyot Kaur

1

Love the formatting of your code... – rahlf23 Jul 25 '18 at 19:39
Check out: https://stackoverflow.com/questions/5618304/looking-for-thesaurus-data – xyzjayne Jul 25 '18 at 20:32

How to map two dataframes on basis of synonyms? I tried using synset, but it wasn't exhaustive

0 Answers0