Home
Discussions
Community Q&A
Keyword extraction from the text field in Excel file
LinaE
I’m new to RapidMiner and would appreciate you help in setting up the process to extract the Keywords from the text field in Excel file (Survey results).
I could extract the KWs using the MonkeyLearn KW extraction extension, but free of charge access allows to make only a certain number of queries each month.
Could anyone suggest an alternative and free of charge way to extract the KWs (which are compounded by one or more words) from an Excel file?
Thank you in advance
Find more posts tagged with
AI Studio
Excel
Text Mining + NLP
Accepted answers
sgenzer
ah ok thx
@LinaE
. So that's a pretty standard text processing case where you would use a series of stopword dictionaries to remove most of the extraneous stuff and then create word vectors for your keywords. There is a
new series of videos on the RapidMiner Academy
that should help.
Scott
All comments
sgenzer
hi
@LinaE
can you please provide a sample of what you're trying to do? It's hard to understand without one.
Scott
LinaE
Thank you, Scott for your replay. Here is an example of how the survey results might look like, and what kind of generated KWs I would expect. I couldn't attache an excel sheet, but I hope the examples below will clarify.
respondent1:
Advantage of raised bed gardening: Plants are often healthier and more productive in a raised bed gardening because you can control the quality of the soil and water drainage.
I would expect the following KWs to be generated:
gardening, plants, raised bed, ...etc...
Respondent 2:
Using a raised bed for growing vegetables allows you to control the soil quality and prevent it from becoming compacted. Vegetable roots can grow unimpeded. The beds do not have to be very high to benefit from being in a raised bed gardening. Soil quality...
Generated KWs (expected):
raised bed, vegetable, soil quality, roots, gardening, ...
Thank you,
Lina
sgenzer
ah ok thx
@LinaE
. So that's a pretty standard text processing case where you would use a series of stopword dictionaries to remove most of the extraneous stuff and then create word vectors for your keywords. There is a
new series of videos on the RapidMiner Academy
that should help.
Scott
nhchocolate96
i'm looking answer for the same question. is there anyone wo can give me idea for this keyword extraction ? i really would like to learn about this. my question is the same with Linae
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)