Using Dictionary to search values , print keys and plot graph

[Afrin]

I am using dictionary with words and corresponding three numeric values. I have to search words in processed corpus file .I have to get output with all words and key that are present in processed corpus file. I have tried all dictionary I am not able to implement.

[ScottF]

Hi @Afrin and welcome to the forum.

I’m not 100% sure what you want to do here. I gather you want to apply numeric tags based on your dictionary, and then ultimately you want to… filter so that only those tagged words remain in your processed documents? I don’t think I’m understanding the problem correctly.

Could you post some dummy datasets with your sample inputs and desired outputs?

[Afrin]

I am doing Emotion Analysis. I have a corpus file consisting of 3 columns Lyrics ,SNO and song name. Plus I have ANEW dictionary consisting of Words and its corresponding Valence, Dominance and Arousal values. The three values depict emotion for a particular word

• I have cleaned Corpus file.

• I have to search (Words) of ANEW dictionary from Corpus file(Lyrics Column)

• If the word is present in Corpus file ,then I have to get its Valence ,Arousal and Dominance values.

• There are 26 Lyrics in Corpus file ,so I need to print all words and its valence ,arousal & dominance values present in Corpus .
  Expected output
  SNO | word| Valence| Arousal | Dominance

[ScottF]

Here’s something that may help. I went ahead and made up some data formatted similar to yours to test it out:

SongLyricExample.knwf (34.4 KB)

If you have any questions, just ask.

[Afrin]

Thanks very much for your kind help. I just want to confirm selecting source from String to Document operator and source option from Data Document Extractor helped in getting the SNO.